Record length


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Record length
# 1  
Old 10-18-2012
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
# 2  
Old 10-18-2012
I hope you mean a line by "record".
Code:
awk 'length!=50' file

or
Code:
sed -n '/^.\{50\}$/!p' file

I hope the file contains only ASCII characters.

Last edited by elixir_sinari; 10-18-2012 at 09:57 AM..
# 3  
Old 10-18-2012
the file contails wide characters and sed command failed "
Code:
Function ... cannot be parsed"

and
Code:
awk

command displays all the records
# 4  
Old 10-18-2012
What's the encoding?
# 5  
Old 10-18-2012
You should also state the operating system version you're using.

Is 50 the actual value that you're using or is it something larger?

And, please, don't edit error messages. Paste them verbatim whenever possible (I'm assuming that "..." in "Function ... cannot be parsed" is a placeholder).

Regards,
Alister
# 6  
Old 10-18-2012
am using OS : AIX
exact length is 400

Code:
sed: 0602-404 Function /^.\{400\}$/!p cannot be parsed.

The record has pipe line characters "|"

If the length 20 or 50 is working file. I think length 400 is the problem

Last edited by NareshN; 10-18-2012 at 10:42 AM..
# 7  
Old 10-18-2012
Thanks for providing the additional information.

While it may not be relevant to this problem, in the future please be specific when you state your OS. There is more than one version of AIX out there.

Pipe characters should not be a problem.

I believe your sed implementation only supports the closed interval 0 to 255.

Perhaps you can work around it thusly:
Code:
sed 'h; s/.\{200\}//; /^.\{200\}$/d; g'

Note that it is logically required for the first count to be less than or equal to the second. Otherwise, erroneous results will ensue.

I'm curious regarding why your awk attempt did not work.

Regards,
Alister
Login or Register to Ask a Question

Previous Thread | Next Thread

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

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

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

5. Shell Programming and Scripting

awk to find the length of each record.

Hi Guys, I wanted to print the length of each record and the record itself. I tried the following awk ... awk 'a=length(); {print $a,$0}' file1 But it is giving me the records instead of length. and also, it giving me each record twice. Means the value of a is not the length of the... (0 Replies)
Discussion started by: mac4rfree
0 Replies

6. Shell Programming and Scripting

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 ... (5 Replies)
Discussion started by: DebianJ
5 Replies

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

8. Shell Programming and Scripting

fl command - set record length

Hi, I have a KSH shell script running on hpux that uses the fl command - ex: cat /foo | fl 50 > bar This command will take each record in the file foo, make it 50 characters long and then write it to the file bar. my problem is that I am porting my scripts over to solaris which doesn't... (2 Replies)
Discussion started by: Tom Siegel
2 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
Login or Register to Ask a Question