Parse Tool help
- 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
Can someone please help me to write a regex code to get column "B" from column "A"
Solved! Go to Solution.
- Labels:
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @rrahu07,
I would use this:
(\w+$)
The $ means end of text, so it grabs all the word characters at the end of the string:
If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rrahu07 Alternatively you could use:
([^}]+$)
Which would grab all the text which is not a } from the end of the text
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Already got a perfectly viable solution but just thought I'd post this alternative - in the latest Alteryx & Beer chat, @MarqueeCrew mentioned how computationally expensive RegEx is/can get and so I've been keen to play around with standard String functions recently for scenarios with more structure:
Right([Name], FindString(ReverseString([Name]),'}'))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DataNath and @IraWatt how can I parse this one?
I am trying to get
{http://www.irs.gov/efile}ReturnData/{http://www.irs.gov/efile}IRS1118/1/{http://www.irs.gov/efile}IRS1118ScheduleA/{http://www.irs.gov/efile}IncmLossBfrAdjFrgnTxsPdAccrGrp/5/{http://www.irs.gov/efile}InclusionSection951AGrossUpAmt in four different column.
can you please help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rrahu07 are you trying to get the bit within the { } ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This method can get the URLs within the {} though they are all the same in this case:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt I am trying to get element outside of {}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ReturnData
IRS1118
IRS1118ScheduleA
IncmLossBfrAdjFrgnTxsPdAccrGrp
InclusionSection951AGrossUpAmt
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rrahu07 how does this look when applied to your data? This uses the RegEx tool in Tokenize mode.
}([A-Za-z0-9]+)
