Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed command to add a new column entry
Top Forums Shell Programming and Scripting sed command to add a new column entry Post 302996302 by RudiC on Monday 24th of April 2017 04:43:56 AM
Old 04-24-2017
For the IP2int function, try also
Code:
function IP2int(IP)     {split (IP, T, ".")
                         TMP = sprintf ("0X%02X%02X%02X%02X", T[1], T[2], T[3], T[4])
                         printf (length(TMP) <= 10) ? "%.f\n" : "illegal IP: %s\n",  TMP
                        }
.
.
.
illegal IP: 0X057A11919D
3604427922
illegal IP: 0X06FE144DB
2463642519
1623842262

These 2 Users Gave Thanks to RudiC For This Post:
Don Cragun sampitosh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to specify the column(field) in sed command

the following command removes the first two characters of the first column, how can I change it to to remove the first two characters of the second column? sed 's/^..//' file1.txt > file2.txt Thanks Joseph (4 Replies)
Discussion started by: jdhahbi
4 Replies

2. Shell Programming and Scripting

sed copy column value add to certain area

I have a base file FILE1 with the following data FILE1.dat 21111111110001343 000001004OLFXXX029100020091112 21111111110000060 000001004ODL-CH001000020091112 22222222220000780 000001013OLFXXX006500020091112 23333333330001695 000001039OLFXXX030600020091112 23333333330000111... (2 Replies)
Discussion started by: kshuser
2 Replies

3. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

6. UNIX for Dummies Questions & Answers

List 2nd column entry from a command

How can i retrieve 2nd column only from output of "ls - l " as my output. pls help (5 Replies)
Discussion started by: upvan111
5 Replies

7. Shell Programming and Scripting

How to search and replace string in column in file with command sed?

how to search and replace string in column in file with command sed or other search "INC0000003.in" and replace column 4 = "W" $ cat file.txt INC0000001.in|20150120|Y|N|N INC0000002.in|20150120|Y|N|N INC0000003.in|20150120|Y|N|N INC0000004.in|20150120|Y|N|Noutput... (4 Replies)
Discussion started by: ppmanja3
4 Replies

8. Shell Programming and Scripting

How to replace multiple "&nbsp;" entry with in <td> tag into single entry using sed?

I have the input file like this. Input file: 12.txt 1) There are one or more than one <tr> tags in same line. 2) Some tr tags may have one <td> or more tna one <td> tags within it. 3) Few <td> tags having "<td> &nbsp; </td>". Few having more than one "&nbsp;" entry in it. <tr> some td... (4 Replies)
Discussion started by: thomasraj87
4 Replies

9. Shell Programming and Scripting

sed command to replace multiple column in one go

Hi, I want to replace the value in more than one column. For one column ,following command is working - sed 's/./$value_to_replace/$column number' file_name e.g. suppose this is input 1111000000 command - sed 's/./M/5' output= 1111M000000 For two column also command is like - cat... (22 Replies)
Discussion started by: Preeti Chandra
22 Replies

10. UNIX for Beginners Questions & Answers

Awk/sed summation of one column based on some entry in first column

Hi All , I am having an input file as stated below Input file 6 ddk/djhdj/djhdj/Q 10 0.5 dhd/jdjd.djd.nd/QB 01 0.5 hdhd/jd/jd/jdj/Q 10 0.5 512 hd/hdh/gdh/Q 01 0.5 jdjd/jd/ud/j/QB 10 0.5 HD/jsj/djd/Q 01 0.5 71 hdh/jjd/dj/jd/Q 10 0.5 ... (5 Replies)
Discussion started by: kshitij
5 Replies

LEARN ABOUT MOJAVE

datetime::locale::ar_tn

DateTime::Locale::ar_TN(3)				User Contributed Perl Documentation				DateTime::Locale::ar_TN(3)

NAME

       DateTime::Locale::ar_TN

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'ar_TN' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Arabic Tunisia.

