regex

[yilingchen02]

Hi there, I have a column that looks like this

COE_12345-abc-def.xlsx

ROA_abtee-ecb-dex.xlsx

ABC_rbcw-qbc-abvx.xlsx

How can I isolate the first word before _?

COE

ROA

ABC

Thanks,

Yiling

[caltang]

If you want to use REGEX, select PARSE and type in:

^(.{3})

Otherwise, you can opt for a Text-to-Columns tool for an easier time.

Hope this helps! If it does, kindly mark this reply as the accepted solution.

Thanks,

Cal

[caltang]

@yilingchen02 did my comment help solve your problem? If yes, could you kindly mark it as solved / accepted solution so that others may find it as well? Thank you!