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
What I want: Doe, John; Doe, Jane; Smith, John