Deleting certain value in a string
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello there,
I need a little help with the data i'm working with.
I need to remove the 9th digit on all records in a text string. The data records in this field is constantly the same length at 12.
Currently the data example is:
BIGAPPLEXABC
EXTARCHSYJSK
LAUNCHEDFRTO
I need Alteryx to remove the bold to then read
BIGAPPLEABC
EXTARCHSJSK
LAUNCHEDRTO
The letters in bold are random and therefore can't Regex replace on a specific letter and has to be a rule that removes the 9th value. I also need the last 3 letters and therefore can't remove the last 4. Any suggestions would be incredibly helpful.
All the best,
George
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's got it, thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi. @JosephSerpis has a formula that works for you needs, but RegEx does work in this cases like this.
See attached workflow as an example. I've broken the 12 random letters into three groups. One with 8 characters, one with 1 character, and one with 3. The replacement is simply the first and 3rd group.
I've always found this site to be really useful when trying to build an expression. I cut and past a bit of text I need to work with, build my expression, and once it's working, copy it into Alteryx. I have a hard time wrapping my head around RegEx most of the times, and the site does a great job of showing what the pattern you're writing is doing and why.
Good luck.