Question Locked

Exact unix script needed to Read a file and than convert it to .csv format

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i have a .xls(or any other format) file place in source folder(remote ip say 1.2.3.4/logfiles/srcfiles/). The file has 100 rows. The records are as :

empno ename city deptno
1 abc sydney 001
2 bcd alaska 002
3 def delhi 003

now i want a script which can read this file from that location & than convert it into the .csv file. Plz i need urgent help in this regard.

2 replies

by robo_dev

If the file is an XLS format, it is a binary file, and there is no script that can extract data directly from it. Other file formats, such as PDF suffer the same fate.

If the file is a text file, then it would be possible to do some substitution of the space character with the comma character.

This discussion is closed to new replies.