Unix shll script for character count findings?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Unix shll script for character count findings?
# 1  
Old 07-07-2007
Unix shll script for character count findings?

Hi,
iam presenting the input text file format.Of this i need the character count of the number of characters present in each file.The attached file is a combination of 3 text file.each text file starts at record 1 - 34, then the next tetx file starts. What i need is the character count of each text file in the main text file.the 3 text file is in a main text file called 71018158.txt.

The first 2 lines of each text file is not required for character count.
I tried the following cmd to remove those 2 line

grep -v "^01" *.txt | wc -m
grep -v "^02" *.txt | wc -m
and i also don't need the " ^ " present in the text file for the determination of the character count.
Hope u understand the point.

Regards
Sethunath







01^V1.0^EXPORTED^2470717800001001001^71018158^00000001^C0^4686019C^AJ82^A457^^n:\indata\20070628\710 18158^71018158.001^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^01^50^01
02^^^71018158^01^01^^^2470717^800001^001^N^^^
03^07611983-01^SAME^^^SAME^^^^^^^^
04^^^^^4616 ^^DE95316^^^95316^^^1^1^Y^Y
05^2^^^^^^^^
06^29633^^^^^^^^^^1
07^061807^061807^11^^90801^^^^^1^ 31000^1^^^^^^00C323001
08^^^^^^^^^^^^^^^^^^
09^^^^^^^^^^^^^^^^^^
10^^^^^^^^^^^^^^^^^^
11^^^^^^^^^^^^^^^^^^
12^^^^^^^^^^^^^^^^^
13^^^^^^^^^^^^^^^^^
14^^^^^^^^^^^^^^^^^
15^^^^^^^^^^^^^^^^^
16^^^^^^^^^^^^^^^^^
17^^^^^^^^^^^^^^^^^
18^^^^^^^^^^^^^^^^^
19^^^^^^^^^^^^^^^^^
20^^^^^^^^^^^^^^^^^
21^^^^^^^^^^^^^^^^^
22^^^^^^^^^^^^^^^^^
23^^^^^^^^^^^^^^^^^
24^^^^^^^^^^^^^^^^^
25^^^^^^^^^^^^^^^^^
26^^^^^^^^^^^^^^^^^
27^^^^^^^^^^^^^^^^^
28^^^^^^^^^^^^^^^^^
29^^^^^^^^^^^^^^^^^
30^^^^^^^^^^^^^^^^^
31^^ 31000
32^Y^^STEWART^^^MD^-0388035^SWART MD^3340 ROAD, D-2^^MO95350^^CA^95350^^^^^^^MD^220 F^^MO95350^MODESTO^CA^95350^^^2095795628^
01232001^
33^^^^^^^^^^071700164-00
34^^^1609987510^1912090622^^1912090622^^2^
01^V1.0^EXPORTED^2470717800002001001^71018158^00000002^C0^4686019C^AJ82^A457^^n:\indata\20070628\710 18158^71018158.002^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^02^50^01
02^^^71018158^01^01^^^2470717^800002^001^N^^^
03^7398347-01^SAME^^^SAME^^^^^^^^
04^^MATTHEW^^^3901 RD^^CE95307^^CA^95307^^11011979^1^1^Y^Y
05^2^^^^^^^^
06^30002^^^^^^^^^^1
07^061807^061807^11^^90807^^^^^1^ 20600^1^^^^^^00C323001
08^^^^^^^^^^^^^^^^^^
09^^^^^^^^^^^^^^^^^^
10^^^^^^^^^^^^^^^^^^
11^^^^^^^^^^^^^^^^^^
12^^^^^^^^^^^^^^^^^
13^^^^^^^^^^^^^^^^^
14^^^^^^^^^^^^^^^^^
15^^^^^^^^^^^^^^^^^
16^^^^^^^^^^^^^^^^^
17^^^^^^^^^^^^^^^^^
18^^^^^^^^^^^^^^^^^
19^^^^^^^^^^^^^^^^^
20^^^^^^^^^^^^^^^^^
21^^^^^^^^^^^^^^^^^
22^^^^^^^^^^^^^^^^^
23^^^^^^^^^^^^^^^^^
24^^^^^^^^^^^^^^^^^
25^^^^^^^^^^^^^^^^^
26^^^^^^^^^^^^^^^^^
27^^^^^^^^^^^^^^^^^
28^^^^^^^^^^^^^^^^^
29^^^^^^^^^^^^^^^^^
30^^^^^^^^^^^^^^^^^
31^^ 20600
32^Y^^STEWART^^^MD^^QUISLING, MD^3340 ROAD, D-2^^MO95350^^CA^95350^^^QUISLING^^^^MD^220 SAVE., #F^^MO95350^^CA^95350^^^209579
5628^05152006^
33^^^^^^^^^^061300348
34^^^1609987510^1912090622^^1912090622^^2^
01^V1.0^EXPORTED^2470717800003001001^71018158^00000003^C0^4686019C^AJ72^A457^NEWHCFA^n:\indata\20070 628\71018158^71018158.003
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^03^50^01
02^^^71018158^01^01^^^2470717^800003^001^N^^^
03^WBW902A68176^SAME^^^SAME^^^^^^^^
04^^JOSEPH^^^907 HELMS ^^MO95350^^CA^95350^^10221946^1^1^^Y
05^2^^^^^^^^
06^29633^^^^^^^^^^1
07^061807^061807^11^^90807^^^^^1^ 20600^1^^^^^^00C323001
08^^^^^^^^^^^^^^^^^^
09^^^^^^^^^^^^^^^^^^
10^^^^^^^^^^^^^^^^^^
11^^^^^^^^^^^^^^^^^^
12^^^^^^^^^^^^^^^^^
13^^^^^^^^^^^^^^^^^
14^^^^^^^^^^^^^^^^^
15^^^^^^^^^^^^^^^^^
16^^^^^^^^^^^^^^^^^
17^^^^^^^^^^^^^^^^^
18^^^^^^^^^^^^^^^^^
19^^^^^^^^^^^^^^^^^
20^^^^^^^^^^^^^^^^^
21^^^^^^^^^^^^^^^^^
22^^^^^^^^^^^^^^^^^
23^^^^^^^^^^^^^^^^^
24^^^^^^^^^^^^^^^^^
25^^^^^^^^^^^^^^^^^
26^^^^^^^^^^^^^^^^^
27^^^^^^^^^^^^^^^^^
28^^^^^^^^^^^^^^^^^
29^^^^^^^^^^^^^^^^^
30^^^^^^^^^^^^^^^^^
31^^ 20600
32^Y^QUISLING^^^^MD^0388035^STEWART^3340 ROAD, D-2^^MO95350^^CA^95350^^^QUISLING^STEWART^^^MD^220 STANDAVE., #F^^^MODESTO^CA^
95350^^^2095795628^05072007^
33^^^^^^^^^^071240677
34^^^1609987510^1912090622^^1912090622^^2^
# 2  
Old 07-07-2007
Code:
awk 'BEGIN{l=0}
	 NR>2 { 
		  gsub(/\^/,""); 
		  l=l+length(substr($0,3) )	 
	 }
END{print "count: " l}' "file"

# 3  
Old 07-07-2007
Hi.

Here is a non-awk script:
Code:
#!/bin/sh

# @(#) s1       Demonstrate sed manipulation of file for counting.

set -o nounset
echo " sh version: $BASH_VERSION" >&2

FILE=${1-data1}

echo
echo " Characteristics of original file:"
cat $FILE |
wc

echo
echo " File as processed:"
sed  -e '1,2d' -e 's/\^//g' $FILE |
tee t1 |
wc

echo
echo " Edges of file as modified:"
edges -l 2 t1

rm t1

exit 0

running on the first of the files produces:
Code:
% ./s1
 sh version: 2.05b.0(1)-release

 Characteristics of original file:
     36      44    1051

 File as processed:
     34      41     361

 Edges of file as modified:
     1  027101815801012470717800001001N
     2  0307611983-01SAMESAME
   ...
    33  33071700164-00
    34  341609987510191209062219120906

The edges command is local, it prints lines near the beginning and end of a file; it is not necessary to the solution, just a verification of the content of a sample from the modified file.

Keep in mind that the newline character is counted in wc as a character ... cheers, drl
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count specific character of a file in each line and delete this character in a specific position

I will appreciate if you help me here in this script in Solaris Enviroment. Scenario: i have 2 files : 1) /tmp/TRANSACTIONS_DAILY_20180730.txt: 201807300000000004 201807300000000005 201807300000000006 201807300000000007 201807300000000008 2)... (10 Replies)
Discussion started by: teokon90
10 Replies

