How to separate single cell value into multiple cell?

I used getfull text activity to get text and generated data table. Now I have multiple dates stored in single cell and I want to separate it into different cell. How should i do?

@vidya.sanjay.patil

Welcome to forums

Can you share a sample data, so that we can help

Thanks

Hi @vidya.sanjay.patil

you can use regex to divide the string, also give us some example of your input and output you need

Thanks and Regards

1 Like

image
i have this much date in H1 cell i want get all dates in separate rows.

Hi @vidya.sanjay.patil

Please find the attached sequence and change accordingly. Try the below code and let me know if you need any changes

SplittingCellIntoDifferentRows.xaml (8.7 KB)

Thanks

Hi @vidya.sanjay.patil

Did the solution worked for you?

Thanks