Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sequential to line sequential

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sequential to line sequential
# 1  
Old 01-31-2011
sequential to line sequential
Hi
I have a file sequential way i.e. written in contineous mode and the Record Seperator is AM from which the record is seperated .Now to process I have to make line sequential,and more over record length is not same it varies as per the input address,
Code:
AM1234563 John Murray 24 Old streeet old way Chicago AM451235 Lawrance Kaylep new roan ridge road kansas city AM87954 Ashly Woods kalgurah park lane  jersy city NJ AM96245 Linus Macanzeestreet river side lane Detroit AM753125 Thomas Alva Kopasli way  Las vagas

Output wanted in this format
Code:
AM1234563 John Murray 24 Old streeet old way Chicago 
AM451235 Lawrance Kaylep new roan ridge road kansas city 
AM87954 Ashly Woods kalgurah park lane  jersy city NJ
AM96245 Linus Macanzee street river side lane Detroit 
AM753125 Thomas Alva Kopasli way  Las vagas

Can anyone guide ??

Thanks in advance

Vakharia M J
Last edited by Scott; 02-01-2011 at 12:01 AM.. Reason: Code tags, please...
# 2  
Old 02-01-2011
Try:
Code:
sed 's/AM/\n&/g' file

or if you have GNU sed:
Code:
sed 's/AM/\n&/2g' file

This User Gave Thanks to Scrutinizer For This Post:
vakharia Mahesh
# 3  
Old 02-01-2011
try:
Code:
awk 'NR>1{print "AM"$0}' RS="AM" urfile

This User Gave Thanks to yinyuemi For This Post:
vakharia Mahesh
# 4  
Old 02-01-2011
Dear Scrutinizer and Yinyuemi,

Thanks a lot both of you for your code and fot this I was just Smilie since
two days, and you made it so simple But once again just a bit to share more

Had it been more than one filed seperator can I use this with little correction
like
Code:
awk 'NR>1{print "AM"$0}' RS=["AM","yAM"] urfile

I gave a try but did not give correct result,

Thanks once again for your code,

Vakharia M J
Last edited by Franklin52; 02-02-2011 at 03:41 AM.. Reason: Please use code tags
# 5  
Old 02-02-2011
Hi Vakharia, you're welcome. In regular awks, RS can only be one character. If more characters are used, the leftmost character gets used. GNU awk (gawk) allows RS to be a regular expression. Try:

Code:
awk '{gsub(/y?AM/,"\n&")}1' file

or
Code:
awk '{gsub(/y?AM/,"\nAM")}1' file

or
Code:
awk '{gsub(/yAM|AM/,"\nAM")}1' file

or
Code:
gawk 'NR>1{print "AM"$0}' RS="y?AM" file

if you want the y removed.

Alternatively, with sed..
Code:
sed 's/y\{0,1\}AM/\n&/g' file

or just:
Code:
sed 's/y\{0,1\}AM/\nAM/g' file

if you want the y removed..
Last edited by Scrutinizer; 02-02-2011 at 12:56 AM..
This User Gave Thanks to Scrutinizer For This Post:
vakharia Mahesh
# 6  
Old 02-04-2011
Bug
Scrutinizer ,
Oh so kind of you and I have just corrected the code to suit my requirement .

But good to suggest the code on which I could go further.

Have great week end. yinyuemi you too.

Vakharia M J
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk use sequential line numbering in output

The awk below produces an output with the original header and only the matching lines (which is good), but the output where the original line numbering in the match found on is used. I can not figure out how to sequentially number the output instead of using the original. I did try to add... (2 Replies)
Discussion started by: cmccabe
2 Replies

2. Shell Programming and Scripting

Inserting new line if two sequential lines begin with the same string

Hi I have a file like this: Peter North Mary Peter North Peter Borough Mary I need there to put 'X' (or anything) on a new line between the two lines where 'Peter' begins the line. There will be many matches to this string, but they will always begin with 'Peter'. Ie, the resulting... (2 Replies)
Discussion started by: majormajormajor
2 Replies

3. Shell Programming and Scripting

Sequential counting

Hi have a file of the following format a1 a1 a2 a2 a4 a4 a4 a3 a3 a5 a6 a6 a6 a6 .. 100's of lines (2 Replies)
Discussion started by: Lucky Ali
2 Replies

4. Shell Programming and Scripting

Add markup tag and sequential number after specific line

Hello, This one has me a bit stumped. I have data the looks like, M END > <PREDICTION_ACCURACY> PROBABLE > <NO_OF_PARENTS> 3 > <CLOGP> -13.373 > <SMILES> OCC(O)C(OC1OC(CO)C(OC2OC(CO)C > <MIMW> 1006.322419888 (3 Replies)
Discussion started by: LMHmedchem
3 Replies

5. Shell Programming and Scripting

Sequential numbers

Hi All, I am looking for a simple way to write numbers to a file sequentially starting from 1 and ending on a specified upper limit. Example of the output file is below Example 1 2 3 4 5 . . . . 1000 please let me know the best way to do it. (10 Replies)
Discussion started by: Lucky Ali
10 Replies

6. Programming

Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX

Writing a Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX I have over the years come across the same issue a couple of times, and it normally is that the read speed on SAN is absolutely atrocious when doing non-sequential I/O to the disks. Problem being of... (7 Replies)
Discussion started by: vrghost
7 Replies

7. Shell Programming and Scripting

Append specific lines to a previous line based on sequential search criteria

I'll try explain this as best I can. Let me know if it is not clear. I have large text files that contain data as such: 143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test line 2 test line 3 test 143593503 09-08-20 09:02:13... (3 Replies)
Discussion started by: jesse
3 Replies

8. Shell Programming and Scripting

sequential running for 2 scripts

Hello I have a script that has 2 scripts that must be executed one after the other. however, when I run the script, the 2 sub-scripts are run in parallel. any idea how to fix this without using sleep command? thank you (7 Replies)
Discussion started by: melanie_pfefer
7 Replies

9. Programming

Reading special characters while converting sequential file to line sequential

We have to convert a sequential file to a 80 char line sequential file (HP UX platform).The sequential file contains special characters. which after conversion of the file to line sequential are getting coverted into "new line" or "tab" and file is getting distorted. Is there any way to read these... (2 Replies)
Discussion started by: Rajeshsu
2 Replies

10. Shell Programming and Scripting

running script sequential

I have 4 scripts I need to run sequentially(can't run simultaneously) What's the syntax for it? I am running Korn Shell. Thanks, (2 Replies)
Discussion started by: ocjunky
2 Replies
Login or Register to Ask a Question