topic Re: Cheap points for script gurus !! ;p in Operating System - HP-UX

Cheap points for script gurus !! ;p

kent friberg — Mon, 10 Sep 2001 16:51:30 GMT

Hey gurus,

I have a file that I know will contain these values at a FIXED position:

T200
R200

I want to split this one file into two separate files. One file containing the T200's and one file containing the R200's.

Now, this would be a piece of cake had it not been for the fact that T200 could also appear on "R200-lines" and vice versa. The only thing that will help me is the fact that the T200's and R200's do infact come atleast once and in the exact same spot each time.

Examples:

FileA without problem:
sometextT200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo
sometextT200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo

FileB with problem:
sometextT200sometextheretoo
sometextR200sometextherT200
sometextR200sometextheretoo
sometextT200sometextherR200
sometextR200sometextheretoo
sometextR200sometextheretoo

see my problem ?

Please help !!??

Re: Cheap points for script gurus !! ;p

Patrick Wallek — Mon, 10 Sep 2001 17:02:20 GMT

Can you show us an example of the output you expect in both cases? I am confused about the format of the output file that you want.

Re: Cheap points for script gurus !! ;p

A. Clay Stephenson — Thu, 04 Jul 2024 06:21:56 GMT

Hi Kent:

Attached is a shell script which calls awk. You will need to adjust the shell variable "OFFSET" to match the fixed location of your data.

Clay

Re: Cheap points for script gurus !! ;p

kent friberg — Mon, 10 Sep 2001 17:13:10 GMT

ahhh.yes..

OriginalFileA without problem:
sometextT200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo
sometextT200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo

I want to be split into two files like this:

File1
sometextT200sometextheretoo
sometextT200sometextheretoo

File2
sometextR200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo

(and same with)
OriginalFileB with problem:
sometextT200sometextheretoo
sometextR200sometextherT200
sometextR200sometextheretoo
sometextT200sometextherR200
sometextR200sometextheretoo
sometextR200sometextheretoo

I want split into:

File1:
sometextT200sometextheretoo
sometextT200sometextherR200

File2:
sometextR200sometextherT200
sometextR200sometextheretoo
sometextR200sometextheretoo
sometextR200sometextheretoo

Hope this was not too fuzzy .. ?:-\

Re: Cheap points for script gurus !! ;p

A. Clay Stephenson — Mon, 10 Sep 2001 17:13:33 GMT

Hi Kent:
Oops wrong one, this should do it.

Attached is a shell script which calls awk. You will need to adjust the shell variable "OFFSET" to match the fixed location of your data.

Clay

Re: Cheap points for script gurus !! ;p

Sridhar Bhaskarla — Mon, 10 Sep 2001 17:14:35 GMT

OK Kent,

I am not a guru but will try to help. This is really dependent on what your fixed position is. If you can show us the exact files, it may be easy to figure out.

If we just take the example you gave, i would do this way.

For ex., if you have the text like this
sometextT200sometextR200
sometextT200sometextT200
sometextR200sometextT200

If I want to get all T200 lines I would do

grep "^sometextT200" file > t200.stuff

If there is anything that is before the fixed position, then you can use that string in your grep command.

If it is a fixed field, you can use awk to match that field and print the line.

It's just dependent on what you have in the file.

-Sri

Re: Cheap points for script gurus !! ;p

Patrick Wallek — Mon, 10 Sep 2001 17:18:24 GMT

This may be simplistic, but what about grep?

grep T200 file1 >> T200.out
grep R200 file1 >> R200.out

That will pick up all occurrences of T200 and R200 in the file.

Re: Cheap points for script gurus !! ;p

Santosh Nair_1 — Mon, 10 Sep 2001 17:20:00 GMT

This may seem cheesy but how about something like this

grep "^........R200.*" testfile

where you pad out the dots till the first occurance of R200 (the dot, '.', represents any character). You could do the same for T200. Not the most elegant solution, but it works.

-Santosh

Re: Cheap points for script gurus !! ;p

Alan Riggs — Mon, 10 Sep 2001 17:30:13 GMT

Clay's solution should work, though I personally would have included the output to each file within the awk program. Under the header of "there's always another way", how about using basic shell commands.

while read LINE
do
KEY=$(echo $LINE |cut -c 0-12)
case $KEY in
T200)
echo $LINE >> file1
;;
R200)
echo $LINE >> file2
*)
;;
esac
done < infile

If you know that every line MUST have either R200 or T200 in the key position, drop the case and just use an if..then..else

Re: Cheap points for script gurus !! ;p

Duane Gorder — Mon, 10 Sep 2001 17:37:11 GMT

You already have lots of answers, but here is another one attached to this reply.

Re: Cheap points for script gurus !! ;p

linuxfan — Mon, 10 Sep 2001 18:25:48 GMT

Hi Kent,

I was about to send in the reply when i saw Alan's reply which was almost what i was submitting anyway.

I only had a small modification to that , since you already know the exact location, you want to use
cut -c 9-12 for the example you gave.
where 9 is the beginning and 12 is the end. (man cut for more information)

-Ramesh

Re: Cheap points for script gurus !! ;p

Satish Y — Mon, 10 Sep 2001 18:42:59 GMT

Hi Kent,

I agree with both Patrick and Sridhar's solutions, they r simple and good. I don't think u need to go for spl scripts for that.

Cheers...
Satish.

Re: Cheap points for script gurus !! ;p

Wodisch — Mon, 10 Sep 2001 19:42:37 GMT

Hello Kent,

Santosh's answer is almost perfect, the only
improvement I can see is the omit ".*" at the
end of his pattern - it is not needed there.

Just my ?0.02,
Wodisch (I am european, but that should be about $0.02)

Re: Cheap points for script gurus !! ;p

Stefan Schulz — Tue, 11 Sep 2001 05:38:41 GMT

Hi Kent,

i would use no awk or perl, just a little bit grep:

grep "^........T200" >> t200.txt
grep "^........R200" >> r200.txt

Put in as many dots as you need as a placeholder for your fixed length Text befor your T200/R200 string. This grep says: grep every line starting with 8 characters of any type and the string T200. And don't care whats behind.

This is not a impressing solution, but it is working and really fast.

Hope this helps

Regards Stefan

Re: Cheap points for script gurus !! ;p

Andreas Voss — Tue, 11 Sep 2001 06:04:52 GMT

Hi,

here my solution:

#!/bin/sh

:>File1
:>File2

awk '{
t=index($0, "T200")
r=index($0, "R200")
if(t>0)
{
if((r>0 && t print $0 >>"File1";
else
print $0 >>"File2";
}
else if(r>0)
{
if((t>0 && r print $0 >>"File2";
else
print $0 >>"File1";

}
}' File

Regards

Re: Cheap points for script gurus !! ;p

kent friberg — Wed, 12 Sep 2001 12:54:29 GMT

Huge thanks guys,

I hope I've given everyone points now.

ohh..btw:

grep "^........T200"

did the trick...

..there's som much to learn..

;)