Question

Locked

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

By youngme58 ·
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.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Are you by chance sitting for an exam at this moment?

by robo_dev In reply to Exact unix script needed ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums