Visit Our UNIX and Linux User Community


Check length of record


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Check length of record
# 1  
Old 08-06-2009
Check length of record

Hi,
I have a problem, please help me,
I have a flat file like this:

P00000000088888888999999999 0000999903 000000000000000000
P00000000077777777000000000 0000999903 000000000000000000
P00000000044444444333333333 0000999903 00000000000000000079875
P00000000066666666111111111 0000999903 000000000000000000
P00000000055555555222222222 0000999903 000000000000000000

Every record has 58 characters
I need to know which records doesn´t have 58 characters (in red)
How can i do that????
Thans for your help

Ministerio Levantando a Cristo - Viña del Mar - Chile
# 2  
Old 08-06-2009
Hi.

Using awk:

Code:
awk 'length != 58' file

# 3  
Old 08-06-2009
Code:
awk ' length($0)!=58 {print FNR, $0}' inputfile

# 4  
Old 08-06-2009
Quote:
Originally Posted by scottn
Hi.

Using awk:

Code:
awk 'length($0) != 58 { print}' file

OK, thanks
In this case "file" is the name of my input file?
Where do i print the records what doesn´t have 58 characters??
Thanks
# 5  
Old 08-06-2009
Hi.

Code:
awk 'length != 58' file

Yes, "file" is the input filename.

This will print all records which don't have 58 characters (to answer your question specifically, it will print to standard output).
# 6  
Old 08-06-2009
Quote:
Originally Posted by scottn
Hi.

Code:
awk 'length != 58' file

Yes, "file" is the input filename.

This will print all records which don't have 58 characters (to answer your question specifically, it will print to standard output).
OK, really thanks.

---------- Post updated at 03:19 PM ---------- Previous update was at 03:19 PM ----------

Quote:
Originally Posted by jim mcnamara
Code:
awk ' length($0)!=58 {print FNR, $0}' inputfile

thanks a lot jim mcnamara

Previous Thread | Next Thread
Test Your Knowledge in Computers #1001
Difficulty: Medium
Grace Brewster Murray Hopper was an American computer scientist and United States Navy rear admiral who found a moth in a computer stuck in a relay in 1947 and was later referred to as "Grandma COBOL" for her pioneering work in machine-independent programming languages.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert variable length record to fixed length

Hi Team, I have an issue to split the file which is having special chracter(German Char) using awk command. I have a different length records in a file. I am separating the files based on the length using awk command. The command is working fine if the record is not having any... (7 Replies)
Discussion started by: Anthuvan
7 Replies

2. Shell Programming and Scripting

Verifying Record Length

Hi all, We are going through a total migration from AIX-based server framework to Linux-based servers. When I am testing *.sh and *.awk in a lower environments, it abends at the same step everytime in verifying the record length of the first row of the source file. I know this source file... (11 Replies)
Discussion started by: SoloXX
11 Replies

3. Shell Programming and Scripting

Record length check fails due to '\' character

When I check the length for the records in the file, it does not give me the correct value. I used wc -l command. Example records: abcdefghij abcd\efghij abcdefghi Expected output is: 10 11 9 But the output returned is 10 10 9 Please help me on this issue. (10 Replies)
Discussion started by: Amrutha24
10 Replies

4. Shell Programming and Scripting

Check for length which exceeds specified length in a line

Hi, I have a issue, I need to loop through a comma delimited file and check for the length which exceeds specified length , if Yes truncate the string. But my problem is , I do not have to check for all the fields and the field lenght is not same for all the fields. For ex: Say my line... (9 Replies)
Discussion started by: rashmisb
9 Replies

5. Shell Programming and Scripting

Record length

Hi, The record length may be differ in afile. I want to display the records if the record length is not equal to 50 using sed/awk command. Thanks in Advance (6 Replies)
Discussion started by: NareshN
6 Replies

6. Shell Programming and Scripting

Viewing a record of particular length

I have records with different lengths say 386, 387 and 388. Do i have any command to view all the records of the length 386 ? Please do advise. Thanks (2 Replies)
Discussion started by: bobby1015
2 Replies

7. Shell Programming and Scripting

Make variable length record a fixed length

Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types: (H)eader Records (D)etail Records (T)railer Records The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies

8. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

9. Shell Programming and Scripting

fixed record length

hello! I have a file with fixed record length... format: 123445asdfg 4343777 sfgg I wanna convert it to 123445,asdfg ,4343,777 ,sfgg is there any way to do it? sed/grep/awk?? at the moment I use sed -e 's_ \(\)_,\1_g' but it works only if there are spaces between... (16 Replies)
Discussion started by: george_
16 Replies

Featured Tech Videos