topic Re: hp textfile adding index in Operating System - HP-UX

hp textfile adding index

Ferdi Castro — Fri, 03 Mar 2006 02:16:56 GMT

Hi Everyone,

Can you help me here.
I have a file having contents below
asdf
qwer
asff
and i want to add an index prompting what control number will I start so if i say 1 it will change output to

asdf 1
qwer 2
asff 3

so if i say start number is 125 it will have output like

asdf 125
qwer 126
asff 127

so that it automatically increases by one for each entry. I will be glad if you can help me using this with awk. thanks much.

Re: hp textfile adding index

Indira Aramandla — Fri, 03 Mar 2006 02:41:21 GMT

Hi Ferdi,

Try this

cat file.text |awk '{print $1 " " a+1; a++}'
asf 1
bfc 2
edr 3
wes 4

cat file.text |awk '{print $1 " " a+120; a++}'

asf 120
bfc 121
edr 122
wes 123

Indira A

Re: hp textfile adding index

Frank de Vries — Fri, 03 Mar 2006 02:44:57 GMT

With awk would be nice,
but a quick solution would be something like this:

#/sbin/sh
# script with passing parameter
typeset -i VAR
VAR=$1
cat yourfile |while read LINE
do
print "$LINE $VAR"
VAR=(($VAR + 1))
done

For a prompt you can add a read VAR

#/sbin/sh
# script with prompt

print "Type your control nr. here:\n"
typeset -i VAR
read VAR

cat yourfile |while read LINE
do
print "$LINE $VAR"
VAR=(($VAR + 1))
done

Many variations are possible,
but is the basic skeleton.

Re: hp textfile adding index

Ferdi Castro — Fri, 03 Mar 2006 03:00:40 GMT

Thanks Indira. I find your solution better however I need it it to be prompted in a script
I tried ff same but it give me error?

echo "enter start index \c"
read index

cat file | awk '{print $1 | $index+1;$index++}'

returns an error

awk: Field $() is not correct.
The input line number is 1.
The source line number is 1.

pls help

gives an error. Im pretty sure Im close its just that I need to get the clear use of variable.

Re: hp textfile adding index

Steve Steel — Fri, 03 Mar 2006 04:08:31 GMT

Hi

echo "enter start index \c"
read index
cat $file |awk -v a=$index '{print $1 " " a; a++}'

Steve Steel

Re: hp textfile adding index

Indira Aramandla — Fri, 03 Mar 2006 04:08:48 GMT

Hi Ferdi,

awk dies not understand the $varibale as it is form the shell. May be use awk -v

I think if you need to be prompted for the index number then do as a script.

IA

Re: hp textfile adding index

Arturo Galbiati — Mon, 06 Mar 2006 04:23:57 GMT

hi,
using awk only (not cat is needed):

read b?"Start index "
awk 'BEGIN {B='''$b'''};{print $0 " " B++}' file

code in the BEGIN step assign to the AWK var B teh value of UNIX var b.
Rest of te code print the record in teh file plus the counter.

HTH,
Art