Parsing using RegEx

[nataliad18]

Hey!

Would you please be able to help me parse. Thought RegEx would be the most useful one, but do let me know of any other options. I need to parse on "/" character.

I.E I have two columns path and points

Path                       Points

Alteryx/Tableau       6

SQL/R                     5

I want these two rows to be split in four, with points halved, meaning, this is the ouput I want:

Path                       Points

Alteryx                     3
Tableau                   3

SQL                        2.5
R                             2.5

Many thanks in advance!

Natalia

[atcodedog05 · Accepted solution]

Hi @nataliad18 

Here is how you can do it.

Workflow:

1. Using formula tool to calculate [Total Points] / [count of words]

2. Using Text to column tool to split Path into rows for each word.

Hope this helps : )

[jdunkerley79]

I suggest first working out the split points: [Points] / (1+REGEX_CountMatches([Path], "/"))

You can then use a Text to columns tool to split on '/' and make new rows

Sample attached

[nataliad18]

thanks, worked perfectly! accepted as a solution 🙂 

[atcodedog05]

Happy to help : ) @nataliad18 

Cheers and have a nice day!