topic Difficult string extraction in Operating System - HP-UX

Difficult string extraction

SwissKnife — Wed, 08 Feb 2017 15:40:04 GMT

Hi,

Here the format of my filename

aaaaaaaaaaaaaaaaaaaaaaa.bbb.cccccccccccccc.gz

How to extract the 8 chars of the section just before .gz ?

Exemple:

SIEBER00_ora_38928476_1.aud.20170208163224.gz

=> 20170208

Any ideas ?

kind regards

Den.

Re: Difficult string extraction

Patrick Wallek — Wed, 08 Feb 2017 15:55:10 GMT

If everything is the same format, then something like this may work:

# export VAR1=SIEBER00_ora_38928476_1.aud.20170208163224.gz

# echo $VAR1
SIEBER00_ora_38928476_1.aud.20170208163224.gz

# echo $VAR1 | awk -F . '{print $3}' | cut -c 1-8
20170208

Re: Difficult string extraction

SwissKnife — Wed, 08 Feb 2017 16:21:08 GMT

Hi, thank you for your answer,

I should have give more details. I can't check but perhaps I could have more . in the filename.

I missed to precise this and of course with your solution it works if format stays the same.

Is there a way to consider as a good mark the .gz and take the string before ? or it's too complicated ?

Kind regards,

Den

Re: Difficult string extraction

PWallek — Wed, 08 Feb 2017 19:15:24 GMT

Try this. This will print the 2nd to last field (the one before the .gz and cut out columns 1-8:

# echo $VAR1 | awk -F . '{print $(NF-1)}' | cut -c 1-8
20170208

Re: Difficult string extraction

Steven Schweda — Wed, 08 Feb 2017 20:10:01 GMT

Or, if "sed" is your only friend:

pro3$ echo 'aaaa.aaa.bbb.c1c2c3c4c5c6c7.gz' | \
sed -e 's/^.*\.$[^.]*$\.gz$/\1/' -e 's/$........$.*/\1/'
c1c2c3c4

The first expression looks for any characters at the begininng {^.*},
a dot {\.}, any non-dot characters {[^.]*}, and ".gz" at the end
{\.gz$}, and keeps the non-dot characters between those dots (the last
dot before ".gz", and the dot in ".gz"). The second expression keeps
the first eight characters from that result.

Re: Difficult string extraction

SwissKnife — Thu, 09 Feb 2017 09:59:15 GMT

Hi,

perfect, thank you.

Kind regards, Den.

Re: Difficult string extraction

Dennis Handly — Sun, 12 Feb 2017 02:24:36 GMT

You can of course program in awk:

echo "SIEBER00_ora_38928476_1.aud.20170208163224.gz" | awk '{print substr($0, index($0, ".gz") - 8, 8)}'