Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Character count per record

Login to Discuss or Reply to this Discussion in Our Community

 
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