DATA

       This locale inherits from the DateTime::Locale::ar locale.

       It contains the following data.

   Days
       Wide (format)

	 XXXXXXX
	 XXXXXXXX
	 XXXXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (format)

	 XXXXXXX
	 XXXXXXXX
	 XXXXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Narrow (format)

	 XXXXXXX
	 XXXXXXXX
	 XXXXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Wide (stand-alone)

	 XXXXXXX
	 XXXXXXXX
	 XXXXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (stand-alone)

	 XXXXXXX
	 XXXXXXXX
	 XXXXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Months
       Wide (format)

	 XXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX

       Abbreviated (format)

	 XXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX

       Abbreviated (stand-alone)

	 XXXXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Quarters
       Wide (format)

	 XXXXX XXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX

       Abbreviated (format)

	 XXXXX XXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX

       Narrow (format)

	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXX XXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX

       Abbreviated (stand-alone)

	 XXXXX XXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX
	 XXXXX XXXXXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X

   Eras
       Wide

	 XXX XXXXXXX
	 XXXXXX

       Abbreviated

	 X.X
	 X

       Narrow

	 X.X
	 X

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXXXX 5 XXXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXXX 22 XXXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXX 15 XXXXXXX -10

       Long

	  2008-02-05T18:30:30 = 5 XXXXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10

       Medium

	  2008-02-05T18:30:30 = 05X/02X/2008
	  1995-12-22T09:05:02 = 22X/12X/1995
	 -0010-09-15T04:44:23 = 15X/09X/-010

       Short

	  2008-02-05T18:30:30 = 5X/2X/2008
	  1995-12-22T09:05:02 = 22X/12X/1995
	 -0010-09-15T04:44:23 = 15X/9X/-010

       Default

	  2008-02-05T18:30:30 = 05X/02X/2008
	  1995-12-22T09:05:02 = 22X/12X/1995
	 -0010-09-15T04:44:23 = 15X/09X/-010

   Time Formats
       Full

	  2008-02-05T18:30:30 = UTC 6:30:30 X
	  1995-12-22T09:05:02 = UTC 9:05:02 X
	 -0010-09-15T04:44:23 = UTC 4:44:23 X

       Long

	  2008-02-05T18:30:30 = UTC 6:30:30 X
	  1995-12-22T09:05:02 = UTC 9:05:02 X
	 -0010-09-15T04:44:23 = UTC 4:44:23 X

       Medium

	  2008-02-05T18:30:30 = 6:30:30 X
	  1995-12-22T09:05:02 = 9:05:02 X
	 -0010-09-15T04:44:23 = 4:44:23 X

       Short

	  2008-02-05T18:30:30 = 6:30 X
	  1995-12-22T09:05:02 = 9:05 X
	 -0010-09-15T04:44:23 = 4:44 X

       Default

	  2008-02-05T18:30:30 = 6:30:30 X
	  1995-12-22T09:05:02 = 9:05:02 X
	 -0010-09-15T04:44:23 = 4:44:23 X

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXXXX 5 XXXXXXX 2008 UTC 6:30:30 X
	  1995-12-22T09:05:02 = XXXXXXX 22 XXXXXXX 1995 UTC 9:05:02 X
	 -0010-09-15T04:44:23 = XXXXXX 15 XXXXXXX -10 UTC 4:44:23 X

       Long

	  2008-02-05T18:30:30 = 5 XXXXXXX 2008 UTC 6:30:30 X
	  1995-12-22T09:05:02 = 22 XXXXXXX 1995 UTC 9:05:02 X
	 -0010-09-15T04:44:23 = 15 XXXXXXX -10 UTC 4:44:23 X

       Medium

	  2008-02-05T18:30:30 = 05X/02X/2008 6:30:30 X
	  1995-12-22T09:05:02 = 22X/12X/1995 9:05:02 X
	 -0010-09-15T04:44:23 = 15X/09X/-010 4:44:23 X

       Short

	  2008-02-05T18:30:30 = 5X/2X/2008 6:30 X
	  1995-12-22T09:05:02 = 22X/12X/1995 9:05 X
	 -0010-09-15T04:44:23 = 15X/9X/-010 4:44 X

       Default

	  2008-02-05T18:30:30 = 05X/02X/2008 6:30:30 X
	  1995-12-22T09:05:02 = 22X/12X/1995 9:05:02 X
	 -0010-09-15T04:44:23 = 15X/09X/-010 4:44:23 X

   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 XXXXXXXX
	  1995-12-22T09:05:02 = 22 XXXXXX
	 -0010-09-15T04:44:23 = 15 XXXXX

       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 X
	  1995-12-22T09:05:02 = 9:05 X
	 -0010-09-15T04:44:23 = 4:44 X

       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 X
	  1995-12-22T09:05:02 = 9:05:02 X
	 -0010-09-15T04:44:23 = 4:44:23 X

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (d/XM)

	  2008-02-05T18:30:30 = 5/X2
	  1995-12-22T09:05:02 = 22/X12
	 -0010-09-15T04:44:23 = 15/X9

       MEd (EX d-M)

	  2008-02-05T18:30:30 = XXXXXXXXX 5-2
	  1995-12-22T09:05:02 = XXXXXXX 22-12
	 -0010-09-15T04:44:23 = XXXXXX 15-9

       MMdd (ddX/MM)

	  2008-02-05T18:30:30 = 05X/02
	  1995-12-22T09:05:02 = 22X/12
	 -0010-09-15T04:44:23 = 15X/09

       MMM (LLL)

	  2008-02-05T18:30:30 = XXXXXX
	  1995-12-22T09:05:02 = XXXXXX
	 -0010-09-15T04:44:23 = XXXXXX

       MMMd (d MMM)

	  2008-02-05T18:30:30 = 5 XXXXXX
	  1995-12-22T09:05:02 = 22 XXXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXX

       MMMEd (E d MMM)

	  2008-02-05T18:30:30 = XXXXXXXX 5 XXXXXX
	  1995-12-22T09:05:02 = XXXXXX 22 XXXXXX
	 -0010-09-15T04:44:23 = XXXXX 15 XXXXXX

       MMMMd (d MMMM)

	  2008-02-05T18:30:30 = 5 XXXXXX
	  1995-12-22T09:05:02 = 22 XXXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXX

       MMMMEd (E d MMMM)

	  2008-02-05T18:30:30 = XXXXXXXX 5 XXXXXX
	  1995-12-22T09:05:02 = XXXXXX 22 XXXXXX
	 -0010-09-15T04:44:23 = XXXXX 15 XXXXXX

       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 (MX/yyyy)

	  2008-02-05T18:30:30 = 2X/2008
	  1995-12-22T09:05:02 = 12X/1995
	 -0010-09-15T04:44:23 = 9X/-010

       yMEd (EEEX d/XM/Xyyyy)

	  2008-02-05T18:30:30 = XXXXXXXXX 5/X2/X2008
	  1995-12-22T09:05:02 = XXXXXXX 22/X12/X1995
	 -0010-09-15T04:44:23 = XXXXXX 15/X9/X-010

       yMMM (MMM y)

	  2008-02-05T18:30:30 = XXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXX -10

       yMMMEd (EEEX d MMMM y)

	  2008-02-05T18:30:30 = XXXXXXXXX 5 XXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXXX 22 XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXX 15 XXXXXX -10

       yMMMM (MMMM y)

	  2008-02-05T18:30:30 = XXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXX -10

       yQ (yyyy Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -010 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 XXXXX XXXXX
	  1995-12-22T09:05:02 = 1995 XXXXX XXXXXX
	 -0010-09-15T04:44:23 = -10 XXXXX XXXXXX

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMM (MMX/yyyy)

	  2008-02-05T18:30:30 = 02X/2008
	  1995-12-22T09:05:02 = 12X/1995
	 -0010-09-15T04:44:23 = 09X/-010

       yyyyMMMM (MMMMX y)

	  2008-02-05T18:30:30 = XXXXXXX 2008
	  1995-12-22T09:05:02 = XXXXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXXX -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XXXXX

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::ar_TN(3)
All times are GMT -4. The time now is 05:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy