topic need help on getting data in a file in Operating System - Linux

need help on getting data in a file

Patrice Blanchard_2 — Wed, 19 Apr 2006 08:39:01 GMT

Hi,

i have this script:

user=`whoami`
elist=`whoami`@mydomain.com
date_str=`date "+%m/%d/%y%H%M%S"`
subject="PDF file"
set -x
cat "$1" |tr -d `echo "\015"` > "$1""pdf"
echo "$2" "$1" "$3"
/baan4/c4/bse/starjet/starpage -s"$3" -c"$2" -d/tmp/$user.pdf -m:pdf "$1""pdf"
uuencode /tmp/$user.pdf $user$date_str.pdf | mailx -m -s "$subject" $elist

where user will get by email a pdf file named with this format mylogindatetime.pdf

script is working ok but here is the catch. I need to fetch invoice number stored in "$1""pdf" and use it has a the name of the file instead of the login date and time.

if i do a "grep Invoice" of the file i get:
"customer name Invoice N: 12345 SLS"

how can i fetch the 12345 SLS and put it in a variable so i can use it in the script?

I'm no expert on scripting so any help will be appreciated.

Regards

PB

Re: need help on getting data in a file

James R. Ferguson — Wed, 19 Apr 2006 08:51:45 GMT

Hi:

The use of a simple 'cut' will extract the fields you want:

# X="customer name Invoice N: 12345 SLS"
# Y=`echo ${X}|cut -d" " -f 5-6`
# echo ${Y}
12345 SLS

Regards!

...JRF...

Re: need help on getting data in a file

James R. Ferguson — Wed, 19 Apr 2006 08:54:41 GMT

Hi:

This is clearer, perhaps:

# VAR=`grep "Invoice" file|cut -d " " -f 5-6`

Regards!

...JRF...

Re: need help on getting data in a file

Peter Nikitka — Wed, 19 Apr 2006 09:35:22 GMT

Hi,

if the requested items are the last part of this line:

awk '/ Invoice / {print ($(NF-1),$NF);exit}' "$1"pdf | read num str

and use $num and $str for these values.

mfG Peter

Re: need help on getting data in a file

Patrice Blanchard_2 — Wed, 19 Apr 2006 10:30:01 GMT

Hi,

thanks for your help on this. Both info were good.

Regards

PB

Re: need help on getting data in a file

Arturo Galbiati — Thu, 20 Apr 2006 03:19:55 GMT