Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Text manipulation help
Top Forums Shell Programming and Scripting Text manipulation help Post 302976031 by galford on Wednesday 22nd of June 2016 07:09:59 PM
Old 06-22-2016
Text manipulation help
Hello again,

I have a problem manipulating a large text document and there is no way I could edit this document by hand.

Format is:

Code:
Address : XXXX N 37 Ave, Hollywood, FL, 33021
Phone: XXX3190XXX
Player: XXXXXX
Character: Jaramillo 
DOB[mm-dd-yyyy]: June-14-1995
-----
Name: Alexandra
Ticket #: XXXXXXXXXXXXXXXXX
Creation Date: 03-2015
Ref: 299XXXXXX
====================
IP: 73.XXXXXXXX - 73.XXXXXXXX
Submited on: Wednesday 22nd of June 2016 04:31:28 PM



Address : XXXX XXXXXX SE, Washington (city), DC (state), 20032 (zipcode)
Phone: XXX5954XXX
Player: XXXXXX
Character: Hernandez
DOB[mm-dd-yyyy]: April-24-1986
-----
Name: GXX(1) JonXX(2)
Ticket #: XXXXXXXXXXXXXXXXX
Creation Date: 03-2016
Ref: 449XXXXXX
====================
IP: 66.44.XXXX - XXXXX.md.cable.rcn.com
Submited on: Monday 20th of June 2016 05:50:03 PM

And so on...

I want the whole list to be like this (only the values from the specific fields):

Code:
Ticket #|Creation Month|Creation Year|Ref|Name|Address|City|State|Zipcode|Phone|Player|DOB|IP

Is it possible. Please note... all fields are different in size.

Thank you.
Last edited by Don Cragun; 06-22-2016 at 10:05 PM.. Reason: Add CODE tags for sample output header.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Text Manipulation.

Hi I have only ever used awk and sed for basic requirements up until now. I have had to break a log down for multiple purposes. Using awk, sed and a date script. I am left with this: (message id, time of msg attempt, message id, domain name, time of msg completion) ... (4 Replies)
Discussion started by: Icepick
4 Replies

2. UNIX for Dummies Questions & Answers

text manipulation

I am tryin to figure out how to extract interested text from file example.txt blah blah blah a: child1 blah a: child2 blah b: parent1 blah blah blah .... blah a: child21 blah a: child22 blah a: child23 blah b: parent2 this kinda text repeats .. number of children is... (6 Replies)
Discussion started by: rajkishore
6 Replies

3. UNIX for Dummies Questions & Answers

Help with text manipulation

Hi there, I have some text files in unix format that processed by a program in windows, and when I open them with less or vi in linux, a warn for opening binary file is prompted, and as shown in vi, between every two characters there was inserted a "^@". How can I fix this. Plus, there are over... (2 Replies)
Discussion started by: dustinwang2003
2 Replies

4. UNIX for Dummies Questions & Answers

Text Manipulation

Greetings. Iīm a biologist and I donīt have mucho knowledge on Unix/Linux, but I need to use Cygwin to change some documents from a GenBank format to a FASTA format. GenBank format goes somthing like this: LOCUS NM_013964 2568 bp mRNA linear PRI 26-APR-2009... (2 Replies)
Discussion started by: vanesa1230
2 Replies

5. Shell Programming and Scripting

[HELP] Text manipulation... [HELP]

I need to know how can I remove all word after comma on each line. Like: jjkj,iiuiui,ijlkjkij,ookoo kijljlj,jhhkj,ijijkijkj,oijkijj kjkljlkj,kjkjlkjlkj,opok,okop to jjkj, kijljlj, ... (5 Replies)
Discussion started by: slutb3
5 Replies

6. UNIX for Dummies Questions & Answers

text manipulation help

Hello again unix.com How can I extract from a large file in format: steve@aol.com steve hawkins Location of this member is bla bla bla sun@hotmail.com Sun Ying This member is using browser bla bla bla to another text in format: steve@aol.com steve hawkins sun@hotmail.com sun ying ... (5 Replies)
Discussion started by: galford
5 Replies

7. UNIX for Dummies Questions & Answers

Text Manipulation Help

Hello Unix.com, I have a text in format: john sara lee How can I make it: john:john john:john1 john:john12 john:john123 sara:sara sara:sara12 sara:sara123 and so on (2 Replies)
Discussion started by: galford
2 Replies

8. UNIX for Dummies Questions & Answers

Text manipulation help

Hello unix.com users, I have a ip file (line-by-line). How can I delete the ips that keep repeating by mark XXX.XXX.XXX.* ... I want to erase only the lines that keep repeating more than 2 times. Example: 1.2.3.1 1.2.3.2 1.2.3.3 I want to erase all ips blocks that are repeating by C... (1 Reply)
Discussion started by: galford
1 Replies

9. UNIX for Dummies Questions & Answers

Text manipulation

i want to generate a list line-by-line of normal characters using letters . for example : dnds gnos mgod pets jnfp etc... i want to use all letters with all the posibilities is there a script that can do this ? (3 Replies)
Discussion started by: suppliernr1
3 Replies

10. Shell Programming and Scripting

Help text manipulation

Hello Forum , I need a help about text manupulation. I have a text file and I have to manipulate this file. Let's say source.txt source.txt UNB+UNOC:3+O0013000005MAN MN RVS:91+0098006688:92+190304:2313+F004169241' UNH+8146848+DELJIT:D:96A:UN' BGM+307:::JIS_SYNCRO_FIRM+2019030423234101+9'... (8 Replies)
Discussion started by: cemokam65
8 Replies

