SOLVED
Parsing Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kaitcoen
5 - Atom
‎07-31-2019
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Parse
2 REPLIES 2
JosephSerpis
17 - Castor
‎07-31-2019
12:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kaitcoen you can use the Regex tool and parse using (\d{5}) as the syntax
‎07-31-2019
12:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, @JosephSerpis! That worked perfectly!