Sponsored Content
Full Discussion: replace the column values.
Top Forums Shell Programming and Scripting replace the column values. Post 302180429 by charandevu on Monday 31st of March 2008 07:39:22 AM
Old 03-31-2008
replace the column values.

I have the below file ...where some of the column values should replaced with desired values ....below file u can find that 3 column where ever 'AAA' comes should replaced with ' CC '

NOTE : we have to pass the column number ,AAA,CC (modified value) as the parameters to the code.

File 1 :

E100,A456,AAA,E12
E101,A22,BBB,E13
E101,A,AAA,E14


Result file :

E100,A456,CC,E12
E101,A22,BBB,E13
E101,A,CC,E14


Please help .....
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

replace a column values with the first value in column

Hi All, I have a file which has data in following format: "Body_Model","2/1/2007","2/1/2007" "CSCH74","0","61" "CSCS74","0","647" "CSCX74","0","3" "CSYH74","0","299" "CSYS74","0","2514" "CSYX74","0","3" "Body_Model","3/1/2007","3/1/2007" "CSCH74","0","88" "CSCS74","0","489"... (3 Replies)
Discussion started by: sumeet
3 Replies

2. Shell Programming and Scripting

Find and replace duplicate column values in a row

I have file which as 12 columns and values like this 1,2,3,4,5 a,b,c,d,e b,c,a,e,f a,b,e,a,h if you see the first column has duplicate values, I need to identify (print it to console) the duplicate value (which is 'a') and also remove duplicate values like below. I could be in two... (5 Replies)
Discussion started by: nuthalapati
5 Replies

3. UNIX for Dummies Questions & Answers

Replace values in a specified column of a file

Hello, I have a file with four columns and I would like to replace values in the second column only. An arbitrary example is: 100 A 105 B 200 B 205 C 300 C 305 D 400 D 405 E 500 E 505 F I need to replace the second column as shown below: ... (4 Replies)
Discussion started by: Gussifinknottle
4 Replies

4. Shell Programming and Scripting

sed replace values of column with ordered numbering

Hello, I am trying to write a shell script that will create a gnuplot file. My main problem is that I have a data file with two columns: 1.05929120E+09 5.0000701214792 1.05930096E+09 5.00006386985764 1.05930584E+09 5.00019465404908 1.05931072E+09 5.00031960589719 ... (2 Replies)
Discussion started by: pau
2 Replies

5. UNIX for Dummies Questions & Answers

replace a column with values from another file

Dear all, I have a file1.pdb in pdb format and a dat file2 containing values, corresponding to the atoms in the pdb file. these values (file2.dat) need to be in the column instead of the 0.00 (file1) values for each atom in file1.pdb .(the red values must be replaced by the blue ones,in order)... (11 Replies)
Discussion started by: chen.xiao.po
11 Replies

6. Shell Programming and Scripting

Selective Replace awk column values

Hi, I have the following data: 2860377|"DATA1"|"DATA2"|"65343"|"DATA2"|"DATA4"|"11"|"DATA5"|"DATA6"|"65343"|"DATA7"|"0"|"8"|"1"|"NEGATIVE" 32340377|"DATA1"|"DATA2"|"65343"|"DATA2"|"DATA4"|"11"|"DATA5"|"DATA6"|"65343"|"DATA7"|"0"|"8"|"1"|"NEG-DID"... (3 Replies)
Discussion started by: sdohn
3 Replies

7. Shell Programming and Scripting

Replace column values from other file

I have one file as it has the following format File1 S No Site IP Address 1 Australia 192.168.0.1/26 2 Australia 192.168.0.2/26 3 Australia 192.168.0.3/26 I need awk/sed command to replace the column2 value ( under Site) with some other... (8 Replies)
Discussion started by: samaritan
8 Replies

8. UNIX for Dummies Questions & Answers

Replace all decimal values in a column

Hi My input file looks String000002 GeneWise CW 48945 49354 . - 0 Pt=PEQU_00004; String000002 LEN NA 52125 52604 0.945751 - . PID=PEQU_00005;lvid_id=PEQ_28708; String000002 LEN CW 52125 52604 . - 0 ... (3 Replies)
Discussion started by: siya@
3 Replies

9. Shell Programming and Scripting

Trying to get an awk script to replace values in column

I'm trying to make an awk script to compare values I've set as var1, var2, and var3 earlier in the script to the values in the userinputted column of four text files called Node1.txt, Node2.txt, Node3.txt, and Node4.txt and then replace the values in that userinputted column with either ttt or gcc,... (8 Replies)
Discussion started by: Eric1
8 Replies

10. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
mipadmin(1M)															      mipadmin(1M)

