Splitting/Manipulating Strings Writing to Excel

Help
1

Read ‘Newusecase.txt’ from desktop
Split each line in such a way that all alphabets should come in first column and numbers in second column. Paste these two columns in an Excel sheet. for eg. ABC123, So when you execute the result has to be segregated as ABC in Excel column A and 123 in column B

2

@anand_desai Can you show how your Text File looks like?

3

Untitled
Untitled1174×440 25 KB

4

You can use regex and put Alphabets in Group 1 and digits in Group 2 and then add it into Data table.

Try this regex
([A-Za-z]+)([0-9]+)

Thanks
@anand_desai

5

Regexbuilder.xaml (9.7 KB) sample.txt (22 Bytes)

Output:
image

1 Like
6

@anand_desai,
@supermanPunch,
@Priyanka_Ramesh

THIS IS IS REALLY EASY!!

I have created a workflow for you…

Please find the solution to your problem…

@anand_Desai_Solution.xaml (13.0 KB)

Mark this as a solution if you are satisfied by my approach.

Thanks and Regards,
hacky

1 Like