LEARN ABOUT OSX

datetime::locale::ml

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

NAME

       DateTime::Locale::ml

SYNOPSIS

	 use DateTime;

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

DESCRIPTION

       This is the DateTime locale package for Malayalam.

DATA

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

       It contains the following data.

   Days
       Wide (format)

	 XXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXX
	 XXXXXXXX

       Abbreviated (format)

	 XXXXXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX
	 XXX
	 XXXXXX

       Narrow (format)

	 XX
	 XX
	 XX
	 XXXX
	 XX
	 X
	 XX

       Wide (stand-alone)

	 XXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXX
	 XXXXXXXX

       Abbreviated (stand-alone)

	 XXXXXXXX
	 XXXXX
	 XXXXXX
	 XXXXXX
	 XXXXXX
	 XXX
	 XXXXXX

       Narrow (stand-alone)

	 XX
	 XX
	 XX
	 XXXX
	 XX
	 X
	 XX

   Months
       Wide (format)

	 XXXXXX
	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XXXXXXXX
	 XXXXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXX
	 XXXXXXXX

       Abbreviated (format)

	 XXX
	 XXXXXX
	 XXXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XX
	 XXXXXXXX
	 XXXXX
	 XXX
	 XXXX

       Narrow (format)

	 X
	 XX
	 XX
	 X
	 XX
	 XX
	 XX
	 X
	 XX
	 X
	 X
	 XX

       Wide (stand-alone)

	 XXXXXX
	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XXXXXXXX
	 XXXXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXX
	 XXXXXXXX

       Abbreviated (stand-alone)

	 XXX
	 XXXXXX
	 XXXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XXXX
	 XX
	 XXXXXXXX
	 XXXXX
	 XXX
	 XXXX

       Narrow (stand-alone)

	 X
	 XX
	 XX
	 X
	 XX
	 XX
	 XX
	 X
	 XX
	 X
	 X
	 XX

   Quarters
       Wide (format)

	 XXXXXX XXXX
	 XXXXXX XXXX
	 XXXXXXX XXXX
	 XXXXX XXXX

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 XXXXXX XXXX
	 XXXXXX XXXX
	 XXXXXXX XXXX
	 XXXXX XXXX

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 XXXXXXXXXXXXX XXXXXXX
	 XXXXXXXXXXXX XXXXXXX

       Abbreviated

	 XXXX.XX.
	 XXXX.XX.

       Narrow

	 XXXX.XX.
	 XXXX.XX.

   Date Formats
       Full

	  2008-02-05T18:30:30 = 2008, XXXXXXXXX 5, XXXXXXXXX
	  1995-12-22T09:05:02 = 1995, XXXXXXXX 22, XXXXXXXXXXX
	 -0010-09-15T04:44:23 = -10, XXXXXXXXXXXX 15, XXXXXXXX

       Long

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

       Medium

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

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

   Time Formats
       Full

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

       Long

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

       Medium

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

       Short

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

       Default

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

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = 2008, XXXXXXXXX 5, XXXXXXXXX 6:30:30 pm UTC
	  1995-12-22T09:05:02 = 1995, XXXXXXXX 22, XXXXXXXXXXX 9:05:02 am UTC
	 -0010-09-15T04:44:23 = -10, XXXXXXXXXXXX 15, XXXXXXXX 4:44:23 am UTC

       Long

	  2008-02-05T18:30:30 = 2008, XXXXXXXXX 5 6:30:30 pm UTC
	  1995-12-22T09:05:02 = 1995, XXXXXXXX 22 9:05:02 am UTC
	 -0010-09-15T04:44:23 = -10, XXXXXXXXXXXX 15 4:44:23 am UTC

       Medium

	  2008-02-05T18:30:30 = 2008, XXXXXX 5 6:30:30 pm
	  1995-12-22T09:05:02 = 1995, XXXX 22 9:05:02 am
	 -0010-09-15T04:44:23 = -10, XXXXXXXX 15 4:44:23 am

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 pm
	  1995-12-22T09:05:02 = 22/12/95 9:05 am
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 am

       Default

	  2008-02-05T18:30:30 = 2008, XXXXXX 5 6:30:30 pm
	  1995-12-22T09:05:02 = 1995, XXXX 22 9:05:02 am
	 -0010-09-15T04:44:23 = -10, XXXXXXXX 15 4:44:23 am

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

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

       M (L)

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

       Md (d/M)

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

       MEd (M/d, E)

	  2008-02-05T18:30:30 = 2/5, XXXXX
	  1995-12-22T09:05:02 = 12/22, XXXXXX
	 -0010-09-15T04:44:23 = 9/15, XXX

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

       MMMd (MMM d)

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

       MMMEd (MMM d, E)

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

       MMMMd (MMMM d)

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

       MMMMEd (MMMM d, E)

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

       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 (M-y)

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

       yMEd (d-M-yyyy, EEE)

	  2008-02-05T18:30:30 = 5-2-2008, XXXXX
	  1995-12-22T09:05:02 = 22-12-1995, XXXXXX
	 -0010-09-15T04:44:23 = 15-9--010, XXX

       yMMM (y MMM)

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

       yMMMEd (y MMM d, EEE)

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

       yMMMM (y MMMM)

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

       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 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       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 (MM-yyyy)

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

       yyyyMMMM (MMMM y)

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

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XXXXXXXXXX

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.16.2							    2013-08-25						   DateTime::Locale::ml(3)
All times are GMT -4. The time now is 04:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy