I have a string column (examples of some rows below) where I would like to parse the first 5 characters into a new column. An added bonus would be if I could only parse the first 5 numerical characters because, as you see below, I have some rows that aren't the same setup.
Column A
15000 Line 5 Interest
20000 Line 10 Other Income
Case
Line 1 Elims (All Appt)
Any tips on parsing are appreciated as it's an area I struggle with!
Solved! Go to Solution.
Hi @kaitcoen you can use the Regex tool and parse using (\d{5}) as the syntax
Thank you, @JosephSerpis! That worked perfectly!