|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merge lines into one
Post 302198302 by treasurar on Thursday 22nd of May 2008 02:53:49 PM
05-22-2008
Hello Frenkline for quick update
But when I try tr -d '\r' it removed my ^M but still keeps my line as follows
Special Olympics Missouri,None,Muller+Company,MULLE001,4498,MS-80124-58-SOMO-ME-US-Special Olympics Basketball - St Louis,,Marc Hale,C1-MS-IS,,45305,2/18/2008,3/9/2008,N/A,MySpace ROS Leaderboard (728x90) ,cpm,1.45,"434,483",0,0,0%,0,"4739 Belleview
Kansas City, KS 64112
United States
",Net 30,Bill on Delivery - 3rd Party,jsydnor,N/A,Associated Profile,N/A,0,0,0,0,N/A,0.00%,N,February 2008 - February 2008,"248,276",360,0,0,N/A,0,0%,0,,N/A,N/A,N/A,"16 - 18, 18 - 24",N/A,8,N/A,United States,St.Louis-609,N/A,N/A,Feb-08,2/29/2008,2/1/2008,USD,2/18/2008,3/9/2008,,,,3832,0,452,100%,,,FIM,MySpace Standard Terms,0,,,N/A,N/A,N/A,N/A
After Belleview, Kensas City is on new line and United States also new line
I want that merge into one line.
I tried tr -d '\r' and '\n' also but still no help
Thank you,
Cheer,
H
But when I try tr -d '\r' it removed my ^M but still keeps my line as follows
Special Olympics Missouri,None,Muller+Company,MULLE001,4498,MS-80124-58-SOMO-ME-US-Special Olympics Basketball - St Louis,,Marc Hale,C1-MS-IS,,45305,2/18/2008,3/9/2008,N/A,MySpace ROS Leaderboard (728x90) ,cpm,1.45,"434,483",0,0,0%,0,"4739 Belleview
Kansas City, KS 64112
United States
",Net 30,Bill on Delivery - 3rd Party,jsydnor,N/A,Associated Profile,N/A,0,0,0,0,N/A,0.00%,N,February 2008 - February 2008,"248,276",360,0,0,N/A,0,0%,0,,N/A,N/A,N/A,"16 - 18, 18 - 24",N/A,8,N/A,United States,St.Louis-609,N/A,N/A,Feb-08,2/29/2008,2/1/2008,USD,2/18/2008,3/9/2008,,,,3832,0,452,100%,,,FIM,MySpace Standard Terms,0,,,N/A,N/A,N/A,N/A
After Belleview, Kensas City is on new line and United States also new line
I want that merge into one line.
I tried tr -d '\r' and '\n' also but still no help
Thank you,
Cheer,
H
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I have two lines of data formatted as displayed below
shop, price, remark, date
a,#N/A,order to -fd, 20091011
and would like it to be
shop:a
price:#N/A
remark:order to -fd
date:20091011
How can I do it?
Many thanks (2 Replies)
Discussion started by: lalelle
2 Replies
2. Shell Programming and Scripting
Hi All,
I have a data in flat file like below. Some of the information are in second row.
111_ABCProcess ----- ----- IN 0/0
111_PQRTrimPRocess
----- ----- OI 0/0
111_ZigZagTrimProcess ----- ----- ... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
3. Shell Programming and Scripting
Hi people...
I normally find with out any problem the solutions I need just by searching. But for this I'm not having any joy or jsut failing to adapt what I'ev found to work.
I have applciation report that doesn't allow for manipulation at creation so I want to do some post modifcation... (2 Replies)
Discussion started by: nhatch
2 Replies
4. Shell Programming and Scripting
Hi guys
in input every 1st line 1st ID value located in 2nd line 1st occurrence .
I need to print them down accordingly..
Thanx in advance
input
rs1040480_XXXXX.value rs1040481_YYYYY.value rs1040482_TXXXX.value
0.7408157 0.3410044 0.7408157 ... (7 Replies)
Discussion started by: stateperl
7 Replies
5. UNIX for Dummies Questions & Answers
I have a file like this. Pls help me to solve this in ksh
(I should look for only Message : 111 and need to print the start time to end time
Need to ignore other type of messages. Ex: if first message is 111 and second message is 000 or anything else then ignore the 2nd one and print start time... (7 Replies)
Discussion started by: mnjx
7 Replies
6. Shell Programming and Scripting
Hi,
I am trying to merge two lines, first line starts with a particular pattern and second line ends with a particular pattern in a file.
Something like:
First line starts with say ABC
Second line ends with say XYZ
After a merge, the line should become ABC.......XYZ
I tried... (14 Replies)
Discussion started by: Sunny Arora
14 Replies
7. UNIX for Dummies Questions & Answers
Hi Experts,
This is my input file.
input.txt
0 /dev/fd
25 /var
1 /tmp
1 /var/run
1. If this file has single line, then leave it, print the single line
else
merge the 4 lines above into 1 line as below
e.g (6 Replies)
Discussion started by: streddy
6 Replies
8. Shell Programming and Scripting
Hi,
I'm not a expert in shell programming, so i've come here to take help from u gurus.
I'm trying to tailor a csv file that i got to make it work for the LOAD FROM command.
I've a datatable csv of the below format -
--in file format
xx,xx,xx ,xx , , , , ,,xx,
xxxx,, ,, xxx,... (11 Replies)
Discussion started by: dvah
11 Replies
9. Shell Programming and Scripting
Hello
I have a file with
CAR 23
COLOR 12
CAR 44
COLOR 12
CAR 55
COLOR 20
SIZE BIG
CAR 56
CAR 57
COLOR 11
How can merge the CAR and the COLOR + SIZE (if there are COLOR,SIZE)
CAR 23 COLOR 12
CAR 44 COLOR 12
CAR 55 COLOR 20 SIZE BIG
CAR 56
CAR 57 COLOR 11
Every line begin in... (4 Replies)
Discussion started by: sharong
4 Replies
10. Shell Programming and Scripting
Hello
I have an input as below
this is test
we
are(
)
one
end of description
I am looking for output
this is test
we are () one
end of description (2 Replies)
Discussion started by: Tomlight
2 Replies
LEARN ABOUT MOJAVE
datetime::locale::en_gb
DateTime::Locale::en_GB(3) User Contributed Perl Documentation DateTime::Locale::en_GB(3) NAME
DateTime::Locale::en_GB SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'en_GB' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for English United Kingdom. DATA
This locale inherits from the DateTime::Locale::en locale. It contains the following data. Days Wide (format) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Abbreviated (format) Mon Tue Wed Thu Fri Sat Sun Narrow (format) M T W T F S S Wide (stand-alone) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Abbreviated (stand-alone) Mon Tue Wed Thu Fri Sat Sun Narrow (stand-alone) M T W T F S S Months Wide (format) January February March April May June July August September October November December Abbreviated (format) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Narrow (format) J F M A M J J A S O N D Wide (stand-alone) January February March April May June July August September October November December Abbreviated (stand-alone) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Narrow (stand-alone) J F M A M J J A S O N D Quarters Wide (format) 1st quarter 2nd quarter 3rd quarter 4th quarter Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) 1st quarter 2nd quarter 3rd quarter 4th quarter Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide Before Christ Anno Domini Abbreviated BC AD Narrow B A Date Formats Full 2008-02-05T18:30:30 = Tuesday, 5 February 2008 1995-12-22T09:05:02 = Friday, 22 December 1995 -0010-09-15T04:44:23 = Saturday, 15 September -10 Long 2008-02-05T18:30:30 = 5 February 2008 1995-12-22T09:05:02 = 22 December 1995 -0010-09-15T04:44:23 = 15 September -10 Medium 2008-02-05T18:30:30 = 5 Feb 2008 1995-12-22T09:05:02 = 22 Dec 1995 -0010-09-15T04:44:23 = 15 Sep -10 Short 2008-02-05T18:30:30 = 05/02/2008 1995-12-22T09:05:02 = 22/12/1995 -0010-09-15T04:44:23 = 15/09/-010 Default 2008-02-05T18:30:30 = 5 Feb 2008 1995-12-22T09:05:02 = 22 Dec 1995 -0010-09-15T04:44:23 = 15 Sep -10 Time Formats Full 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Long 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Datetime Formats Full 2008-02-05T18:30:30 = Tuesday, 5 February 2008 18:30:30 UTC 1995-12-22T09:05:02 = Friday, 22 December 1995 09:05:02 UTC -0010-09-15T04:44:23 = Saturday, 15 September -10 04:44:23 UTC Long 2008-02-05T18:30:30 = 5 February 2008 18:30:30 UTC 1995-12-22T09:05:02 = 22 December 1995 09:05:02 UTC -0010-09-15T04:44:23 = 15 September -10 04:44:23 UTC Medium 2008-02-05T18:30:30 = 5 Feb 2008 18:30:30 1995-12-22T09:05:02 = 22 Dec 1995 09:05:02 -0010-09-15T04:44:23 = 15 Sep -10 04:44:23 Short 2008-02-05T18:30:30 = 05/02/2008 18:30 1995-12-22T09:05:02 = 22/12/1995 09:05 -0010-09-15T04:44:23 = 15/09/-010 04:44 Default 2008-02-05T18:30:30 = 5 Feb 2008 18:30:30 1995-12-22T09:05:02 = 22 Dec 1995 09:05:02 -0010-09-15T04:44:23 = 15 Sep -10 04:44:23 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 Tue 1995-12-22T09:05:02 = 22 Fri -0010-09-15T04:44:23 = 15 Sat 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 (E, d/M) 2008-02-05T18:30:30 = Tue, 5/2 1995-12-22T09:05:02 = Fri, 22/12 -0010-09-15T04:44:23 = Sat, 15/9 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 = Feb 1995-12-22T09:05:02 = Dec -0010-09-15T04:44:23 = Sep MMMd (MMM d) 2008-02-05T18:30:30 = Feb 5 1995-12-22T09:05:02 = Dec 22 -0010-09-15T04:44:23 = Sep 15 MMMEd (E d MMM) 2008-02-05T18:30:30 = Tue 5 Feb 1995-12-22T09:05:02 = Fri 22 Dec -0010-09-15T04:44:23 = Sat 15 Sep MMMMd (d MMMM) 2008-02-05T18:30:30 = 5 February 1995-12-22T09:05:02 = 22 December -0010-09-15T04:44:23 = 15 September MMMMEd (E, MMMM d) 2008-02-05T18:30:30 = Tue, February 5 1995-12-22T09:05:02 = Fri, December 22 -0010-09-15T04:44:23 = Sat, September 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 (M/yyyy) 2008-02-05T18:30:30 = 2/2008 1995-12-22T09:05:02 = 12/1995 -0010-09-15T04:44:23 = 9/-010 yMEd (EEE, d/M/yyyy) 2008-02-05T18:30:30 = Tue, 5/2/2008 1995-12-22T09:05:02 = Fri, 22/12/1995 -0010-09-15T04:44:23 = Sat, 15/9/-010 yMMM (MMM y) 2008-02-05T18:30:30 = Feb 2008 1995-12-22T09:05:02 = Dec 1995 -0010-09-15T04:44:23 = Sep -10 yMMMEd (EEE, MMM d, y) 2008-02-05T18:30:30 = Tue, Feb 5, 2008 1995-12-22T09:05:02 = Fri, Dec 22, 1995 -0010-09-15T04:44:23 = Sat, Sep 15, -10 yMMMM (MMMM y) 2008-02-05T18:30:30 = February 2008 1995-12-22T09:05:02 = December 1995 -0010-09-15T04:44:23 = September -10 yQ (Q yyyy) 2008-02-05T18:30:30 = 1 2008 1995-12-22T09:05:02 = 4 1995 -0010-09-15T04:44:23 = 3 -010 yQQQ (QQQ y) 2008-02-05T18:30:30 = Q1 2008 1995-12-22T09:05:02 = Q4 1995 -0010-09-15T04:44:23 = Q3 -10 yyMMM (MMM yy) 2008-02-05T18:30:30 = Feb 08 1995-12-22T09:05:02 = Dec 95 -0010-09-15T04:44:23 = Sep -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 = February 2008 1995-12-22T09:05:02 = December 1995 -0010-09-15T04:44:23 = September -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week Sunday 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::en_GB(3)