What Regex formula would I use to parse

[sabrinasaavedra]

I need to separate this field "Melissa Nelson|Front Desk" into two separate fields (i.e. Melissa Nelson goes into one column and Front Desk" goes into a second column)? I think I'm supposed to use RegEx, but I'm struggling with the formula.

[Qiu · Accepted solution]

@sabrinasaavedra 
A Text to Columns Tool is more straightforward in this case.

Of couse RegEx would do it as well.

[atcodedog05 · Accepted solution]

Hi @sabrinasaavedra 

As @Qiu  mentioned Text to column is suggestable.

But regex gives you can extra advantage to rename the column in the same tool. 

Here is a workflow for the task.

Output:

Config:

You can rename, set datatype in the highlighted config

Regex:

(.*)\|(.*)

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[vizAlter]

Hi @sabrinasaavedra — I am not sure why do you want to go with RegEx.

btw, did you try "Text To Column" tool?

If this assists please mark the answer "Solved", if not let me know!

[atcodedog05]

Happy to help 🙂 @sabrinasaavedra 

Cheers and Happy Analyzing 😀

[MarqueeCrew]

@sabrinasaavedra ,

 the solution provided by @Qiu  is straightforward and should help others understand how to solve this challenge. I'm a huge fan of regular expressions to solving unstructured data challenges.  It is important to understand how to solve using strong functions and the use of parsing tools too. 

cheers,

 mark

[atcodedog05]

Hi @MarqueeCrew 

I can see the issue might be @Qiu regex is not giving the expected output the values arent same.

his output:

expected output:

I guess thats why @sabrinasaavedra  didnt mark it as solution.

But i got to agree @Qiu is a pretty helpful, amazing and dedicated solution author 🙂

Cheers and Happy Analyzing 😀

[Qiu]

@MarqueeCrew @atcodedog05 
Thank you for the comment.

Just realized where I made a mistake. It felt good that someone is wiling to tell you when are you wrong.

Appreciate it.

@sabrinasaavedra 
Thank you for the mark, I take it for the Text To Column part. hehe😁