How do I split sting and save in datatable column

For eg If I have string
Input
“Rajan Dan 25-08-2019 Pondy Chennai”

output

ColA ColB ColC ColD
Rajan Dan 25-08-2019 Pondy Chennai

Try to pass the above string into the Generate datatable with space as column seperator.

If you have a defined set of strings as value we can easily split .

Example :- Only 4 Columns of values will be your input .

We can split with space and loop it .(if we split with space we will get 5 values if name column contains two words).

so we need to handle it

Hi @Aravinthan ,

addRowDatatable.xaml (6.5 KB)

Please have a look.!

Thanks!

1 Like