truncate help

munna_dude · 10-17-2007, 06:47 AM

hi all
i have a text like this

Quote:

AAAAA GGGGGG 25OC200 - - 5389.80 5203.10 5673.15 5255.00 89085 234115.83 5143.90 AAAAA GGGGGG 29NO2007 - - 5389.00 5211.00 5674.00 5269.95 5265 13869.14 5143.90 BBBBBB GGGGGG 25OC200 CE 5600.00 74.00 15.00 168.60 34.05 810 2281.01 5143.90 AAAAA GGGGGG 27DE200 - - 5410.00 5125.00 5664.05 5265.00 694 1828.64 5143.90

i wanna output like this

Quote:

AAAAA GGGGGG 25OC200 - - 5389.80 5203.10 5673.15 5255.00 89085 234115.83 5143.90
AAAAA GGGGGG 29NO2007 - - 5389.00 5211.00 5674.00 5269.95 5265 13869.14 5143.90
BBBBBB GGGGGG 25OC200 CE 5600.00 74.00 15.00 168.60 34.05 810 2281.01 5143.90
AAAAA GGGGGG 27DE200 - - 5410.00 5125.00 5664.05 5265.00 694 1828.64 5143.90

line by line

is there any script to do like this

please help me

thank you in advance

acid_kewpie · 10-17-2007, 07:07 AM

there are plenty of ways to do this, but you need to define exactly what is differentiating one line from another. two numbers followed by a space and then 5 letters? a quick test gives a sed regex like this...

sed 's/\.\([0-9]*\)\ \([A-Z]\)/\.\1\n\2/g'

for example.

radoulov · 10-17-2007, 07:15 AM

Code:

 awk --re-interval '$0=$0RT' RS=" ([[:digit:].]* ){7,8}" filename

jschiwal · 10-17-2007, 07:17 AM

It would work better using a code block in your example. Using a quote block will squeeze spaces and insert newline characters.

munna_dude · 10-18-2007, 07:03 AM

hi all
i have a text file like this

Quote:

AAAAA GGGGGG 25OC200 - - 5389.80 5203.10
5673.15 5255.00 89085 234115.83 5143.9
AAAAA GGGGGG 29NO2007 - - 5389.00 5211.00 5674.00 5269.95 5265
13869.14 5143.90
BBBBBB GGGGGG 25OC200 CE 5600.00 74.00 15.00
168.60 34.05 810 2281.01 5143.90
AAAAA GGGGGG 27DE200 - - 5410.00 5125.00 5664.05 5265.00 694 1828.64
5143.90

i wanna output like this

Quote:

AAAAA GGGGGG 25OC200 - - 5389.80 5203.10 5673.15 5255.00 89085 234115.83 5143.90
AAAAA GGGGGG 29NO2007 - - 5389.00 5211.00 5674.00 5269.95 5265 13869.14 5143.90
BBBBBB GGGGGG 25OC200 CE 5600.00 74.00 15.00 168.60 34.05 810 2281.01 5143.90
AAAAA GGGGGG 27DE200 - - 5410.00 5125.00 5664.05 5265.00 694 1828.64 5143.90

please help me

thank you in advance

acid_kewpie · 10-18-2007, 08:17 AM

you've already given us example text... you;'re just ignoring all the useful information you've already been given and starting again? I thought there was a reason i shouldn't have answered....

munna_dude · 10-18-2007, 08:24 AM

Quote:

Originally Posted by acid_kewpie

you've already given us example text... you;'re just ignoring all the useful information you've already been given and starting again? I thought there was a reason i shouldn't have answered....

sorry
if that command used in c program with popen the output printing like that..
so that i asked the querry again

please help me

thank you in advance

jschiwal · 10-18-2007, 05:51 PM

I didn't realize that the data was actually all on one line until just after I posted my response.

I like the posted solution. It took me a while to see how it worked because I was thinking the regex was like [[:digit:].]{7,8} instead.

Code:

awk --re-interval '$0=$0RT' RS=" ([[:digit:].]* ){7,8}" filename

angrybanana · 10-18-2007, 09:24 PM

This does it based on there always being 12 fields (both your examples seem to indicate this).

Code:

$ cat file
AAAAA GGGGGG 25OC200 - - 5389.80 5203.10
5673.15 5255.00 89085 234115.83 5143.9
AAAAA GGGGGG 29NO2007 - - 5389.00 5211.00 5674.00 5269.95 5265
13869.14 5143.90
BBBBBB GGGGGG 25OC200 CE 5600.00 74.00 15.00
168.60 34.05 810 2281.01 5143.90
AAAAA GGGGGG 27DE200 - - 5410.00 5125.00 5664.05 5265.00 694 1828.64
5143.90

Code:

$ perl -0e '$_=<>;s/\n/ /g;for(split){$i++;($i%12 ? print "$_ " : print "$_\n")}' file
AAAAA GGGGGG 25OC200 - - 5389.80 5203.10 5673.15 5255.00 89085 234115.83 5143.9
AAAAA GGGGGG 29NO2007 - - 5389.00 5211.00 5674.00 5269.95 5265 13869.14 5143.90
BBBBBB GGGGGG 25OC200 CE 5600.00 74.00 15.00 168.60 34.05 810 2281.01 5143.90
AAAAA GGGGGG 27DE200 - - 5410.00 5125.00 5664.05 5265.00 694 1828.64 5143.90