Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
try to include your pattern into single quotes like this:
mid(field,index(field,'-10',),len('-10'))
HtH
Roland
Hi,
try to include your pattern into single quotes like this:
mid(field,index(field,'-10',),len('-10'))
HtH
Roland
Hi,
Try yhe keepchar Function:
keepchar (fiekd,'-0123456789' )
Hoe thet ehat you want.