Add 'ENDEND' on end of each record at position is 14-20


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add 'ENDEND' on end of each record at position is 14-20
# 1  
Old 08-20-2008
Add 'ENDEND' on end of each record at position is 14-20

I have file format like below and I'm trying to modify this file.
I need to add 'ENDEND' end of each record.

01 ASH01 1CTCTL EDPPOO STAND
01 ASH08 0020 A1TH 101
01 ASH09 0022 A1TH 102
01 ASH09 0022 A1TH 103
01 ASH02 2CTCTL EDPPOO STAND
01 ASH08 0030 A1TH 201
01 ASH09 0042 A1TH 302
01 ASH09 0052 A1TH 403
01 ASH03 1CTCTL EDPPOO STAND
01 ASH08 0020 A1TH 401
01 ASH09 0022 A1TH 502
01 ASH09 0022 A1TH 603


Result file should look like :

01 ASH01 1CTCTL EDPPOO STAND
01 ASH08 0020 A1TH 101
01 ASH09 0022 A1TH 102
01 ASH09 0022 A1TH 103
ENDEND
01 ASH02 2CTCTL EDPPOO STAND
01 ASH08 0030 A1TH 201
01 ASH09 0042 A1TH 302
01 ASH09 0052 A1TH 403
ENDEND
01 ASH03 1CTCTL EDPPOO STAND
01 ASH08 0020 A1TH 401
01 ASH09 0022 A1TH 502
01 ASH09 0022 A1TH 603
ENDEND
ENDEND
# 2  
Old 08-20-2008
Question Begin / End of each record

How do you know where one record ends and the other begins...is there something that can uniquely identify each record.
# 3  
Old 08-20-2008
Code:
awk '/STAND$/ && NR>1{print "ENDEND"}{print}END{printf("%s\n%s\n","END","END"}' file > newfile

Regards
# 4  
Old 08-20-2008
based on "1CTCTL" this means header record and rest are lines...
I would like to print end of each record (at position 14 - 20) "ENDEND".

1 Record means: Header row and line rows.
# 5  
Old 08-21-2008
Code:
cat file | sed '/EDPPOO/ i\
ENDEND
'

# 6  
Old 08-21-2008
Quote:
Originally Posted by summer_cherry
Code:
cat file | sed '/EDPPOO/ i\
ENDEND
'

but this will add ENDEND in first line also..
i mean
ENDEND
01 ASH01 1CTCTL EDPPOO STAND
01 ASH08 0020 A1TH 101
01 ASH09 0022 A1TH 102
01 ASH09 0022 A1TH 103
ENDEND
01 ASH02 2CTCTL EDPPOO STAND
01 ASH08 0030 A1TH 201
01 ASH09 0042 A1TH 302
01 ASH09 0052 A1TH 403
ENDEND
01 ASH03 1CTCTL EDPPOO STAND
01 ASH08 0020 A1TH 401
01 ASH09 0022 A1TH 502
01 ASH09 0022 A1TH 603
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shift record from one position to another

Hi All, I have a file and it is a fixed length file. I want to move the values from 42,6 ( where 6 is length) to the 36th position Original file: 00000100000100000100000100000100001 000870 ... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies

2. Shell Programming and Scripting

Retrieving sequences corresponding to start and end position

Hi all, I have a fasta file of a reference sequnce, I will like to retrieve sequences corresponding to a list of start and end position in another file >my_ref_seq GCCCTATAAGGGCAGAAGCTTGTCCTTCTTGTGCCAGTTATGACGTTTGTCCTAACTGCACATCTGGTAG... (4 Replies)
Discussion started by: Ibk
4 Replies

3. Shell Programming and Scripting

Require original field position after sorting the values in a record

Dear Team, Can any body help me out to get the filed position of the records post sorting using AWK programming. Thanks in advance Example Input: StudentID col-1 col-2 col-3 col-4 1234 14 10 12 13 1235 10 11 12 13 1236 13 12 11 10 ... (3 Replies)
Discussion started by: Srinivasa Reddy
3 Replies

4. Shell Programming and Scripting

How to add trailer record at the end of the flat file in the unix ksh shell scripting?

Hi, How to add trailer record at the end of the flat file in the unix ksh shell scripting can you please let me know the procedure Regards Srikanth (3 Replies)
Discussion started by: srikanth_sagi
3 Replies

5. Shell Programming and Scripting

Search and Replace by record position

Hi All, I have a file that I would like to search for data and replace other data by record position number: Example search.. search for "CLARK KENT" and replace Amt data "000025" with "000155"??? I'm able to search and replace unique data but, came to a stump when wanting to replace data... (11 Replies)
Discussion started by: macastor
11 Replies

6. Shell Programming and Scripting

how to add blank spaces at the end of every record in a file.

hi, Does anyone has any idea in adding few blank spaces at the end of every record in a file. Eg: file.txt Baby Boy Kim 1234 Baby Boy Vik 1334 Desired output:- output.txt Baby Boy Kim 1234 Baby Boy Vik 1334 I want to add 10 blank spaces at the end every record in file.txt (3 Replies)
Discussion started by: techmoris
3 Replies

7. Shell Programming and Scripting

Subsitute from a position till end of line.

Hi, Having a following file's content, lets say: ABC|ANA|LDJ|||||DKD|||||| AJJ|KKDD||KKDK|||||||||||| KKD||KD|||LLLD||||LLD||||| Problem: Need to replace pipes from 8th occurrence of pipe till end. so the result should be: ABC|ANA|LDJ|||||DKD AJJ|KKDD||KKDK|||| ------- ------- ... (12 Replies)
Discussion started by: _Noprofi
12 Replies

8. UNIX for Dummies Questions & Answers

find if a position is between a given start and end position

Hi, I am a newbie in unix programming so maybe this is a simple question. I would like to know how can I make a script that outputs only the values that are not between any given start and end positions Example file1: 2 30 40 80 82 100 file2: ID1 1 ID2 35 ID3 80 ID4 81 ID6... (9 Replies)
Discussion started by: fadista
9 Replies

9. Shell Programming and Scripting

MERGE 13 files and add the file name at the end of each record

Hi Gurus, I have 13 comma(,) seperated files that i have to merge and create a single file which has file name attached at th end of each record in the out put file. Can any one please help me with writing a unix script with this issue? test1.dat BIG ID,Local ID,Bond... (2 Replies)
Discussion started by: vkr
2 Replies

10. Shell Programming and Scripting

check position of end of line(URGENT PLS)

I Have to check in a file that all the lines are ending at same posiotin. Ex : line 1 is ending at position 88 line 2 should at same position i.e 88 Thanks in advance (6 Replies)
Discussion started by: evvander
6 Replies
Login or Register to Ask a Question