Split a string excel

Hi all,

I’m trying to split a string from one column and want to turn it into multiple column after the split.

Original data
image

e.g.
data - emailoutlook_20201222_12343.xlsx

I managed to split the first column using regex - emailoutlook_20201222
The last column - .xlsx

My only problem is to split the digits in between - 12343

If I use regex (\d{5}), it will also capture the front digits.

Thank you in advance.

Hi,

Hope the following helps you.

img20210409-2

Main.xaml (6.0 KB)

Regards,

1 Like

Hi @Yoichi,

Thank you for your solution but it seems like it’s not working if I put it inside my for each row since the data are inside the excel.

image

Hi,

Can you try to write row("Text").ToString instead of row("Text")?

Regards,

Okay @Yoichi !

I got my solution. Thank you for your kind help.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.