Parse Data

Question

Hi All,

Below I have attached one dataset which has one Field as Input.

example : AC:PROCESSING-USR00035149. I have to parse out the Bold part from this.

Note: If you see the dataset the values are not in any standardised pattern and in different rows they are present in a different way. From all the rows we have to Parse out this similar Part. Can someone help me out with this ?

below attached is a sample data.

Parse.yxmd

Jotigautam · Accepted Answer

Attached is a solution using regex. Let me know if this serves the purpose.

binu_acs · Accepted Answer

@DataPirate26 Another way of doing this withe the regex tokenize method

binu_acs · Accepted Answer

@DataPirate26 Updated the workflow

flying008 · Accepted Answer

Hi, @DataPirate26

Don't worry, please use the syntax with parse method by RegEx tool;

AC\:([A-Z|\s]+)-(?<=\-)(\w+)(?=-|\s|$)

******

If this syntax can help you , please mark it as a solution for share more.