Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to insert data befor some field in a row of data depending up on values in row
Top Forums Shell Programming and Scripting How to insert data befor some field in a row of data depending up on values in row Post 302298433 by aemunathan on Tuesday 17th of March 2009 01:14:54 PM
Old 03-17-2009
How to insert data befor some field in a row of data depending up on values in row
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!!!
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

first row data into variables

I have a datafile having structure like col1,col2,col3 col1,col2,col3,col4,col5 col1,col2,col3,col4,col5 ..... Can we take only first row of values from datafile and put into respective variable. How col1 can be captured in a variable called v_col1 from unix script. like first row(only)... (1 Reply)
Discussion started by: u263066
1 Replies

2. Shell Programming and Scripting

Add value of each row when each row has different data ype

Guys -- I am noob and I am really strugging on this one. I cant even write the pseudo code for it. I have a file that spits values in individual rows as such: file: user date type size joe 2005-25-09 log 1 joe 2005-25-09 snd 10 joe 2005-25-09 rcd 12 joe 2005-24-09 log 2 joe... (1 Reply)
Discussion started by: made2last
1 Replies

3. Shell Programming and Scripting

Convert row data to column data

Hi Guys, I have a file as follows: a 1 b 786 c 90709 d 99 a 9875 b 989 c 887 d 111 I want: a 1 9875 b 786 989 (3 Replies)
Discussion started by: npatwardhan
3 Replies

4. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies

5. Shell Programming and Scripting

Insert row without deleting previous data using sed

Hello, I want to add a new row to a file to insert data without deleting the previous data there. Example: file a b c d Output a b newtext c (6 Replies)
Discussion started by: joseamck
6 Replies

6. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies

7. Emergency UNIX and Linux Support

[Solved] Mysql - Take data from row and copy it to another row

Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :( Dear community, I have a table with two rows like: Row1 Row2 ======= ======= 7,3 text 1 1,3 text 2 1,2,3 blabla What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies

8. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies

9. Shell Programming and Scripting

Analyzing last 2 fields of 1 row and 3rd field of next row

I have the following script that will average the last two fields of each row, but im not sure how to include the 3rd field of the following row. An example of the analysis that I need to perform from the input - (66.61+58.01+54.16)/3 awk '{sum=cnt=0; for (i=13;i<=NF;i++) { sum+=$i; cnt++... (1 Reply)
Discussion started by: ncwxpanther
1 Replies

LEARN ABOUT DEBIAN

codechanges

codechanges(1)						      General Commands Manual						    codechanges(1)

NAME

       codechanges - computes the amount of code changes between two code trees or single files

SYNOPSIS

       codechanges [-n] old-directory new-directory

       codechanges [-n] old-file new-file

DESCRIPTION

       codechanges  recursively  compares  the	two  named directories (or files) calculating new/deleted/changed lines, not including comments or
       blank lines, in files which appear to be source files (C, C++, shell, and Makefiles).  To include comments and  blank  lines,  use  the	-n
       option.

APPLICATIONS

       codechanges  is purpose designed to measure the amount of code change between milestones in a project's life.  The following output is from
       two stages, plus some artificial test cases, in the pmccabe code stream:

       NEW  DELETED   CHANGED	Old File, New File
       11   19	 4    old.pmccabe/./Makefile pmccabe/./Makefile
       214  10	 39   old.pmccabe/./cparse.c pmccabe/./cparse.c
       463  0	 0    NEWFILE pmccabe/./decomment.c
       147  4	 39   old.pmccabe/./dmain.c pmccabe/./dmain.c
       10   0	 0    NEWFILE pmccabe/./dmain.h
       407  0	 0    NEWFILE pmccabe/./getopt.c
       48   0	 0    NEWFILE pmccabe/./getopt.h
       9    18	 12   old.pmccabe/./gettoken.c pmccabe/./gettoken.c
       18   18	 15   old.pmccabe/./io.c pmccabe/./io.c
       175  43	 20   old.pmccabe/./nmain.c pmccabe/./nmain.c
       194  11	 22   old.pmccabe/./pmccabe.c pmccabe/./pmccabe.c
       42   0	 20   old.pmccabe/./pmccabe.h pmccabe/./pmccabe.h
       0    1318 0    old.pmccabe/./test/langMode.c DELETED
       24   0	 0    NEWFILE pmccabe/./test006/Grapher.H
       620  0	 0    NEWFILE pmccabe/./test006/Handler.H
       442  0	 0    NEWFILE pmccabe/./test006/NodeArc.H
       764  0	 0    NEWFILE pmccabe/./w/parser.C
       95   0	 0    NEWFILE pmccabe/./w/tokens.h
       4    0	 0    NEWFILE pmccabe/./x.sh
       3687 1441 171  TOTAL

DIAGNOSTICS

       There aren't many at this time.

BUGS

       codechanges thinks it knows what source files are interesting and the user may not agree with its choices.  It's a  script  and	should	be
       easy to modify.	Ultimately this should probably be configurable.

       codechanges uses a program called decomment which guesses how to de-comment a file based on its file name and it's not always perfect.

AUTHOR

       Paul Bame

SEE ALSO

       pmccabe(1), decomment(1)

HP
								     12Feb2003							    codechanges(1)
All times are GMT -4. The time now is 07:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy