Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help with parsing a unorganized file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with parsing a unorganized file
# 1  
Old 02-14-2013
Wrench Help with parsing a unorganized file
I have a file which is of this format

Code:
ABCD1
,1,22,green,2013-02-14,09:00:00,true
,1,22,red,2013-02-14,09:00:00,true
,1,22,blue,2013-02-14,09:00:00,true
ABCD2
,1,22,yellow,2013-02-14,09:00:00,true
,1,22,white,2013-02-14,09:00:00,true
,1,22,blue,2013-02-14,09:00:00,true
ABCD3
,1,22,black,2013-02-14,09:00:00,true
,1,22,pink,2013-02-14,09:00:00,true

I want to generate a file as below using unix commands

Code:
ABCD1,1,22,green,2013-02-14,09:00:00,true
ABCD1,1,22,red,2013-02-14,09:00:00,true
ABCD1,1,22,blue,2013-02-14,09:00:00,true
ABCD2,1,22,yellow,2013-02-14,09:00:00,true
ABCD2,1,22,white,2013-02-14,09:00:00,true
ABCD2,1,22,blue,2013-02-14,09:00:00,true
ABCD3,1,22,black,2013-02-14,09:00:00,true
ABCD3,1,22,pink,2013-02-14,09:00:00,true

Last edited by joeyg; 02-14-2013 at 02:23 PM.. Reason: Please wrap commands and data with CodeTags
# 2  
Old 02-14-2013
Code:
awk '!/^,/{h=$1}/^,/{print h $0}' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help parsing a file

Here is my file contents: I wish to generate <value-in-name-tag>.cfg which should contain entries like below Currently i am able to populate only what you see below. How can i also populate in the .cfg files ? Below is my code so far: grep -o '<name>.*</name>' deploy.tmp | sed... (1 Reply)
Discussion started by: mohtashims
1 Replies

2. Shell Programming and Scripting

parsing data from a big file using keys from another smaller file

Hi, I have 2 files format of file 1 is: a1 b2 a2 c2 d1 f3 format of file 2 is (tab delimited): a1 1.2 0.5 0.06 0.7 0.9 1 0.023 a3 0.91 0.007 0.12 0.34 0.45 1 0.7 a2 1.05 2.3 0.25 1 0.9 0.3 0.091 b1 1 5.4 0.3 9.2 0.3 0.2 0.1 b2 3 5 7 0.9 1 9 0 1 b3 0.001 1 2.3 4.6 8.9 10 0 1 0... (10 Replies)
Discussion started by: Lucky Ali
10 Replies

3. Shell Programming and Scripting

Parsing a file

Hi, I want to parse a file. The file looks like this: >ctg86 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX >ctg13 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX I want it to look like this: >ctg86... (2 Replies)
Discussion started by: phil_heath
2 Replies

4. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

Hey guys, I have this file generated by me... i want to create some HTML output from it. The problem is that i am really confused about how do I go about reading the file. The file is in the following format: TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies

5. Shell Programming and Scripting

Parsing file, yaml file? Extracting specific sections

Here is a data file, which I believe is in YAML. I am trying to retrieve just the 'addon_domains" section, which doesnt seem to be as easy as I had originally thought. Any help on this would be greatly appreciated!! I have been trying to do this in awk and mostly bash scripting instead of perl... (3 Replies)
Discussion started by: Rhije
3 Replies

6. UNIX for Dummies Questions & Answers

Script for parsing details in a log file to a seperate file

Hi Experts, Im a new bee for scripting, I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Discussion started by: pingnagan
2 Replies

7. Shell Programming and Scripting

Parsing File

I have input file like Count(*) TableName ----------- ------------------------------ 1 ccc_customers Count (*)TableName ----------- ------------------------------ 1 ccc_conduit_gci , I want to take only lines with 1 starting letter and removeing the 1 and spaces OUTPUT... (8 Replies)
Discussion started by: scorp_rahul23
8 Replies

8. Shell Programming and Scripting

Perl parsing compared to Ksh parsing

#! /usr/local/bin/perl -w $ip = "$ARGV"; $rw = "$ARGV"; $snmpg = "/usr/local/bin/snmpbulkget -v2c -Cn1 -Cn2 -Os -c $rw"; $snmpw = "/usr/local/bin/snmpwalk -Os -c $rw"; $syst=`$snmpg $ip system sysName sysObjectID`; sysDescr.0 = STRING: Cisco Internetwork Operating System Software... (1 Reply)
Discussion started by: popeye
1 Replies

9. 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

10. Shell Programming and Scripting

Finding & Moving Oldest File by Parsing/Sorting Date Info in File Names

I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves. Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies
Login or Register to Ask a Question