topic Re: Cut column in Operating System - HP-UX

Cut column

heaman1 — Thu, 15 Jan 2009 07:30:28 GMT

I have a file , there are many lines , the content is as below .

p.s. the "------" is space

aaaaaa ------------------ testing1 ----------------- bbbb
aaaaa -----------------testing2 ----------bbbba
aaaaaaaaa ---------------testing3 -------------------------------------------- bbbd
aaaa -----------------testing4--bbbb
"
"

I would like to have a script to cut the content in the file to get the result , my desired result is as below

testing1
testing2
testing3
testing4
"
"

the condition to cut the content is
1. cut the content from the column 10 of each line
2. each line must be ended with a word that begins with bbb , so cut the content until bbb
3. erase all space ( -------- ) , then get the below result

testing1
testing2
testing3
testing4
"
"

Could advise the script ? thx in advance.

Re: Cut column

john123 — Thu, 15 Jan 2009 07:57:29 GMT

try awk '{print $2}' filename

Re: Cut column

heaman1 — Thu, 15 Jan 2009 07:58:39 GMT

Sorry , I have an adjustment , what I want now is only do the first line of the file ( instead of cut the content of each line ) , so the result should be "testing1" .

Thx

Re: Cut column

Venkatesh BL — Thu, 15 Jan 2009 08:10:01 GMT

awk '{print $2}' |head -1

Re: Cut column

heaman1 — Thu, 15 Jan 2009 08:42:58 GMT

thx reply ,

awk '{print $2}' |head -1

the above script is simple , but in my case , the words "testing1" is only example , in real case , it is a string that have space in it ( not just a word ) , so if I want to cut the culumn from column 2 to second last 2 column , what can i do ? thx

Re: Cut column

Steven Schweda — Thu, 15 Jan 2009 09:51:09 GMT

> the condition [...] is [...]

> Sorry , I have an adjustment, [...]

> [...] in real case [...]

Come back when you know what you want?

I'm not sure that the problem is well
specified, but something like the following
might be close to what you seek.

bash$ echo 'aaaaaa test ing 1 bbbb' | \
> sed -e 's/^.......... *//' -e 's/ *bbb[^ ]*$//'
test ing 1

The idea was to remove the first ten
characters ("^..........") plus any string
of spaces (" *"), and then to remove the
spaces leading up to "bbb" (" *bbb") and any
non-space characters between it and the end
of the line ("[^ ]*$").

