jenkim
(Jane)
1
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
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.
Yoichi
(Yoichi)
2
Hi,
Hope the following helps you.
Main.xaml (6.0 KB)
Regards,
1 Like
jenkim
(Jane)
3
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.
Yoichi
(Yoichi)
4
Hi,
Can you try to write row("Text").ToString
instead of row("Text")
?
Regards,
jenkim
(Jane)
5
Okay @Yoichi !
I got my solution. Thank you for your kind help.
1 Like
system
(system)
Closed
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.