Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Insert data in first column(if blank) from previous line first column
Top Forums Shell Programming and Scripting Insert data in first column(if blank) from previous line first column Post 302904480 by jaydeep_sadaria on Wednesday 4th of June 2014 09:06:45 AM
Old 06-04-2014
Insert data in first column(if blank) from previous line first column
Dear Team

I need to insert field(which is need to taken from previous line's first field) in first column if its blank. I had tried using sed but not find the way. Detail input and output file as below.

Kindly help for same.

INPUT:
Code:
SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 488  0   RTPGD-3456     RBLT2-5665     31        1  WO
      1   RTPGD-3616     RBLT2-2849     31      287  WO

SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 490  0   RTPGD-672      RBLT2-5729     31        1  WO

SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 491  0   RTPGD-16544    RBLT2-5761     25        1  WO
      2   RTPGD-16576    RBLT2-7233     25      287  WO

SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 492  0   RTPGD-18624    RBLT2-5793     31        1  WO


OUTPUT REQUIRED:

Code:
SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 488  0   RTPGD-3456     RBLT2-5665     31        1  WO
 488  1   RTPGD-3616     RBLT2-2849     31      287  WO

SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 490  0   RTPGD-672      RBLT2-5729     31        1  WO

SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 491  0   RTPGD-16544    RBLT2-5761     25        1  WO
 491  2   RTPGD-16576    RBLT2-7233     25      287  WO

SCGR  SC  DEV            DEV1           NUMDEV  DCP  STATE
 492  0   RTPGD-18624    RBLT2-5793     31        1  WO


Regards
Jaydeep Sadaria
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert first line of a file to first column of remaining files

I want to extraxt data from a html table the html file is downloaded from UG / PG Univ - Exam.Results April/May 2008 After processing the html file using sed i got the output like this 11305106082,RANJANI R, CS1251,20,69,P CS1302,20,45,P EC1006,20,52,P EC1351,20,53,P... (5 Replies)
Discussion started by: a_artha
5 Replies

2. Shell Programming and Scripting

Insert new line based on numerical number of column

My input file: Class Number Position Range 1 Initial 50 1 Initial 50 2 Terminal 150 2 Terminal 20 2 Single 10 3 Single 20 4 Double 50 5 Initial 50 5 Initial 60 Class Number... (11 Replies)
Discussion started by: patrick87
11 Replies

3. Shell Programming and Scripting

Can sed be used to insert data at specific column?

I'm trying to use sed to insert data at a specific column, let's say my data looks like this: 0553 1828 0552 1829 0550 1829 0549 1830 0548 1831 what I want is this: timein 0553 timeout 1828 timein 0552 timeout 1829 timein 0550 timeout 1829 timein 0549 timeout 1830 timein 0548... (5 Replies)
Discussion started by: mswartz
5 Replies

4. Shell Programming and Scripting

Insert and shifting data at column

Hi all, i have data like this joe : 1 :a bob : 2 :b sue : 3 :c foo : 4 :d at column 2 i want to insert TOP to the top column and at column 3 i want to insert BOTTOM to the bottom column. and the result will... (12 Replies)
Discussion started by: psychop13
12 Replies

5. Shell Programming and Scripting

Read column values from previous and next line using awk

Hi, I have a csv file which contains data that looks something like this: Key1 Key2 Key3 New_Key1 New_Key2 New_Key3 102 30 0 - - - 102 40 1 30 40 50 102 50 2 40 50 ... (4 Replies)
Discussion started by: Nishi_Licious
4 Replies

6. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

7. Shell Programming and Scripting

Add a character C in a column if that column is blank

I have some files that look as follows. I need to add a character 'C' in the fifth column if that column is blank. I prefer in-place editing. 1 1 B M 0 0 203 0, 0.0 0, 0.0 0, 0.0 0, 0.0 0.000 360.0 360.0 360.0 141.9 15.4 28.8 66.1 2 2 B A ... (21 Replies)
Discussion started by: thejitha
21 Replies

8. Shell Programming and Scripting

Fill data in column with previous value

Gents, Kindly help me. I have a file with empty values in selected column, I will like to fill the empty values with the previous value. Example Input file X 4959 30010 66727.00 20457.001 1 1441 66512.00 20234.00 20520.001 X 4959 30010 66727.00 20457.001 145 ... (7 Replies)
Discussion started by: jiam912
7 Replies

9. Shell Programming and Scripting

Split column when value in column is blank in any row

Hi Experts, In short : Need to split file when field in column 5 is blank and need to generate two file in which column 5 is blank and other in which column 5 has values along with other rows and column data My issue is i am not able to get header for column from raw file into new file which... (1 Reply)
Discussion started by: as7951
1 Replies

10. UNIX for Beginners Questions & Answers

How to insert data into black column( Secound Column ) in excel (.XLSX) file using shell script?

Source Code of the original script is down below please run the script and try to solve this problem this is my data and I want it column wise 2019-03-20 13:00:00:000 2019-03-20 15:00:00:000 1 Operating System LAB 0 1 1 1 1 1 1 1 1 1 0 1 (5 Replies)
Discussion started by: Shubham1182
5 Replies

LEARN ABOUT DEBIAN

ip-ntable

IP-NTABLE(8)							       Linux							      IP-NTABLE(8)

NAME

       ip-ntable - neighbour table configuration

SYNOPSIS

       ip [ OPTIONS ] address  { COMMAND | help }

       ip ntable change name NAME [ dev DEV ] PARMS

       PARMS := { thresh1 VAL | thresh2 VAL | thresh3 VAL | gc_int MSEC | base_reachable MSEC | retrans MSEC | gc_stale MSEC  | delay_probe MSEC |
	       queue LEN  | app_probs VAL | ucast_probes VAL | mcast_probes VAL  | anycast_delay MSEC | proxy_delay MSEC | proxy_queue LEN  |
	       locktime MSEC }

       ip ntable show [ dev DEV ] [ name NAME ]

DESCRIPTION

       ip ntable controls the parameters for the neighbour tables.

   ip ntable show - list the ip neighbour tables
       This commands displays neighbour table parameters and statistics.

       dev DEV
	      only list the table attached to this device.

       name NAME
	      only lists the table with the given name.

   ip ntable change - modify table parameter
       This command allows modifying table parameters such as timers and queue lengths.

       name NAME
	      the name of the table to modify.

       dev DEV
	      the name of the device to modify the table values.

EXAMPLES

       ip ntable show dev eth0
	   Shows the neighbour table (IPv4 ARP and IPv6 ndisc) parameters on device eth0.

       ip ntable change name arp_cache queue 8 dev eth0
	   Changes the number of packets queued while address is being resolved from the default value (3) to 8 packets.

SEE ALSO

       ip(8)

AUTHOR

       Manpage by Stephen Hemminger

iproute2							    20 Dec 2011 						      IP-NTABLE(8)
All times are GMT -4. The time now is 03:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy