Hi! I am trying to parse a column in Paxata. I need to remove ;# and the numbers. It's pulling from a SharePoint list that has user links so it add these in between the names. I put the example down below. Any help would be greatly appreciated!
Example: 48;#Doe, John;#586;#Doe, Jane;#694:#Smith, John
@blains2 In the import workflow we do not have an option to perform this as the data is coming in from a SharePoint List. However, you could use the "Split" or "Find & Replace" tools to remove the numbers and other characters.