Character count per record


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Character count per record
# 1  
Old 04-12-2010
Character count per record

I have a flat file. How can i retrive the character count per record in whole file. Can anybody assist me on this

Cheers
# 2  
Old 04-12-2010
Quote:
Originally Posted by subrat
I have a flat file. How can i retrive the character count per record in whole file. Can anybody assist me on this

Cheers
What's a 'record'?
Posting a sample file and a desired output would help (using code tags).
# 3  
Old 04-12-2010
e.g

TestFile

100 NEWYORK SALES APPR
200 LA MARKETING TRRPSS
300 ROME RECEP TTLS

Desired output:-

1 - 19
2 - 20
3 - 16

(Space woud not be include)
# 4  
Old 04-12-2010
Try this:

Code:
awk '{gsub(" ","");print NR,"-",length($0)}' filename


cheers,
Devaraj Takhellambam
# 5  
Old 04-12-2010
MySQL

you can try this
Code:
while read line; do a=` echo $line | sed 's/ //g'`  ; echo "${#a}"; done <TestFile


Last edited by ygemici; 04-12-2010 at 02:50 PM..
# 6  
Old 04-12-2010
also,
Code:
while read line ; do echo $line | tr -cd '[:alnum:]' | wc -c; done < file

# 7  
Old 04-12-2010
And a Perl solution -

Code:
$
$ cat -n testfile
     1  100 NEWYORK SALES APPR
     2  200 LA MARKETING TRRPSS
     3  300 ROME RECEP TTLS
$
$ perl -lne 's/ //g; print "$. - ",scalar length $_' testfile
1 - 19
2 - 20
3 - 16
$

tyler_durden
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Need record count on every 30 minute

We have the below records where we need record count of every 30 minute like 00:01 to 00:30 so in that we will have 48 record count in 24 hrs , and also we need sum of record count from 00:01 to 23:30. Please find sample data as well. 00:01 21 00:02 23 00:03 34 00:04 34 00:05 30... (10 Replies)
Discussion started by: nadeemrafikhan
10 Replies

2. 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

3. 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

4. Shell Programming and Scripting

count of record in files

Hi all, I have written a scripts which count number of lines in all the files in a directory and write in a text file. I don't know how to format it while writing. OS suns solaris 10 my scripts is as below for i in /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/RIO_02-Aug-2012/ *.LOG do echo... (11 Replies)
Discussion started by: guddu_12
11 Replies

5. UNIX for Dummies Questions & Answers

Reduce the count on the 98 record by 2,

recod,amount,noofaccount,count 98,+00000187865779787,00319,000000640/ 99,+00000187865779787,00001,000000642/ thsi is my input file my question is 1) Reduce the count on the 98 record by 2 (6 Replies)
Discussion started by: sgoud
6 Replies

6. UNIX for Advanced & Expert Users

character count per record

Hello can someone please advise. I need to send records in a file that are over 10,000 characters long to a seperate file. Any ideas? Thanks (2 Replies)
Discussion started by: Dolph
2 Replies

7. Shell Programming and Scripting

replaying a record count with another record count

i use unix command to take the record count for a file1 awk 'END{print NR}' filename i already have a file2 which conatin the count like ... .. rec_cnt=100 .. .. I want to replace the record in the file2 using the record i take from file1. suggest me some simple ways of doing it... (2 Replies)
Discussion started by: er_zeeshan05
2 Replies

8. Shell Programming and Scripting

record count

i have a file named file_names.dat where there are several files along with their path. exp: /data1/dir1/CTA_ACD_20071208.dat /data1/dir1/CTA_DFG_20071208.dat i want to write a script which will create a csv file with the name of the file and record count of that file the output file... (4 Replies)
Discussion started by: dr46014
4 Replies

9. Shell Programming and Scripting

Need help with Isql record count

What I am trying to do is check if the database query returned any records. If no records returned then output a message else output results to a file. Right now if I take out the if and else statements the code runs fine and sends the email. If no records returned the email sends the column... (4 Replies)
Discussion started by: johnu122
4 Replies

10. UNIX for Dummies Questions & Answers

How to count the record count in an EBCDIC file.

How do I get the record count in an EBCDIC file on a Linux Box. :confused: (1 Reply)
Discussion started by: oracle8
1 Replies
Login or Register to Ask a Question