This content has been marked as final. Show 2 replies
You can use a split calculation, right click on the client field and select custom split:
Then use : as your separator to get the first and last columns.
Thanks and please see attached workbook.
Splitv10.2.twbx 19.7 KB
Thanks Mavis! this is great