2. UNIX for Beginners Questions & Answers

How do I remove leading spaces in UNIX when count of space character is not fixed? Example below-

Script showStreamsGLIS$reg.$env.ksh gives me output as below- Job Stime Etime Status ExitCode GLIS-AS-S-EFL-LOCK-B ----- ----- OI 103313880/0 GLIS-ALL-Q-EOD-FX-UPDT-1730-B ----- ----- TE 0/0 GLIS-TK-S-BWSOD-B ... (8 Replies)
Discussion started by: Tanu
8 Replies

3. Shell Programming and Scripting

Finding a certain character in a filename and count the characters up to the certain character

Hello, I do have folders containing having funny strings in their names and one space. First, I do remove the funny strings and replace the space by an underscore. find . -name '* *' | while read file; do target=`echo "$file" | sed 's/... (2 Replies)
Discussion started by: tempestas
2 Replies

4. Shell Programming and Scripting

Character Count in script

#!/bin/ksh read name read mobile echo $name | wc -m Nunberchar=`echo $name |wc -m` echo $Nunberchar I write something above, however the char count is wrong, it always count the $ , how to avoid it ? (5 Replies)
Discussion started by: sakurai2601
5 Replies

5. Shell Programming and Scripting

Character count in UNIX!

Hi, I am Beginner in writing shell scripting. I have tried to get the character count using wc command. But it is not giving the correct result. Could any one please tell me the reason? $ cat k.ksh Shell scripting The character count should be 15 but it is displaying as 16 when i use... (8 Replies)
Discussion started by: nikesh29
8 Replies

6. Shell Programming and Scripting

awk - count character count of fields

Hello All, I got a requirement when I was working with a file. Say the file has unloads of data from a table in the form 1|121|asda|434|thesi|2012|05|24| 1|343|unit|09|best|2012|11|5| I was put into a scenario where I need the field count in all the lines in that file. It was simply... (6 Replies)
Discussion started by: PikK45
6 Replies

7. UNIX for Dummies Questions & Answers

Script to count character present in a line

Suppose i have multiple line like below in a file. ASDFAFAGAHAHAHA AGAHAHAJGAFAGAH AHAHAKAHAHAHAKA I need a bash script to count a character and also Also count the number of character present in each line . suppose for line 1: A=x, S=y, D=x and so on and total character=15. where x y and z is... (3 Replies)
Discussion started by: XXLMMN
3 Replies

8. Shell Programming and Scripting

Count number of occurences of a character in a field defined by the character in another field

Hello, I have a text file with n lines in the following format (9 column fields): Example: contig00012 149606 G C 49 68 60 18 c$cccccacccccccccc^c I need to count the number of lower-case and upper-case occurences in column 9, respectively, of the... (3 Replies)
Discussion started by: s052866
3 Replies

9. Shell Programming and Scripting

Help On Unix Script Count Line Of File

I have to compare the number of files of two files on a Shell Script: I tryied with wc and wiith sed but I can not make an integer... #!/bin/sh . . n = ls -l | wc -l $file1 `echo "Line: "$n". ">>$LOGFILE` xx = sed -n '$=' $file2 `echo "Line: "$xx". ">>$LOGFILE` Aways... (4 Replies)
Discussion started by: fafo77
4 Replies

10. UNIX for Advanced & Expert Users

How to count no of occurences of a character in a string in UNIX

i have a string like echo "a|b|c" . i want to count the | symbols in this string . how to do this .plz tell the command (11 Replies)
Discussion started by: kamesh83
11 Replies
Login or Register to Ask a Question