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 |
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
@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
You can also use the regex tool
if this helped to solve your problem, please be sure to mark it as a solution.