Extract value between special charachter

[Sshasnk]

I have dataset which I have to extract between 1st and 2nd "_"

Input: 

Name_Id

Mutual Fund - ABC_Instant -123_corporation.xlsx

Credit Fund - ABC_Sell -123_corporation.xlsx

Credit Fund_Sell -123_corporation.xlsx

Output:

Name_Id

Instant -123

Sell -123

Sell -123

[IraWatt]

Hey @Sshasnk,

Probably the best way to do this is with the text to columns tool with _ as the delimiter:

Then just drop the exstra columns with a select tool:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[IraWatt]

@Sshasnk definitely check out the getting started learning path on the community it has some great and quick interactive videos which will help you get started with the basic tools in Alteryx: Interactive Lessons - Alteryx Community

[binu_acs]

@Sshasnk One way of doing this 

[CarliE]

@Sshasnk 

You can also use the regex tool 

if this helped to solve your problem, please be sure to mark it as a solution.