topic file conversion in Operating System - HP-UX

file conversion

harikrishna — Mon, 05 Jan 2004 04:02:43 GMT

Is there any command in HP-ux servers to convert .csv file to .doc file.

Re: file conversion

Massimo Bianchi — Mon, 05 Jan 2004 04:31:04 GMT

Hi,
NO, i think there is no such utility, since a csv is a Comma Separated Value text file, whereas a .doc is a microsoft proprietary format for storing the documents.

If you tell us the purpose, maybe we can suggest other ideas, like generating html files or pdf files.

html could be an option ?

Massimo

Re: file conversion

Mark Grant — Mon, 05 Jan 2004 04:35:47 GMT

You might find a way by using star office but youll have to buy that as I don't belive there is a port of openofficefor HPUX. It could all get a bit horrible though and Massimo's suggestion of converting to html first seems to me to be the best idea.

Re: file conversion

harikrishna — Mon, 05 Jan 2004 05:02:41 GMT

hi,
thanks for giving the reply.actually my need is to send the .csv file using mailx command as an attahment.for this i am using
uuencode.
is there any command to foramt the .csv like adjust -m1,which removes all spaces and treat all as words.

Once again thanks for giving the reply.

Re: file conversion

Massimo Bianchi — Mon, 05 Jan 2004 06:02:04 GMT

mmhh... removing formatting from the file, or removing spaces , or collapsing the spaces ?

remove formatting:

cat yourfile | col -b | uuencode .....

remove/collapse spaces:

cat yourfile | tr -d " " | uuencode ....

HTH,
Massimo

Re: file conversion

harikrishna — Mon, 05 Jan 2004 06:47:22 GMT

THANKS FOR GIVING THE SOLUTION,one more question i want know
I WANT TO DO FTP TO ANTOTHER SYSTEM HOW CAN I PASS USER NAME AND PASSWORD TO THAT IN A SHELL SCRIPT

Re: file conversion

Massimo Bianchi — Mon, 05 Jan 2004 07:11:17 GMT

create an ftp script, like the following:

ftp -in HOSTNAME << EOF
user USERNAME PASSWORD

...
by
EOF

Massimo

Re: file conversion

Hoefnix — Mon, 05 Jan 2004 08:13:45 GMT

you can also use a .netrc file
see manpage of .netrc

Then you are able to use ftp "hostname" in your script and the .netrc will do the login and file transfer.

Regards,

Peter Geluk

Re: file conversion

harikrishna — Mon, 05 Jan 2004 08:43:48 GMT

Thanks for giving the reply