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?
Welcome to forums
Can you share a sample data, so that we can help
you can use regex to divide the string, also give us some example of your input and output you need
Thanks and Regards
i have this much date in H1 cell i want get all dates in separate rows.
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)
Did the solution worked for you?