Use index-function to show a negative number

[#1]

Hello,

i have a field that contains:

Hello -10 Temperature today

i use this functions to show the value -10. But it doesn't work:

mid(field,index(field,-10,),len(-10))

i tried this one, too: mid(field,index(field,'-'&10),len('-'&10)).

Can anyone help me please? Thanks!

[#2 · Accepted solution]

Hi,

try to include your pattern into single quotes like this:

mid(field,index(field,'-10',),len('-10'))

HtH

Roland

[#3]

Hi,

Try yhe keepchar  Function:

keepchar (fiekd,'-0123456789' )

Hoe thet ehat you want.