Sponsored Content
Full Discussion: Awk with fixed length files
Top Forums Shell Programming and Scripting Awk with fixed length files Post 302101965 by Perderabo on Saturday 6th of January 2007 08:40:48 AM
Old 01-06-2007
Quote:
Originally Posted by c2b2

But now since the file is fixed length, a lot of processing processing time will be wasted just on substring and then check wheten to perform the acton. Any solution?
"Don't use fixed length files" pops quickly to mind. "Switch to tools with support for fixed length files" is another thought. perl is probably the most widespread language with fixed field support.

If you must use awk on a fixed field file, maybe you could insert delimiters first:
Code:
$ cat input
111111111122222222223333333333
aaaaaaaaaabbbbbbbbbbcccccccccc
qqqqqqqqqqggggggggggtttttttttt
$ sed 's/\(.\{10\}\)\(.\{10\}\)\(.\{10\}\)/\1-\2-\3/' < input
1111111111-2222222222-3333333333
aaaaaaaaaa-bbbbbbbbbb-cccccccccc
qqqqqqqqqq-gggggggggg-tttttttttt
$

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort on fixed length files

Hi How to sort a fixed length file on a given char range and just display the duplicates. I did search for man sort to find any option but could find any.,something similar to cut -c 1-5,25-35. I have alternate way of doing this by using combination of cut,awk. but this creates extra temp... (6 Replies)
Discussion started by: sach_in
6 Replies

2. Shell Programming and Scripting

fixed length fields in awk

I am trying to display df -h command out in proper format, how can I display each field of each record in a fixed length. (2 Replies)
Discussion started by: roopla
2 Replies

3. Shell Programming and Scripting

Join two fixed length Files in Unix

Hi, Can we join two fixed length files in Unix using JOIN command? Is there any other command to accomplish the same? Thanks, G.Harikrishnan (6 Replies)
Discussion started by: gharikrishnan
6 Replies

4. Shell Programming and Scripting

Awk - Working with fixed length files

OK I am somewhat new to UNIX programming please see what you can do to help. I have a flat file that is a fixed length file containing different records based on the 1st character of each line. The 1st number at the beginning of the line is the record number, in this case it's record #1. I... (3 Replies)
Discussion started by: ambroze
3 Replies

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

6. Shell Programming and Scripting

awk to extract incorrect fixed length records

I have a number of unix text files containing fixed-length records (normal unix linefeed terminator) where I need to find odd records which are an incorrect length. The data is not validated and records can contain odd backslash characters and control characters which makes them awkward to process... (2 Replies)
Discussion started by: methyl
2 Replies

7. Shell Programming and Scripting

Need awk script to compare 2 fields in fixed length file.

Need a script that manipulates a fixed length file that will compare 2 fields in that file and if they are equal write that line to a new file. i.e. If fields 87-93 = fields 119-125, then write the entire line to a new file. Do this for every line in the file. After we get only the fields... (1 Reply)
Discussion started by: Muga801
1 Replies

8. Shell Programming and Scripting

Help with extracting words from fixed length files

I am very new to scripting and need to write a script that will extract the account number from a line that begins with HDR. For example, the file is as follows HDR2010072600300405505100726 00300405505 LBJ FREEWAY DALLAS TELEGRAPH ... (9 Replies)
Discussion started by: bds052189
9 Replies

9. Shell Programming and Scripting

awk to print fixed length columns to right side

Hi, I am in a situation to print the message on a column, where the each line starting position should be same. For example code: HOSTNAME1="1.2.3.4.5.6.7" TARGET_DIR="/tmp" echo "HOSTNAME1:" "$HOSTNAME1" | awk -v var="Everyone" '{len=55-length;printf("%s%*s\n",$0,len,var)}' echo... (4 Replies)
Discussion started by: tprabhaker
4 Replies

10. Shell Programming and Scripting

Splitting fixed length file using awk

Hi, I need to split a fixed length file of 160 characters based on value of a column. Example: ABC 456780001 DGDG SDFSF BCD 444440002 SSSS TTTTT ABC 777750003 HHHH UUUUU THH 888880001 FFFF LLLLLL HHH 999990002 GGGG OOOOO I need to split this file on basis of column from... (7 Replies)
Discussion started by: Neelkanth
7 Replies
WWW::Mechanize::FormFiller::Value::Fixed(3pm)		User Contributed Perl Documentation	     WWW::Mechanize::FormFiller::Value::Fixed(3pm)

NAME
WWW::Mechanize::FormFiller::Value::Fixed - Fill a fixed value into an HTML form field SYNOPSIS
use WWW::Mechanize::FormFiller; use WWW::Mechanize::FormFiller::Value::Fixed; my $f = WWW::Mechanize::FormFiller->new(); # Create a fixed value for the HTML field "login" my $fixed = WWW::Mechanize::FormFiller::Value::Fixed->new( login => "Corion" ); $f->add_value( login => $fixed ); # Alternatively take the following shorthand, which adds the # field to the list as well : my $password = $f->add_filler( password => Fixed => "secret" ); DESCRIPTION
This class provides a way to write a fixed value into a HTML field. new NAME, VALUE Creates a new value which will correspond to the HTML field "NAME". The "VALUE" is the value to be written into the HTML field. name [NEWNAME] Gets and sets the name of the HTML field this value corresponds to. value FIELD Returns the value to put into the HTML field. EXPORT None by default. COPYRIGHT AND LICENSE This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. Copyright (C) 2002,2003 Max Maischein AUTHOR
Max Maischein, <corion@cpan.org> Please contact me if you find bugs or otherwise improve the module. More tests are also very welcome ! SEE ALSO
WWW::Mechanize, WWW::Mechanize::Shell, WWW::Mechanize::FormFiller, WWW::Mechanize::FormFiller::Value::Value, WWW::Mechanize::FormFiller::Value::Default, WWW::Mechanize::FormFiller::Value::Random, WWW::Mechanize::FormFiller::Value::Interactive perl v5.10.1 2009-04-24 WWW::Mechanize::FormFiller::Value::Fixed(3pm)
All times are GMT -4. The time now is 11:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy