Extract value between special charachter

Question

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

Input:

Name_IdMutual Fund - ABC_Instant -123_corporation.xlsxCredit Fund - ABC_Sell -123_corporation.xlsxCredit Fund_Sell -123_corporation.xlsx

Output:

Name_IdInstant -123Sell -123Sell -123

CarliE · Answer

@Sshasnk

You can also use the regex tool

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

binu_acs · Answer

@Sshasnk One way of doing this

Regex_1101.yxmd

IraWatt · Answer

@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