(As I always say, "If you can't so it with
'sed', it's not worth doing.")

If you want only one line, "man head".

Re: Cut column

heaman1 — Thu, 15 Jan 2009 10:33:39 GMT

Sorry , please ignore the my pervious message first , I think cut column 2 ( awk '{print $2}' |head -1 ) is not work for my case .

I would like to carify my requirement as below .

the file content
==========
aaaaaa ------------------ testing1 ----------------- bbbb

step 1
====
check if the line contain the word "test" , if not , then output the result "Do nothing" .

if have , then do step 2 .

step 2
====
cut the column from column 10 to last 10 column

so the result is

--------------- testing1 ------------

step 3
====
erase all space that in front of and in rear of the string "testing1" .

so the result is

testing

Re: Cut column

Steven Schweda — Thu, 15 Jan 2009 17:29:57 GMT

> Sorry , please ignore [...]

Will do. You're not paying enough to get
me to chase your ever-changing requirements.
I've provided a "sed" example which does
much of what you want (even now). If you
can't find someone to write your script for
you, perhaps you should try to study that
example, and adapt it to your (latest) needs.

Re: Cut column

heaman1 — Fri, 16 Jan 2009 01:13:10 GMT

thx reply ,

the my last message would be my final requirement ( sorry to change requirement as I get something confused ) , I will change it again.

I tried sed -e 's/^.......... *//' -e 's/ *bbb[^ ]*$//'

the result is
--------------- testing1 -----------------

if I want to cut column as the my message , could advise what can i do ? thx

Re: Cut column

Steven Schweda — Fri, 16 Jan 2009 05:28:09 GMT

> I tried sed -e 's/^.......... *//' -e 's/ *bbb[^ ]*$//'
>
> the result is
> --------------- testing1 -----------------

I don't see how it could be. As I showed
before, I don't get those spaces.

Now, if they were tabs and not spaces, that
could change things. Of course, I can't see
what's really in your file, and there's no
reason to believe that you know what's in
there, either, and my psychic powers are too
weak to tell me, so I don't see what more I
can do.

Re: Cut column

Dennis Handly — Fri, 16 Jan 2009 05:54:12 GMT

Please attach a file or explain better what you want to do. Specify the exact columns you want to extract and in your attachment provide the result.

>from column 10 to last 10 column

I'm not sure what "to last 10 column" means?

Re: Cut column

heaman1 — Fri, 16 Jan 2009 07:02:46 GMT

thx dennis ,

sorry to confused you , I attached a file , could please provide advise ? if still not clear , please point it out , I will explain more detail .

thx

Re: Cut column

Dennis Handly — Fri, 16 Jan 2009 08:58:54 GMT

>I attached a file, could please provide advise?
>that mean erase the character that from column 1 to 10 and from column 60 to 70

I assumed you wanted to just keep columns 11 to 60. And only wanted to remove the 10 columns from 61 to 70.

awk '
BEGIN {
getline
if ($0 ~ /aaaa/) {
str = substr($0, 11, 61-11)
# print str
sub("^ *", "", str) # strip leading spaces
# print str
sub(" *$", "", str) # strip trailing spaces
print str
} else {
print "Do nothing"
}
exit
} ' file

Re: Cut column

heaman1 — Fri, 16 Jan 2009 09:19:25 GMT

it works for almost all the requirement ,

but what I hope to do is not to cut the column from column 60 to 70 , what I want is to cut the last ten column ( in the example , 60 -70 is last ten column , in real case , the length of the line is variable ) , could advise how to change it ? thx

Re: Cut column

Venkatesh BL — Fri, 16 Jan 2009 09:23:49 GMT

Looks like you are expecting others to do your job! :)

I would urge you to appreciate the folks who've helped you thus far, by assigning points. Refer to http://forums11.itrc.hp.com/service/forums/helptips.do?#28

Re: Cut column

Dennis Handly — Fri, 16 Jan 2009 10:04:51 GMT

>what I want is to cut the last ten column

Why didn't you say exactly that. You said "to last 10 column", which (to) doesn't go together.

>(60 - 70 is last ten column

No your edge arithmetic is wrong, last 11 columns.

>could advise how to change it?

Trivial:
str = substr($0, 11, length($0)-2*10)

Re: Cut column

heaman1 — Wed, 21 Jan 2009 03:08:14 GMT

thx reply ,

It run perfectly .
I still have one more question , the str is the result of the script , but it only output the result in the loop , can advise how to make the str result as a variable of the script ? like the below , I added echo $str at the end of it ( after exit ) , how to let it output the result of str ? thx

awk '
BEGIN {
getline
if ($0 ~ /aaaa/) {
str = substr($0, 11, 61-11)
# print str
sub("^ *", "", str) # strip leading spaces
# print str
sub(" *$", "", str) # strip trailing spaces
print str
} else {
print "Do nothing"
}
exit
} ' file

echo $str

Re: Cut column

Dennis Handly — Wed, 21 Jan 2009 03:55:05 GMT

>can advise how to make the str result as a variable of the script?

It might be better to use Steven's sed solution.

>how to let it output the result of str?

You wrap it in $():
str=$(awk '
BEGIN {
getline
if ($0 ~ /aaaa/) {
str = substr($0, 11, length($0)-2*10)
sub("^ *", "", str) # strip leading spaces
sub(" *$", "", str) # strip trailing spaces
print str
} else {
print "Do nothing"
}
exit
} ' file)

If our answers were helpful, please read the following about assigning points:
http://forums.itrc.hp.com/service/forums/helptips.do?#33

.. assigned points to 0 of 56 responses
http://forums.itrc.hp.com/service/forums/pageList.do?userId=WW165205&listType=unassigned&forumId=1

If you don't assign points, you run the risk of being struck off.