Hi,
I am trying to use the RegEx tool to parse data. This is my first time using RegEx, so naturally, everything looks alien to me here. I have a dataset with a column I would like to separate into three columns; a name, a capital letter, and a number. The data currently looks like this:
Annie,F,1258
I read an introduction post to parsing with RegEx, so I get the basics, but I can't figure out why the expression I have included won't parse the way I want it to. At first, I only included an expression to parse out the name: which worked perfectly! Then, I added an expression to parse out the capital letter after the name as well, and now I am only seeing null values. See picture below. Any ideas as to how I should formulate my expression?
Solved! Go to Solution.
Hi @mina_ran
The easiest way here is definitely text to columns, like @Ladarthure had, as you have comma separating your data points.
I thought I'd just give you a quick idea of how the regex works though, for your understanding.
Hope this gives you a little bit of an idea. The best place to practice regex is www.regex101.com . This will highlight your text as your going showing exactly what each part of your code is doing. I use it all the time.
Thank you @Ladarthure and @kat for your help! Looks like i forgot to add a , between the expressions and that's why I only got null values. All good now :)