Can anyone suggest for convert text file to data table

Help
, ,
1

I am trying to convert text file to data table using generate data table but not getting proper format can I use a filter on the text file

2

Can you share the text with us, if it is not confidential?

3

can you come into email inbox please give me email address

4

Hi
when we are using GENERATE DATATABLE activity with a string variable passed as input
that input string must have a proper delimiter between each string like either it must have space as a delimiter, comma, or a tab
if there is any such missing then we wont be able to get the proper format we want
kindly check that once
Cheers @Arun_Pondhe1

1 Like
5

In my scenario there is tab in between but still not getting proper in generate data table

6

Great
have we mentioned that tab as a delimiter in the property panel of GENERATE DATATABLE activity and the property name is

Formatting Options

  • ColumnSeparators - Specifies the character that is to be used as a column separator. This field supports only String variables.

Cheers @Arun_Pondhe1