Monday, September 24, 2018

Remove HTML formatting when Exporting Item Detailed Description Search Results to Excel

To remove HTML formatting, Kindly follow the steps Below:
1. Navigate to List > Search > Saved Searches.
2. Edit the Saved Search.
3. Click the Result tab.
4. Under field Column, Add Formula (Text)
5. In the Formula Column, Enter REGEXP_REPLACE({storedetaileddescription},'<[^<>]*>','')
6. Click Save and Run.

Note:  HTML tags will not be included in the exported file.

No comments:

Post a Comment