NAME
mipadmin - Mobile IPv4 administration utility SYNOPSIS
conf_file] [option] level] level] DESCRIPTION
is a program for performing Mobile IPv4 administration tasks, such as starting and stopping Mobile IPv4 daemons and getting information on various system parameters. The tool can interact with Mobile IPv4 daemons mipd(1M) and miprod(1M). Only root user can run When is started, the tool first reports the name and PID of the Mobile IPv4 daemon running on the system, if any. Based on this report, the user is restricted on the options that can be used. For instance, most reporting options cannot be used when no daemon is running. Another example is that the option cannot be used if a Mobile IPv4 daemon is found running. Options recognizes the following options. These can be given as command line arguments or as commands in a session. To start a session, execute without any command line arguments. options can be classified into two kinds: Administrative and Reporting. Administrative Options These options must be used exclusively, that is, they cannot be used with other administrative or reporting options. These options can be used at the command line or at the session prompt. (Abbr.: Start a Mobile IPv4 daemon. and specify the daemon to start. Note that will verify that the daemon is running before allowing use of certain reporting options. If no daemon is specified with this option, is the default daemon. (mobility agent) starts and (correspondent node) starts and cannot both be started on the same system, since only one daemon can run on a single system. If is started, the user will be notified if any interface is restarted with enabled. (Abbr.: Specify the configuration file the daemon should use. If no file is specified, the tool will start with (see mipd.conf(4)) and with (see miprod.conf(4)). (Abbr.: Stop a Mobile IPv4 daemon. If the daemon stopped is will query it for the list of interfaces on which it offers services. These interfaces have enabled, which can be disabled once is stopped. These interfaces will be dis- played to the user and will be restarted with disabled if the daemon is stopped. (Abbr. Obtain help on options. option specifies the option for which help is required. (Abbr.: Exit the session. Reporting Options Multiple reporting options may be specified at the command line or can be concatenated to form commands at the session prompt. Options that report information from the daemon can be used only when a Mobile IPv4 daemon is running. Unless stated otherwise in the description, the option applies to both and Exceptions on the usage of an option is based on the type of daemon currently running. Certain options may apply only to while others only to Even in the case of some options may apply depending on the daemon's configuration with respect to AAA functionality. offering AAA functionality is said to be in 'AAA-mode'. This terminology is used in the option descriptions below. Note that can operate in two modes: normal and AAA-mode. The option can be used to verify the mode of operation. (Abbr.: Report configuration information from the daemon. Note that this information is not reported from the configuration file. For a list of configuration information, see mipconfig(1M) or mipd.conf(4) for and miproconfig(1M) or miprod.conf(4) for (Abbr.: Global configuration information. For this information includes any AAA data. (Abbr.: Information on all security associations configured on the daemon. For these include security asso- ciations to mobile or correspondent nodes. For the information is for all home agents. (Abbr.: Information on all interfaces configured on the daemon. For these include all interfaces on which Mobility Services are offered. For information is reported for the interface that is the source IP address for all tunnels created. (Abbr.: Reports all configuration data. It is also the default option if the user does not specify any option. (Abbr.: This option applies only to It reports any home agent mobility bindings information. The option sets display mode to verbose. (Abbr.: This option applies only to It reports foreign agent visitor list information. The option sets display mode to verbose. (Abbr.: Report general information and statistical counters from the daemon. The option resets statistical counters to 0. (Abbr.: Report events (if any) logged by daemon in syslogd(1M). This option may be used even when no daemon is running. The daemon whose events are reported is selected according to the following rules: If a daemon is specified, then the most recent instance of this daemon that has logged entries in syslog is selected. If daemon is unspecified and a daemon is currently running, then the the daemon currently running is selected. If dae- mon is unspecified and no daemon is currently running, then the most recent instance of that has logged entries in sys- log is selected. selects the most recent instance of that logged entries into and selects the most recent instance of that logged entries into (Abbr.: The class of events to display. If this option is not used, then the events logged under all classes are dis- played. The level parameter may be repeated multiple times. Note that for each input to level, only events for that class are displayed. That is, events below this class in the event class hierarchy (if any) are not dis- played. (Abbr.: These messages include unrecoverable error conditions such as fatal configuration errors and daemon initialization errors. (Abbr.: These messages include recoverable error conditions including some Mobile Node registration failures. (Abbr.: These messages include conditions such as dropped packets due to unsupported features, or no system resources. (Abbr.: These messages provide detailed event logging for debugging and troubleshooting purposes. (Abbr.: Report contents of router advertisement messages sent out by This option applies only to The option sets display mode to verbose. (Abbr.: Report or change a daemon's logging level. (Abbr.: The new logging level will include any log levels below it in the hierarchy. The logging levels (from lowest to highest) are: (Abbr.: These messages include unrecoverable error conditions such as fatal configuration errors and daemon initialization errors. (Abbr.: These messages include recoverable error conditions including some Mobile Node registration failures. (Abbr.: These messages include events such as dropped packets due to unsupported features, or no system resources. (Abbr.: These messages provide detailed event logging for debugging and troubleshooting purposes. (Abbr.: Report information on any tunnels created by or For acting as a Foreign agent, this displays the tunnels from the For- eign agent to the Home Agents. For acting as a Home Agent, this displays the tunnels from the Home Agent to the For- eign Agents, and to Mobile nodes using a co-located address. For the tunnels report displays the tunnels from the Cor- respondent node to the Foreign Agent and to the Mobile nodes using a co-located address. This option may be used even when no daemon is running. The option sets display mode to verbose. (Abbr.: Report version information from the daemon. (Abbr.: Report route optimization information from the daemon. For it reports the Binding Update messages sent to correspon- dent nodes. For the option reports the Correspondent Node's Binding Cache. The option sets display mode to verbose. (Abbr.: This option applies only to operating in AAA-mode. It reports information from the dynamic home address pools (if any). Information includes addresses in the pool and whether or not they have been allocated to a Mobile Node (identi- fied by NAI). (Abbr.: This option applies only to operating in AAA-mode. It reports information on any active AAA sessions maintained by the daemon. The option sets display mode to verbose. AUTHOR was developed by Hewlett-Packard Company. SEE ALSO mipd(1M), mipconfig(1M), miproconfig(1M), miprod(1M), mipd.conf(4), miprod.conf(4). mipadmin(1M)
All times are GMT -4. The time now is 04:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy