Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Multi Record Layout

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Multi Record Layout
# 1  
Old 06-25-2009
Multi Record Layout
I have a fixed width source file like this( it has 5 different record types identified by bolded numbers)

N5101ABCD 9820398 2983287
N5102 9s9923 00000000 00
N5103
N5101TTT 9843438 9494994
N5104 sdsd
N5101YYY 7777777 1111111

I need to have like this:
N5101ABCD 9820398 2983287|N5102 9s9923 00000000 00 |N5103||
N5101TTT 9843438 9494994|||N5104 sdsd|
N5101YYY 7777777 1111111||||

Thanks for ur help in advance!
saravanamr
# 2  
Old 06-25-2009
Are there spaces in the columns where there is no value?
But then
Quote:
N5102 9s9923 00000000 00 |N5103||
First part has space but second is not...

No. of pipes "|" are also not same....

And you have not shared what you have tried...
# 3  
Old 06-25-2009
no... there mite not be spaces...
No of pipes is 4 for all records...since there are 5 record types which belong to a single record...so i havto group all of 'em...
I tried,

<Code> awk 'END{print RS}$0=_[$1]++||NR==1?$0"|":RS$0"|"' ORS= sample.dat</Code>

But it need a unique value for each group...like
01 N5101ABCD 9820398 2983287
01 N5102 9s9923 00000000 00
01 N5103
02 N5101TTT 9843438 9494994
02 N5104 sdsd
03 N5101YYY 7777777 1111111

Moreover, it displays the output like,
01 N5101ABCD 9820398 2983287|01 N5102 9s9923 00000000 00 |01 N5103|
02 N5101TTT 9843438 9494994|02 N5104 sdsd|
03 N5101YYY 7777777 1111111|

I have to get rid of the last pipe(bolded)....before that I have to add a unique value for all groups...and after grouping I havto get rid rid of that unique value also...
saravanamr
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with reformat single-line multi-fasta into multi-line multi-fasta

Input File: >Seq1 ASDADAFASFASFADGSDGFSDFSDFSDFSDFSDFSDFSDFSDFSDFSDFSD >Seq2 SDASDAQEQWEQeqAdfaasd >Seq3 ASDSALGHIUDFJANCAGPATHLACJHPAUTYNJKG ...... Desired Output File >Seq1 ASDADAFASF ASFADGSDGF SDFSDFSDFS DFSDFSDFSD FSDFSDFSDF SD >Seq2 (4 Replies)
Discussion started by: patrick87
4 Replies

2. Shell Programming and Scripting

Need code for updating second record to first record in shell scripting

Hi,, I have requirement that i need to get DISTINCT values from a table and if there are two records i need to update it to one record and then need to submit INSERT statements by using the updated value as a parameter. Here is the example follows.. SELECT DISTINCT ID FROM OFFER_GROUP WHERE... (1 Reply)
Discussion started by: Samah
1 Replies

3. Programming

Multi head/multi window hello world

I am trying to write a large X app. I have successfully modified my xorg.conf to setup 4 monitors on an NVIDIA Quatro5200. I am trying to modify a simple hello world application to open a window on three of the four monitors. depending on the changes to loop the window creation section and event... (2 Replies)
Discussion started by: advorak
2 Replies

4. Shell Programming and Scripting

Extract timestamp from first record in xml file and it checks if not it will replace first record

I have test.xml <emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp> <Join><id>101</id><city>london</city><date>06/06/14 2011</date></join> <Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join> <Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies

5. Shell Programming and Scripting

How to compare current record,with next and previous record in awk without using array?

Hi! all can any one tell me how to compare current record of column with next and previous record in awk without using array my case is like this input.txt 0 32 1 26 2 27 3 34 4 26 5 25 6 24 9 23 0 32 1 28 2 15 3 26 4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies

6. Shell Programming and Scripting

How to substract selective values in multi row, multi column file (using awk or sed?)

Hi, I have a problem where I need to make this input: nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b look like this output: nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a -... (4 Replies)
Discussion started by: nricardo
4 Replies

7. Shell Programming and Scripting

Reject the record if the record in the next line does not satisfy the pattern

Hi, I have a input file with the following entries: 1one 2two 3three 1four 2five 3six 1seven 1eight 1nine 2ten The output should be 1one 2two 3three 1four 2five 3six (2 Replies)
Discussion started by: supchand
2 Replies

8. Shell Programming and Scripting

Multi record

I have fixed width source file data look like this, J510111112222 J5102ABCD J510133334444 J5102EFGH I want to make this like 11112222J510111112222 11112222J5102ABCD 33334444J510133334444 33334444J5102EFGH Bolded is the record type. Thanks for help. (8 Replies)
Discussion started by: saravanamr
8 Replies

9. UNIX for Dummies Questions & Answers

Multi User Multi Task

Dear Experts Why we always hear that unix operating system is Multi User and Multi task. What does these two means. I have looked at some books and documents but couldn't find aclear explenation. Can we say Windows operating system is also multi user and multi task?? Thanks for your help in... (6 Replies)
Discussion started by: Reza Nazarian
6 Replies

10. UNIX for Dummies Questions & Answers

multi-file multi-edit

Good day! I am trying to learn how to use the "sed" editor, to perform multiple edits on multiple files in multiple directories. I have one script that tries to call up each file and process it according to the edits listed in a second script. I am using a small input text to test these, at... (12 Replies)
Discussion started by: kielitaide
12 Replies
Login or Register to Ask a Question