xls to txt then to csv

[wildjack]

Hello,

I need to work on a .xls file, i download on a website.

Here are the columns on it : ID Number / Name / First Name / Adress

I need to get only the line with the bigger ID number. But it's not the first line.

I thought about :
- move the xls file to a csv file and then in list
- delete the first line of the txt file (headers)
- sort the list with list processing decrease
- create a new table with the list and read the cells of the first line

My trouble is that when i transform the files, datas in file became strange and i can't use them correctly.

http://puu.sh/8hiHA.png

I need your help, thanks

 

[rostonix]

Something is wrong with encoding. How do you transform files?

 

[wildjack]

I'm using process files "move", giving a new name to newname.csv or newname.txt

http://puu.sh/8hsxI.png

 

[rostonix]

Oh))))
That's the answer)

Try to take text via File processing - Read and put it to variable. Adter that you send this data in variable to List.

 

[wildjack]

Thanks, but i'm not sure to do it well

Which file do i have to read ? the xls or the csv ?

For both, when i take text, i have something like this in the variable : http://puu.sh/8hIYe.png