insert calculation to search will not accomplish goal

[curious99]

Hi,

I have a text field from which I want to extract the last 4 letters. I want to use these letters and insert them into a field during a scripted search.

Here is my script:

enter find mode (pause)

go to field ( annuaire:# tel)

insert calculated result ( select; annuaire::#tel;right ( annuaire::#tel bur;4))

perform find()

The reason for my post is obviously because it does not work. Where am I failing?

Cheers

[bruceR]

Hi,

I have a text field from which I want to extract the last 4 letters. I want to use these letters and insert them into a field during a scripted search.

Here is my script:

enter find mode (pause)

go to field ( annuaire:# tel)

insert calculated result ( select; annuaire::#tel;right ( annuaire::#tel bur;4))

perform find()

The reason for my post is obviously because it does not work. Where am I failing?

Cheers

You're in find mode. There is no data to insert.

Instead:

set Variable [ $temp; right ( annuaire::#tel bur;4) ]

enter find mode (no pause)

set field ( annuaire::# tel; $temp)

perform find()

[curious99]

Thanks Bruce,

Your suggestion worked like a charm.

I was not aware of that $temp variable. That will be very usefull for me as it must also be for you.

Happy New Year to you and whoever your care a lot for.

Cheers!

[bruceR]

Thanks Bruce,

Your suggestion worked like a charm.

I was not aware of that $temp variable. That will be very usefull for me as it must also be for you.

Happy New Year to you and whoever your care a lot for.

Cheers!

Read up some more about variables, both $ and $$ types.

$temp is an arbitrary name I chose, you can have many different variables in operation in scripts and calculations, file export, etc.