Converting string to data table by comma as a column seperator

Help Studio
,
1

IMG_20230223_161558
IMG_20230223_1615581920×295 48.3 KB

IMG_20230223_161646
IMG_20230223_161646615×4000 209 KB

Hi,
I am trying to convert the above shown string to data table using comma as a column seperator. But it is not working as expected.
2nd image is after generating DT, if you see the second column we still see commas as it is not splitting to columns as expected. Why this is happening and what can i do to overcome this? Please someone can help me.

2

have a look at the generate datatable activity

3

Hi @Harsha_Vemula ,

Could you let us know what activity was used to convert String to Datatable ?

If it was Generate Datatable Activity, Could you also show us the configuration done in the Activity ?

4

IMG_20230223_164341
IMG_20230223_1643411920×1960 374 KB

Here is the image which shows the properties set for Generate Data Table activity.

5

@Harsha_Vemula ,

Could you try by keeping the CSVParsing Property as True and check if it works ?

1 Like
6

PERFECT!! Thank you so much, it is working fine now after setting the CSV Parsing as True.
I was surprised how i missed that validation. Thanks Arpan :blush::+1:

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.