How to insert data befor some field in a row of data depending up on values in row

aemunathan · #1 (**permalink**) 03-17-2009

Hi

I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.

The original data record should be some thing like this

Code:

60119827  RTMS_LOCATION_CDR    INSTANT_POSITION_QUERY    1236574686123083rtmssrv7      20090309102806279           441           442
           783           WEB       1568          GMLC919443259137    FAILURE6         1236574665595654lessrv1

but due to some system errors the file generated has got one missing information and it looks like

Code:

60119827  RTMS_LOCATION_CDR    INSTANT_POSITION_QUERY    1236574686123083rtmssrv7      20090309102806279                         442
           783           WEB       1568          GMLC919443259137    FAILURE6         1236574665595654lessrv1

both has got 248 charaters length. but in the second record one data is missing i.e 441

i need to insert 441 exactly in that position if 442 is available as next data.
its some thing like case statements...

i will be having different values instead of 442 and their corresponding previous position data

How to go about this...any one help me out...
Am having lot of error files like this to be treated, hence can i do anything like upload in a DB and insert data based on the values in the row at the position i told before (442)

Help me out!!!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Not able to insert data through crontab	megh	SUN Solaris	2	12-29-2008 08:36 AM
Not able to insert data	megh	SUN Solaris	1	12-05-2008 12:20 AM
unable Insert data from .dat file to .xls can anybody help me	kreddy2003	Shell Programming and Scripting	1	05-28-2008 06:33 AM
help me to to insert data	babu@shell	UNIX for Dummies Questions & Answers	10	10-24-2006 03:25 AM
sed, insert data from a file to another?	ctcuser	Shell Programming and Scripting	4	05-03-2005 02:43 PM

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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by