cancel
Showing results for 
Search instead for 
Did you mean: 

Parsing Column in Paxata Dataset

Highlighted
Image Sensor
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
Labels (1)
0 Kudos
2 Replies
Highlighted
Linear Actuator
@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. 
0 Kudos
NiCd Battery
@blains2 as @sayyar mentioned you can use the split function and a regular expression as shown below:


erlgp7slwt02.png
0 Kudos