Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to separate data with varying amounts of underscores?
Top Forums Shell Programming and Scripting How to separate data with varying amounts of underscores? Post 302923222 by turk22 on Friday 31st of October 2014 10:15:02 AM
Old 10-31-2014
How to separate data with varying amounts of underscores?
All, I've searched and haven't found a solution for my particular issue.

I have a file with lines of data that contain varying amounts of underscores imbedded. But all the strings have a final underscore and an interface name:

dmk_hcn_dalian2.XXXX.XXX.XX.COM_Se0/0/0
cn_beijing_terminalserver.XXX.XX.COM_Se0
aurtrpara_1.XXXXX.XXX.XX.COM_Tu108
aurtrpara_2.XXXX.XXX.XX.COM_Tu202
dmk_hcn_dalian1.XXX.XX.COM_Se0/0/0
buranda_2.XXX.XX.COM_Tu215

I need to cut each line at the last underscore, keeping the interface name as one variable, and the Fully Qualified Domain name as another. The problem is that the domain has varying amount of periods as well.
Does anyone have a recommendation to get the output I need with awk/cut/ or sed?

appreciate any suggestions!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

count data separate by comma

hi experts, i have some problem with count data which separate by comma, below sample data : 01,011222823b6d,011222823f29,0028a5,002993,6212345678, 659111111111,6598204507,6281105008,6596197849,_,525016160836958,_, ffffffff,000000000000000000000000,_,_,_,fd,fd,ff,00,1,0028a5-002993,_,... (10 Replies)
Discussion started by: bucci
10 Replies

2. Shell Programming and Scripting

Parse apart strings of comma separated data with varying number of fields

I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file.... (7 Replies)
Discussion started by: 2reperry
7 Replies

3. Shell Programming and Scripting

Using AWK to separate data from a large XML file into multiple files

I have a 500 MB XML file from a FileMaker database export, it's formatted horribly (no line breaks at all). The node structure is basically <FMPXMLRESULT> <METADATA> <FIELD att="............." id="..."/> </METADATA> <RESULTSET FOUND="1763457"> <ROW att="....." etc="...."> ... (16 Replies)
Discussion started by: JRy
16 Replies

4. UNIX for Dummies Questions & Answers

How to Separate Odd and Even number from one data set?

Hi, If I want to separate data set to new file by odd and even number. If data set like this 1 ABC 235 hgf 2 DEF 326 kjk 3 XXX 133 kwd 4 YYY 188 fgh If I want separate by colum3 I want result like set 1 1 ABC 235 hgf 3 XXX 133 kwd put to new... (3 Replies)
Discussion started by: GeodusT
3 Replies

5. UNIX for Dummies Questions & Answers

Help with varying data

I have flat file in which the length of the a record is 1000 characters. the last field of the file range is from 951 to 1000. So currently i am getting the last field data to be less than 1000 characters ( from 951 to 1000 i see that the data varies from 10 to 50). So is there a way we can pad up... (18 Replies)
Discussion started by: akshay01987
18 Replies

6. Shell Programming and Scripting

Divide data into separate files

frnds: i want to divide data on the behalf of dotted line and redirectd into new files ) ------------------------- M-GET CONFIRMATION ( ------------------------- M-GET CONFIRMATION ( INVOKE IDENTIFIER final data shuld be into 3 files ...... (6 Replies)
Discussion started by: dodasajan
6 Replies

7. Shell Programming and Scripting

Divide data with specific column values into separate files

hello! i need a little help from you :) ... i need to split a file into separate files depending on two conditions using scripting. The file has no delimiters. The conditions are col 17 = "P" and col 81 = "*", this will go to one output file; col 17 = "R" and col 81 = " ". Here is an example. ... (3 Replies)
Discussion started by: chanclitas
3 Replies

8. Shell Programming and Scripting

How to separate rows of data into another column?

I have data such as below where the value in second field is the same as that in the row after. 123456,22222,John,0,xyz 234567,22222,John1,1,cde 43212,3333,Jean,3,pip 84324,3333,Abel,2,cat I'd like to rearrange the output like below to put such records beside each other and separated with... (5 Replies)
Discussion started by: james2009
5 Replies

9. Shell Programming and Scripting

How to separate data coming in one column of CSV file?

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file. The issue is that all the data comes in to the same column, i want them to be separated in different columns. SQL_COMMAND=command.sql file=file.txt formatFile=formatFile.txt report=report.csv echo... (1 Reply)
Discussion started by: Sharma331
1 Replies

10. UNIX for Beginners Questions & Answers

How to Dump data into CSV file which is Separate by <tab>?

Dear Team, please help me to solve this problem using Linux command. I want to dump this data into an excel sheet, Suppose I have a string like: ABC PQR XYZ ASD then I expect output as a ABC XYZ PQR ASD (3 Replies)
Discussion started by: Shubham1182
3 Replies

LEARN ABOUT DEBIAN

datetime::locale::ti_er

DateTime::Locale::ti_ER(3pm)				User Contributed Perl Documentation			      DateTime::Locale::ti_ER(3pm)

NAME

       DateTime::Locale::ti_ER - DateTime locale package for "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.10.1							    2010-03-19					      DateTime::Locale::ti_ER(3pm)
All times are GMT -4. The time now is 04:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy