Parsing Data

[kaitcoen]

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!

[JosephSerpis · Accepted solution]

Hi @kaitcoen you can use the Regex tool and parse using (\d{5}) as the syntax

[kaitcoen]

Thank you, @JosephSerpis! That worked perfectly!