Scenario: User wants to pull up the Sales Description field with no spaces.
Solution:
Navigate to Reports > Saved Searches > All Saved Searches > New
Select Transaction
On the Criteria tab > Standard subtab, add the following filters:
Filter:
Select Type (select the Item Types you want to include in the search results. Example: Assembly/Bill of Materials, Inventory Item)
On the Results tab > Sort By: Name
Field:
Note: For every required field, use the drop-down menu to select it and once adjusted, click Add if needed.
Select Name
Select Formula (Text)
Formula: replace({description}, ‘ ‘, ”)
Custom Label: Item Description
Click Save & Run
Note: In case you want to pull up any character (eg: &) then change the to ({description}, ‘&’, ”)