Hello,
Does anyone know of a way to parse data based on a unique identifier in report designer.
For example: In one field of a report, Order Description, we want to parse the data using report designer where there is a unique identifier. When the description has a ; we want to add a line break on the report to put the value after the ; on a second row.
Order Description: Ship This Today; UPS Ground
We want the report to display the values as;
Line 1: “Ship This Today” (Line Break based on the unique identifier ; )
Line 2: “UPS Ground”
