Sponsored Content
Full Discussion: replace the column values.
Top Forums Shell Programming and Scripting replace the column values. Post 302180829 by aigles on Tuesday 1st of April 2008 09:12:34 AM
Old 04-01-2008
Code:
awk '
   BEGIN { FS=OFS="," }
   $3 == "AAA" { $3 = "CC" }
   $5 == "MMM" { $5 = "XXX" }
   1
    ' inputfile

Jean-Pierre.
 

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
DateTime::Locale::ti_ER(3)				User Contributed Perl Documentation				DateTime::Locale::ti_ER(3)

NAME
DateTime::Locale::ti_ER SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'ti_ER' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Tigrinya Eritrea. DATA
This locale inherits from the DateTime::Locale::ti locale. It contains the following data. Days Wide (format) XXX XXX XXX XXX XXX XXX XXXX Abbreviated (format) XXX XXX XXX XXX XXX XXX XXX Narrow (format) X X X X X X X Wide (stand-alone) XXX XXX XXX XXX XXX XXX XXXX Abbreviated (stand-alone) XXX XXX XXX XXX XXX XXX XXX Narrow (stand-alone) X X X X X X X Months Wide (format) XX XXXX XXXX XXXX XXXX XX XXX XXX XXXXX XXXX XXX XXXX Abbreviated (format) XX XXX XXX XXX XXX XX XXX XXX XXX XXX XXX XXX Narrow (format) XX XXX XXX XXX XXX XX XXX XXX XXX XXX XXX XXX Wide (stand-alone) XX XXXX XXXX XXXX XXXX XX XXX XXX XXXXX XXXX XXX XXXX Abbreviated (stand-alone) XX XXX XXX XXX XXX XX XXX XXX XXX XXX XXX XXX Narrow (stand-alone) X X X X X X X X X X X X Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated X/X X/X Narrow X/X X/X Date Formats Full 2008-02-05T18:30:30 = XXXX 05 XXXX XXXX 2008 X/X 1995-12-22T09:05:02 = XXXX 22 XXXX XXXX 1995 X/X -0010-09-15T04:44:23 = XXXX 15 XXXXX XXXX -10 X/X Long 2008-02-05T18:30:30 = 05 XXXX 2008 1995-12-22T09:05:02 = 22 XXXX 1995 -0010-09-15T04:44:23 = 15 XXXXX -10 Medium 2008-02-05T18:30:30 = 05-XXX-2008 1995-12-22T09:05:02 = 22-XXX-1995 -0010-09-15T04:44:23 = 15-XXX--10 Short 2008-02-05T18:30:30 = 05/02/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/09/-10 Default 2008-02-05T18:30:30 = 05-XXX-2008 1995-12-22T09:05:02 = 22-XXX-1995 -0010-09-15T04:44:23 = 15-XXX--10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = 4:44:23 XXX XXX UTC Long 2008-02-05T18:30:30 = 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = 4:44:23 XXX XXX UTC Medium 2008-02-05T18:30:30 = 6:30:30 XXX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XXX Short 2008-02-05T18:30:30 = 6:30 XXX XXX 1995-12-22T09:05:02 = 9:05 XXX XXX -0010-09-15T04:44:23 = 4:44 XXX XXX Default 2008-02-05T18:30:30 = 6:30:30 XXX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XXX Datetime Formats Full 2008-02-05T18:30:30 = XXXX 05 XXXX XXXX 2008 X/X 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = XXXX 22 XXXX XXXX 1995 X/X 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = XXXX 15 XXXXX XXXX -10 X/X 4:44:23 XXX XXX UTC Long 2008-02-05T18:30:30 = 05 XXXX 2008 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = 22 XXXX 1995 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXX XXX UTC Medium 2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XXX XXX 1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX XXX -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX XXX Short 2008-02-05T18:30:30 = 05/02/08 6:30 XXX XXX 1995-12-22T09:05:02 = 22/12/95 9:05 XXX XXX -0010-09-15T04:44:23 = 15/09/-10 4:44 XXX XXX Default 2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XXX XXX 1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX XXX -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX XXX Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 XXX 1995-12-22T09:05:02 = 22 XXX -0010-09-15T04:44:23 = 15 XXX Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 XXX XXX 1995-12-22T09:05:02 = 9:05 XXX XXX -0010-09-15T04:44:23 = 4:44 XXX XXX Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 XXX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XXX M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (M-d) 2008-02-05T18:30:30 = 2-5 1995-12-22T09:05:02 = 12-22 -0010-09-15T04:44:23 = 9-15 MEd (E, M-d) 2008-02-05T18:30:30 = XXX, 2-5 1995-12-22T09:05:02 = XXX, 12-22 -0010-09-15T04:44:23 = XXX, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = XXX 1995-12-22T09:05:02 = XXX -0010-09-15T04:44:23 = XXX MMMd (MMM d) 2008-02-05T18:30:30 = XXX 5 1995-12-22T09:05:02 = XXX 22 -0010-09-15T04:44:23 = XXX 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = XXX XXX 5 1995-12-22T09:05:02 = XXX XXX 22 -0010-09-15T04:44:23 = XXX XXX 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = XXXX 5 1995-12-22T09:05:02 = XXXX 22 -0010-09-15T04:44:23 = XXXXX 15 MMMMdd (dd MMMM) 2008-02-05T18:30:30 = 05 XXXX 1995-12-22T09:05:02 = 22 XXXX -0010-09-15T04:44:23 = 15 XXXXX MMMMEd (E MMMM d) 2008-02-05T18:30:30 = XXX XXXX 5 1995-12-22T09:05:02 = XXX XXXX 22 -0010-09-15T04:44:23 = XXX XXXXX 15 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = XXX, 2008-2-5 1995-12-22T09:05:02 = XXX, 1995-12-22 -0010-09-15T04:44:23 = XXX, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 XXX 1995-12-22T09:05:02 = 1995 XXX -0010-09-15T04:44:23 = -10 XXX yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = XXX, 2008 XXX 5 1995-12-22T09:05:02 = XXX, 1995 XXX 22 -0010-09-15T04:44:23 = XXX, -10 XXX 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 XXXX 1995-12-22T09:05:02 = 1995 XXXX -0010-09-15T04:44:23 = -10 XXXXX yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = XXXX 2008 1995-12-22T09:05:02 = XXXX 1995 -0010-09-15T04:44:23 = XXXXX -10 Miscellaneous Prefers 24 hour time? No Local first day of the week XXX SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.18.2 2017-10-06 DateTime::Locale::ti_ER(3)
All times are GMT -4. The time now is 03:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy