how to write a script to add

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to write a script to add
# 1  
Old 09-21-2011
how to write a script to add

HI Team,

I have requirement as below:

i have generated two csv files into separate files but that files should be in a single with separate tab in the sheet.

Please help me out ,how to do in the unix shell scripting.

Thanks in Adavance
# 2  
Old 09-21-2011
$ echo "A,B,C" | tr ',' "\t"
A       B       C

tr ',' "\t" filename.csv > new_tab_file.csv

# 3  
Old 09-21-2011
CSV file format doesn't support multiple sheets (you can see that by trying to save a workbook with multi-sheets to csv).

You are probably best having separate csv files for each sheet and loading them in separately.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Linux sftp — how to add new user to access exist directory with write permission?

I have built a website and I can access and edit the website'files on server via the root user. The current file and directory structures are not changeable. Now I am hiring a webpage designer to help me re-design some pages, I am going to let the designer edit the files directly on the server. So... (5 Replies)
Discussion started by: uwo-g-xw
5 Replies

2. UNIX for Beginners Questions & Answers

Add TimeStamp to cron job and write file name sent

Hello, I have written a cron job to automate the sftp of files using key authentication. I wanted to add a timeStamp and name of file sent to a log file and append each these details to the same file each time files are sent and if possible include whether the files were sent successfully or not.... (3 Replies)
Discussion started by: KidKoder
3 Replies

3. Shell Programming and Scripting

Need help to write script

I am having a File format as mentioned below Employee id|Name|Languages 12345|Hema|02|English|Hindi 4567|Basha|03|Engligh|Hindi|Telegu the 02 and 03 are counters. Using that we need to generate the output records as mentioned below 12345|Hema|English 12345|Hema|Hindi ... (8 Replies)
Discussion started by: bashamsc
8 Replies

4. Shell Programming and Scripting

Need to write a script...

Hello all, I am new to shell scripting. I want to write a shell script which will give me the output of the following query as an attachment in a mail SELECT /*+ parallel(a,4)*/ban, subscriber_no, business_id, price_plan_code, call_action_code, special_seq_no, toll_soc, toll_feature_code,... (1 Reply)
Discussion started by: paraspawar
1 Replies

5. Shell Programming and Scripting

Please help me to write the script

Hi All, I have written the follwing script to take the backup of the file every day along with the date. DATE=`date +%Y%m%d` export DATE cp var/hr/hr333m.txt cp var/hr/payments/hr333m_$DATE.txt The file name as follows after taking the backup. hr333m_20110630.txt Could you... (3 Replies)
Discussion started by: ajaykumarkona
3 Replies

6. Solaris

add a ftp user with read and write permissions on a directory

hi all how I can create an ftp user in solaris 10 and have read and write permission on a directory. Thanks. (1 Reply)
Discussion started by: luisfja
1 Replies

7. IP Networking

read/write,write/write lock with smbclient fails

Hi, We have smb client running on two of the linux boxes and smb server on another linux system. During a backup operation which uses smb, read of a file was allowed while write to the same file was going on.Also simultaneous writes to the same file were allowed.Following are the settings in the... (1 Reply)
Discussion started by: swatidas11
1 Replies

8. AIX

how to write this script?

If I need delete some disk, for i in hdisk1 hdisk2 hdisk3 hdisk4 do rmdev -dl $i done if I have more than 100 hdisks, how to write a script like that to delete them? (6 Replies)
Discussion started by: rainbow_bean
6 Replies

9. UNIX for Dummies Questions & Answers

Should I write a PERL Script or Shell Script?

Hello, I have done some BASIC shell scripting/PERL scripting before so I am familiar with the languages. I am not really sure which one would lend itself better to the application I have to write. I am required to scan the message logs for possible break in attempts. If I use shell scripting... (2 Replies)
Discussion started by: mojoman
2 Replies

10. Shell Programming and Scripting

Please write this script for me

UNIX shell script (Bourne shell syntax) called admin_script. This script is described below as a usage summary: admin_script Note: if no options are specified, a menu is displayed which allows users to perform one of the following tasks and then exit. If incorrect options are provided,... (1 Reply)
Discussion started by: nadman123
1 Replies
Login or Register to Ask a Question