04-14-2007
text file to excel or csv
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
2. UNIX for Advanced & Expert Users
Hello All,
I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH.
Thanks,
Sateesh (7 Replies)
Discussion started by: kotasateesh
7 Replies
3. Shell Programming and Scripting
i want sort columns with headers based on another file headers
file1
eg: i'm having an empty file with only coumn names like
lastname firstname title expirydate stlcno status etc...
another file with same column names and some other as well but in different order...
file2
eg:firstname... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
5. Shell Programming and Scripting
Hi,
I am trying to attach and email a csv file in the form of an excel sheet.
And I have been successful in doing this.
But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet.
... (5 Replies)
Discussion started by: girish1428
5 Replies
6. Shell Programming and Scripting
Hi,
The result of a script is a csv file in the following format: cat $file_name
DATA_USAGE_FACT,YES_NO_FLG,TARGET_TABLE,YES_NO_FLG,1,0,15,0
DATA_USAGE_FACT,DATE_OF_CREATION,TARGET_TABLE,DATE_OF_CREATION,29,9,19,0
DATA_USAGE_FACT,UPDATION_DATE,TARGET_TABLE,UPDATION_DATE,29,9,19,0... (3 Replies)
Discussion started by: dips_ag
3 Replies
7. Shell Programming and Scripting
In my file, i have 4 Product names(For ex:Microsoft excel, Oracle,.Net,IBM websphere,..etc.,) I want this 4 Products in 4 individual .csv/excel file after running the script with those products related information. (12 Replies)
Discussion started by: Navya
12 Replies
8. Shell Programming and Scripting
Hi all,
I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion.
so for instance
input.xls
description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies
9. Shell Programming and Scripting
Hello friends
I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns
1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
6 Replies
10. UNIX for Beginners Questions & Answers
I have to sort the 4th column of an excel/csv file. I tried the following command
sort -u --field-separator=, --numeric-sort -k 2 -n dinesh.csv > test.csv
But, it's not working. Moreover, I have to do the same for more than 30 excel/csv file. So please help me to do the same. (6 Replies)
Discussion started by: dineshkumarsrk
6 Replies
LEARN ABOUT DEBIAN
backup-manager-upload
BACKUP-MANAGER-UPLOAD(8) backup-manager-upload BACKUP-MANAGER-UPLOAD(8)
NAME
backup-manager-upload - Multiprotocol uploader for backup-manager.
SYNOPSIS
backup-manager-upload [options] date
DESCRIPTION
backup-manager-upload will upload all the archives generated on the given date to the specified host with either ftp or scp. It's also
possible to use this program for uploading data to an Amazon S3 account. Some metadates are available like "today" or "yesterday".
REQUIRED ARGS
--mode=transfer-mode
Select the transfer mode to use : ftp, scp, or s3.
--host=hostname1,hostname2,...,hostnameN
Select a list of remote hosts to connect to.
--user=username
Select the user to use for connection.
OPTIONAL ARGS
--password=password
Select the ftp user's password (only needed for ftp transfers).
--key=path_to_private_key
Select the ssh private key file to use when opening the ssh session for scp transfer. Obviously, this is only needed for scp transfer
mode. If you don't specify a key file, the user's default private key will be used.
--directory=directory
Select the location on the remote host where files will be uploaded. Default is /backup/uploads.
--bucket=bucket
Sets the bucket name for the Amazon S3 service backup into.
--root=directory
Select the local directory where files are. Default is /var/archives
--gpg-recipient=gpg-recipient
Select the gpg public key for encryptiong the archives when uploading with the method ssh-gpg. This can be a short or long key id or a
descriptive name. The precise syntax is described in the gpg man page.
--list
Just list the files to upload.
--ftp-purge
Purge the remote directory before uploading files in FTP mode.
--s3-purge
Purge the remote directory before uploading files in FTP mode.
--ssh-purge
Purge the remote directory before uploading files in SSH mode.
--verbose
Flag to enable verbose mode.
date
Date pattern to select some files to upload, can be a valid date (YYYYMMDD) or 'today' or 'yesterday'.
ERROR CODES
If something goes wrong during an upload, backup-manager-upload will exit with a non null value. In such a case every error messages are
sent to STDERR.
Here are the possible error codes:
bad command line (wrong arguments) : 10
FTP transfer failure : 20
SCP transfer failure : 21
S3 transfer failure : 22
Unknown upload method: 23
SEE ALSO
backup-manager(3)
AUTHORS
Alexis Sukrieh - main code and design
Brad Dixon - Amazon S3 upload method
Jan Metzger - ssh-gpg upload method
perl v5.14.2 2012-05-09 BACKUP-MANAGER-UPLOAD(8)