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.
@sabrinasaavedra A Text to Columns Tool is more straightforward in this case.
Of couse RegEx would do it as well.
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 😀👍
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!
Happy to help 🙂 @sabrinasaavedra
Cheers and Happy Analyzing 😀
@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
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 🙂
