How to read tab delimited CSV file

Help
1

Hello guys,

Currently, I’m working with a CSV file which I have to convert it to a data table. but the CSV file I’m using is tab delimited file.

I used the “Read CSV file” object and select the Tab delimiter. and also I tried by using “\t” as well noting worked

Kindly requesting your help on this.

Herewith I have attached the csv file downloadable
link inventory.csv - Google Drive

1 Like
2

Hi @charith_wickramasing,
Can you upload the csv file? Thanks :slight_smile:

3 Likes
3

Here with I have attached the link to download the CSV file

4

@charith_wickramasing

I downloaded the file and checked but I did not find ‘Tab’ as delimiter in your CSV file. All the data is mixed without space also.

1 Like
5

Hi @charith_wickramasing

I also checked your file. However only the header has a space separator. But the data does not have any character to split the data…

2 Likes
6

Hi @charith_wickramasing,
This is what I can extract from your CSV file: output.xls (37.4 KB)

3 Likes
7

@charith_wickramasing

Buddy we have an option called Generate data table activity that can generate datatable from a structured csv file…

  1. read the csv file with read text file with its output assigned to a variable out_txt
  2. use generate data table activity to convert that to datatable with input out_txt and output assigned to a variable out_dt
    Kindly enable use column header

Hope this would help you

Cheers/.

1 Like
8

but in the excel i can split this in to columns by using text to columns , tab delimiter function. Thats’s why i thought it can split using tab

9

Hi @charith_wickramasing

check below attached xaml file.
Sequence.xaml (12.3 KB)

10

Bro, but i can split into columns by using excel text to column function ( tab delimited), That’s why i thought i can split this by using a tab.

11

Thanks a lot, @kommijeevan, but it didn’t work. :frowning:

12

hi @Jan_Brian_Despi

would you be able to share the xaml file ?

1 Like
13

Here it is:
BlankProcess34.zip (22.0 KB)

Thanks and regards :slight_smile:

2 Likes
14

try thisProcessTabDelimited.zip (44.1 KB)

1 Like
15

hi @kommijeevan

Thanks, lot for the help. but it didn’t work. it gives me this output.

Book1.xlsx (47.7 KB)

1 Like
16

Thanks a lot @Jan_Brian_Despi

It worked. but I want an output like this.

Book1.xlsx (34.2 KB)

Would you be able to help me with this?

Thanks again.

1 Like
17

Oh. You just need those details that are clear?

1 Like
18

Yeah jan, by using that data i have to extract some information from a web portal. that why all the data should be clear…

1 Like
19

Hi @charith_wickramasing,
Here you go: BlankProcess34.zip (22.9 KB)

The output is Book1.xlsx

You may want to visit this link:
https://www.uipath.com/kb-articles/how-to-read-data-from-a-csv-file

Please let me know if it works :slight_smile:

6 Likes
20

Hi @Jan_Brian_Despi.

It worked perfectly. :ok_hand: :smiley: Thanks a lot Jan,

2 Likes