Sponsored Content
Full Discussion: Need to generate .csv file
Top Forums Shell Programming and Scripting Need to generate .csv file Post 302383356 by vaas on Tuesday 29th of December 2009 10:44:14 AM
Old 12-29-2009
Need to generate .csv file

I have a csv file with the following data

Please find the attachment - zip

Code:
 
 
 
 
12/31/20081/7/20091/14/20091/21/20091/28/20092/4/20092/11/20092/18/20092/25/20093/4/20093/11/20093/18/20093/25/20094/1/20094/8/20094/15/20094/22/20094/29/20095/2/20095/13/20095/20/20095/27/20096/3/20096/10/20096/17/20096/24/20097/1/20097/8/20097/15/20097/22/20097/29/20098/5/20098/12/20098/19/20098/26/20099/2/20099/9/20099/16/20099/23/30099/30/200910/7/200910/14/200910/21/200910/28/200911/4/200911/11/200911/18/200911/25/200923967432967150000000000000000000000000000000000000000000011111111119999999444466661111111113131313141414141111111112121212121212126666555599993333


Can you pls help me to generate .csv file like this

We need to pass three parameters, < source_file> <Desn_file> <Destn_dir>

Can you pls help me with this

Code:
 
 
 
 
239674329671512/31/2008023967432967151/7/2009023967432967151/14/2009023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671511/18/20090239674329671511/25/2009011111199999912/31/200841111119999991/7/200941111119999991/14/2009411111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911/18/2009311111199999911/25/20093

Thanks a lot

Last edited by vaas; 12-29-2009 at 11:50 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generate csv file

I have a file which has some thousand records in the following format File: input.txt -> <option value="14333">VISWANADH VELAMURI</option> <option value="17020">VISWANADHA RAMA KRISHNA</option> I want to generate a csv file from the above file as follows File: output.txt -> ... (4 Replies)
Discussion started by: rahulrathod
4 Replies

2. UNIX for Dummies Questions & Answers

generate CSV file using AWK script

Hi guys I have a text report that consists of text in some parts and data in some parts. e.g Report for changes in cashflows No changes were found Report for changes in Bills deal_num deal_date trader maturity log_creator DF_234 20-5-2008 tman 20-5-2009 tman... (2 Replies)
Discussion started by: magikminox
2 Replies

3. Shell Programming and Scripting

need help in Parsing a CSV file and generate a new output file

Hi Scripting Gurus, I am trying to parse a csv file and generate a new output file. The input file will be a variable length in turns of rows and columns. output file will have 8 columns. we have three columns from the header for each set. just to give little bit more clarification each row... (15 Replies)
Discussion started by: vkr
15 Replies

4. Shell Programming and Scripting

to read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (1 Reply)
Discussion started by: Ram.Math
1 Replies

5. Shell Programming and Scripting

Read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (25 Replies)
Discussion started by: Ram.Math
25 Replies

6. Shell Programming and Scripting

Script to generate csv file

Hello; I need to generate a csv file that contains a list of all the files in a particular server (from the root directory ie: \) that have a permission stamp of 777. I would like to create the csv so that it contains the following: server name, file name, full path name where file exists,... (17 Replies)
Discussion started by: gvolpini
17 Replies

7. Shell Programming and Scripting

How to generate a csv files by separating the values from the input file based on position?

Hi All, I need help for doing the following. I have a input file like: aaaaaaaaaabbbbbbbbbbbbbbbbbbbb cccbbbbbaaaaaadddddaaaabbbbbbb now I am trying to generate a output csv file where i will have for e.g. 0-3 chars of each line as the first column in the csv, 4-10 chars of the line as... (3 Replies)
Discussion started by: babom
3 Replies

8. Shell Programming and Scripting

Script to generate csv file

Dears, I am new in shell world and I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the... (3 Replies)
Discussion started by: abdul2020
3 Replies

9. Shell Programming and Scripting

Script to generate .csv file

Dears,I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the file as an input the file will be... (8 Replies)
Discussion started by: abdul2020
8 Replies

10. Shell Programming and Scripting

Generate .csv/ xls file report

There can be thousand of .ksh in a specific directory where sql files are called from ksh. Requirement is to loop through all the files content and generate a report like below: Jobname Type type sqlname gemd1970 sql daily tran01 gemw1971 sql weekly ... (6 Replies)
Discussion started by: vedanta
6 Replies
All times are GMT -4. The time now is 06:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy