I have a tab delimited text file that I need to consume into UIPath and place it’s contents into a datatable. How do I go about doing that?
So far, I have tried reading in the text using the .NET File.ReadAllFiles function but I can’t seem to get past the first For Each I place in there because each line within the String Array has tabs as delimiters as well.
I can’t use the Generate Data Table from Text activity because it places everything into the first column of the datatable.
Looking for ideas here. What is the best plan of attack?
there are two “Name” in your text may be thats why its unable to do for USER NAME give like “USER_NAME” and you keeping space for every word , you should keep some unique things in column name like underscore or differentiate the column by tap , but there all or space
I agree with the underscore but the data I am receiving is not from me.
The data is not space delimited, it is tab-delimited. When I go into Notepad++, I see the tabs when I look at the data by the tab symbol. See the screen capture below.
then you can go with seperate tap but in sample text panel its not supporting tap , its supporting only space , may be just do setup for seperate by tap , and run it , then see its working or not . dont see only preview panel
ashokkarale
Anil_G
jast1631
Sarttra
FL.Duck
nashrif
Shakib