Senario: User need to show Customer ID and Customer Name as Separate fields in transaction saved search.
Solution:
Navigate to Reports > Saved Searches > All Saved Searches > New.
Click Transaction.
Enter the needed filters in the Criteria tab.
Under the Results tab, enter the needed information and add the following:
Formula (Text) | Formula: SUBSTR ({name}, 1,5)
Formula (Text) | Formula: SUBSTR ({name}, 7,40)
Click Preview or Save & Run.
Note: The basic formula could be used in case of other searches.