Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need help to make a csv file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help to make a csv file
# 1  
Old 06-23-2011
Need help to make a csv file
Hi All Smilie

Need help to create a csv file from some data which is extracted from input file

Input file:
Code:
 1.  RUN DATE: 06/02/11  2. SYSTEM: EP0Z       3. PROBLEM TYPE: 0016
               --------             ----                        ----
 4.  JOB NUMBER: 4301    5. JOB NAME: EP0Z080P 6. STEPNAME: EPZSTP06
                 ----                 --------              --------

 7.  TIME NOTIFIED: 23:55      8. WHO NOTIFIED: CHINMAY SAHOO
                    -------                     --------------------
                       9. HELPERS:  ABEND.DATA
                                   ---------------------------------


 10. WHAT WAS WRONG?:

     CC 16 IN EPZSTP06 PROGRAM EPZ00080


     ERROR ON SECTION : 24701-DEP-PROD-VR-CHECK
     ERR MSG : SELECT MSHP CH MCURS        SQL CD : -180
     SUBS ID : 072426609


 11. HOW WAS THIS PROBLEM HANDLED?:
      COPIED THE PROD FILE 'EP00P.EPZ00080.INPUT.TRIGG(0)'
      TO TEST FILE 'EP00T.EPZ00080.INPUT.TRIGG.G2310BKP'.
      BELOW PROCESS WAS FOLLOWED
    A. WE SEARCHED FOR THE SUBSCRIBER WHICH HAS SHOWN IN SYSOUA
       DURING FIRST ABEND SUBS ID : 72426609
    B. WE THEN FIND OUT THE SUBS ID WHICH WAS BEFORE THIS SUBSID AND
       HAVE RECTYPE AS 'SP'.ALL RECORDS FOR THIS SUBSCRIBER ID WITH REC
       TYPE SP WERE  REMOVED.


I want to cut RUN DATE, WHAT WAS WRONG details and SQL CD which is SQL code and create a csv file from these 3 data.

please help
# 2  
Old 06-23-2011
Can you post the output format required..?
# 3  
Old 06-23-2011
Can anybody tell me. even i am facing the same issue..
# 4  
Old 06-23-2011
what issue ?

post the sample input file and sample output format
# 5  
Old 06-23-2011
Output file is look like

Code:
06/02/11,  CC 16 IN EPZSTP06 PROGRAM EPZ00080 ERROR ON SECTION : 24701-DEP-PROD-VR-CHECK LECT MSHP CH MCURS SQL CD : -180 SUBS ID : 072426609 , -18

this type of file I need
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash - make csv file

Hello, im trying to make csv file from a text file that it is the output of pssh command (multiple ssh ) now if i run the command date on all of our servers: i get this output : 14:02:46 192.168.25.230:22 Thu Jul 6 14:02:46 EEST 2017 192.168.70.230: Thu Jul 6 12:02:46 BST 2017 ... (1 Reply)
Discussion started by: batchenr
1 Replies

2. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies

3. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

4. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

5. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

6. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

7. Shell Programming and Scripting

Comparing 2 CSV files and sending the difference to a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 ... (1 Reply)
Discussion started by: Naresh101
1 Replies

8. UNIX for Dummies Questions & Answers

How to make a CSV file from a Raw data

Hi Please help me on this.i have the Following data i want to make it CSV file by a Unix Shell Script. •msgType : 234 ( m_code : 0 # m_name : type # m_data : LOG ) pls help me on this (4 Replies)
Discussion started by: Aditya.Gurgaon
4 Replies

9. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies
Login or Register to Ask a Question