Sponsored Content
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
IP-NEIGHBOUR(8) 						       Linux							   IP-NEIGHBOUR(8)

NAME
ip-neighbour - neighbour/arp tables management. SYNOPSIS
ip [ OPTIONS ] neigh { COMMAND | help } ip neigh { add | del | change | replace } { ADDR [ lladdr LLADDR ] [ nud STATE ] | proxy ADDR } [ dev DEV ] ip neigh { show | flush } [ proxy ] [ to PREFIX ] [ dev DEV ] [ nud STATE ] [ vrf NAME ] STATE := { permanent | noarp | stale | reachable | none | incomplete | delay | probe | failed } DESCRIPTION
The ip neigh command manipulates neighbour objects that establish bindings between protocol addresses and link layer addresses for hosts sharing the same link. Neighbour entries are organized into tables. The IPv4 neighbour table is also known by another name - the ARP ta- ble. The corresponding commands display neighbour bindings and their properties, add new neighbour entries and delete old ones. ip neighbour add add a new neighbour entry ip neighbour change change an existing entry ip neighbour replace add a new entry or change an existing one These commands create new neighbour records or update existing ones. to ADDRESS (default) the protocol address of the neighbour. It is either an IPv4 or IPv6 address. dev NAME the interface to which this neighbour is attached. lladdr LLADDRESS the link layer address of the neighbour. LLADDRESS can also be null. nud STATE the state of the neighbour entry. nud is an abbreviation for 'Neighbour Unreachability Detection'. The state can take one of the following values: permanent the neighbour entry is valid forever and can be only be removed administratively. noarp the neighbour entry is valid. No attempts to validate this entry will be made but it can be removed when its lifetime expires. reachable the neighbour entry is valid until the reachability timeout expires. stale the neighbour entry is valid but suspicious. This option to ip neigh does not change the neighbour state if it was valid and the address is not changed by this command. none this is a pseudo state used when initially creating a neighbour entry or after trying to remove it before it becomes free to do so. incomplete the neighbour entry has not (yet) been validated/resolved. delay neighbor entry validation is currently delayed. probe neighbor is being probed. failed max number of probes exceeded without success, neighbor validation has ultimately failed. ip neighbour delete delete a neighbour entry The arguments are the same as with ip neigh add, except that lladdr and nud are ignored. Warning: Attempts to delete or manually change a noarp entry created by the kernel may result in unpredictable behaviour. Particu- larly, the kernel may try to resolve this address even on a NOARP interface or if the address is multicast or broadcast. ip neighbour show list neighbour entries to ADDRESS (default) the prefix selecting the neighbours to list. dev NAME only list the neighbours attached to this device. vrf NAME only list the neighbours for given VRF. proxy list neighbour proxies. unused only list neighbours which are not currently in use. nud STATE only list neighbour entries in this state. NUD_STATE takes values listed below or the special value all which means all states. This option may occur more than once. If this option is absent, ip lists all entries except for none and noarp. ip neighbour flush flush neighbour entries This command has the same arguments as show. The differences are that it does not run when no arguments are given, and that the default neighbour states to be flushed do not include permanent and noarp. With the -statistics option, the command becomes verbose. It prints out the number of deleted neighbours and the number of rounds made to flush the neighbour table. If the option is given twice, ip neigh flush also dumps all the deleted neighbours. EXAMPLES
ip neighbour Shows the current neighbour table in kernel. ip neigh flush dev eth0 Removes entries in the neighbour table on device eth0. SEE ALSO
ip(8) AUTHOR
Original Manpage by Michail Litvak <mci@owl.openwall.com> iproute2 20 Dec 2011 IP-NEIGHBOUR(8)
All times are GMT -4. The time now is 10:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy