Count the number of occurences of a string in a file in UNIX

Question

I have a .TXT file in UNIX with 1 million records in it which is a Pipe delimited, i would like to count the number of occurences of '|' in the 2nd record. Can someone please help me out.

Thanks in advance.

Please edit your question to add (a part of) your input and your expected output. — grooveplex
– grooveplex, Commented Feb 7, 2019 at 21:41

karakfa · Accepted Answer · 2019-02-07 22:50:22Z

1

$ awk -F'|' 'NR==2{print NF-1; exit}' file

split the record with the defined field separator, the count of separators is one less than the number of fields

or

$ awk 'NR==2{print gsub("\\|","|")}' file

replace all occurrences of | and print the count. Since | is a special regex character you need to escape it (and escape the escape char as well).

edited Feb 7, 2019 at 22:50

answered Feb 7, 2019 at 21:57

karakfa

67.8k8 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Count the number of occurences of a string in a file in UNIX

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related