Parse Tool help

[rrahu07]

Can someone please help me to write a regex code to get column "B" from column "A"

[IraWatt]

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 

[IraWatt · Accepted solution]

@rrahu07 Alternatively you could use:

([^}]+$)

Which would grab all the text which is not a } from the end of the text

[DataNath]

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]),'}'))

[rrahu07]

Hi @DataNath and @IraWatt how can I parse this one?

{http://www.irs.gov/efile}ReturnData/{http://www.irs.gov/efile}IRS1118/1/{http://www.irs.gov/efile}IR...

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?

[IraWatt]

@rrahu07 are you trying to get the bit within the { } ?

[IraWatt]

This method can get the URLs within the {} though they are all the same in this case:

[rrahu07]

@IraWatt I am trying to get element outside of {}

[rrahu07]

ReturnData 

IRS1118

IRS1118ScheduleA

IncmLossBfrAdjFrgnTxsPdAccrGrp

InclusionSection951AGrossUpAmt 

[DataNath]

@rrahu07 how does this look when applied to your data? This uses the RegEx tool in Tokenize mode.

}([A-Za-z0-9]+)