Flat file manipulation, (this could be a tough one)

mrbungle50 · #1 (**permalink**) 01-09-2008

Howdy everyone, I have need of a scripting brain to help me through the following issue:
*This will help if I explain what I am doing this for and then it may make sense.
I need to change a flat file to prepend a 3 digit code to a certain field in the file going on the value in another scetion of the same line.
Confused? I thought so!

Anyhow here goes.
In the attached flat file there is a field 4 digits at position 155 which is an Australian post-code (zip code). I need my script to read this value and if it begins with a certain number (eg: 9XXX for Western Australia) take a pre-defined TZ 3 digit code (eg: starts with a 9 > code will equal 900) and take this TZ 3 digit code and insert it at the point 216, then at 237 and finally at 258 on the same line. These are three phone numbers (home, work, mobile)
I have tried a few awk attempts but not geting the syntax correct and feel I need something bigger and stronger than this?
Please have a read of the attached text file and you'll see it is just a list of name addresses and phone numbers. NB: I have changed some of the umbers to be X and Y for confidentiality.
This is for a dialler application and sadly it uses are codes for working out what time zone the record is in. In Australia area codes span different time zones, but post codes do not. So the use of postal codes is the most logical choice but in order to get the dialler application to dial using it's time zones functionality I must give it area codes to work with.
Does this make sense?
Please email or contact me at any time if you need clarification on anything.
Thanks again
Craig
MrBungle50
PS: I am in Australia

radoulov · #2 (**permalink**) 01-10-2008

With GNU Awk:

Code:

awk '$2~/^9/{$4=$6=$8=9000}1' OFS= FIELDWIDTHS="154 4 58 4 17 4 17 4 109" data

rikxik · #3 (**permalink**) 01-10-2008

@mrbungle

Code:

#!/usr/bin/sh

nawk '{if(/^HDRDIALLER/ || /^TRLDOWNLOAD/) {
                print
        } else {
                ins="00"substr($0,155,1)
                print substr($0,1,216)(ins)substr($0,218,20)(ins)substr($0,239,20)(ins)substr($0,259)
        }
}' $1 > $2

Usage:

Code:

cl.sh collect.txt tz_added.txt

HTH

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Flat File in HP-UX	Krishnaramjis	Shell Programming and Scripting	0	06-02-2008 11:24 PM
Flat file	Krishnaramjis	Shell Programming and Scripting	9	05-08-2008 10:28 PM
Help with a Flat File!!!	kumarsaravana_s	Shell Programming and Scripting	11	06-07-2007 11:15 PM
Help with a flat file!!!	kumarsaravana_s	Shell Programming and Scripting	3	04-16-2007 07:58 AM
XML to flat file	balireddy_77	Shell Programming and Scripting	2	04-13-2007 05:57 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by