Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Count the number of strings in a block

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Count the number of strings in a block
# 1  
Old 01-11-2011
Count the number of strings in a block
Hi,
I have the following text in a file:
Code:
ISA*00*          *00*          *ZZ*ENS_EDI        *ZZ*GATE0215       *110106*2244*U*00401*006224402*1*P*>~
GS*HP*ENS_EDI*GATE0215*20110106*2244*6224402*X*004010X091A1~
ST*835*00006~
BPR*I*4092.96*C*ACH*CCP*01*124384877*DA*720000034*1362739571*000036273*01*031000053*DA*8606078386*20110110~
TRN*1*1042474735*1362739571*000036273~
DTM*405*20110105~
N1*PR*UNITED HEALTH CARE*XV*36273~
N3*PO BOX 740819~
N4*ATLANTA*GA*303740819~
REF*2U*36273~
PER*CX*CUSTOMER SERVICE*TE*8002277789~
PER*BL*CUSTOMER SERVICE*EM*customer@del.com~
N1*PE*ST FRANCIS MEDICAL CENTER*XX*1255419651~
N3*601 HAMILTON AVENUE~
N4*TRENTON*NJ*086291986~
REF*TJ*223431049~
LX*1~
TS3*1255419651*11*20111231*1*396~

I want to count the number of 'PER' segments in between N1*PR and N1*PE.
In this case, it should return me 2.

Thanks for all your help.

Regards,
Don
# 2  
Old 01-11-2011
Code:
awk '/N1\*PR/,/N1\*PE/' inputFile | grep -c "PER"

This User Gave Thanks to anurag.singh For This Post:
donisback
# 3  
Old 01-11-2011
Thanks, this works perfect.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count the occurences of strings

I have some text files in a folder f1 with 10 columns. The first five columns of a file are shown below. aab abb 263-455 263 455 aab abb 263-455 263 455 aab abb 263-455 263 455 bbb abb 26-455 26 455 bbb abb 26-455 26 455 bbb aka 264-266 264 266 bga bga 230-232 230 ... (10 Replies)
Discussion started by: gomez
10 Replies

2. Shell Programming and Scripting

Count the number of strings

I have 500 text files in a folder. The data of the text files are shown below. USA Germany 23-12 USA Germany 23-12 USA Germany 23-12 France Germany 15-12 France Germany 15-12 France Italy 25-50 China China 30-32 China China 30-32 I would... (1 Reply)
Discussion started by: sahith
1 Replies

3. UNIX for Dummies Questions & Answers

How to search and count strings?

Hi, Is there a command to do a sensitive/in-sensitive search for a string on a line and print how many times that string appears? For example, if I have a line of text below: dog cat rat apple banana dog lion tiger dog Is there a command to search for dog that will print out 3 as a... (7 Replies)
Discussion started by: newbie_01
7 Replies

4. Shell Programming and Scripting

How to count the number of strings?

Hi, I have a text file as shown below. I would like to count the unique number of connections of each person in the first and second column. Third column is the ID numbers of first column persons and fourth column is the ID numbers of second column persons. susan ali 156 294... (7 Replies)
Discussion started by: mohamad
7 Replies

5. Shell Programming and Scripting

How do I count strings on each line?

Hi Im a very inexperienced bioinformatician I have a large DNA file with about 10000 lines of sequence and need to count the occurrence of TA for each line for example in the file TACGCGCGATA TATATATA GGCGCGTATA I would like to get an output like: 2 4 2 I have tried... (3 Replies)
Discussion started by: Manchesterpaul
3 Replies

6. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ... (6 Replies)
Discussion started by: juelillo
6 Replies

7. Shell Programming and Scripting

count identical strings print last row and count

I have a sorted file like: Apple 3 Apple 5 Apple 8 Banana 2 Banana 3 Grape 31 Orange 7 Orange 13 I'd like to search $1 and if $1 is not the same as $1 in the previous row print that row and print the number of times $1 was found. so the output would look like: Apple 8 3 Banana... (2 Replies)
Discussion started by: dcfargo
2 Replies

8. Shell Programming and Scripting

count the number of lines that start with the number

I have a file with contents similar to this. abcd 1234 4567 7666 jdjdjd 89289 9382 92 jksdj 9823 298 I want to write a shell script which count the number of lines that start with the number (disregard the lines starting with alphabets) (1 Reply)
Discussion started by: grajp002
1 Replies

9. Shell Programming and Scripting

How to count unique strings

How do I count the total number of unique strings from a file using Perl? Any help is appreciated.. (6 Replies)
Discussion started by: my_Perl
6 Replies

10. Shell Programming and Scripting

Count strings on single line?

I use grep -c often, but cannot for the life of me count the number of occurences of a string on the same line (or within a file): $ cat myfile hello457903485897hello 34329048hellojsdfkljlaskdjgh182390 $ grep -c 2 $ How do I count the number of occurences of "hello" in myfile (i.e. 3)?... (6 Replies)
Discussion started by: cs03dmj
6 Replies
Login or Register to Ask a Question