Search an alpha field for a full stop

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
LansaHelp
Posts: 9
Joined: Fri May 20, 2022 11:23 pm

Search an alpha field for a full stop

Post by LansaHelp »

Hi Guys,

I am looking to search an alpha field for the occurrence of a full stop (decimal point) character.

e.g. if the alpha field contains the value 'The amount is 123.45' then I'd like the search to return a Y. I have been looking to use SCANSTRING for this (I cannot use RDMLX). Any tips on how to make this work?
LansaHelp
Posts: 9
Joined: Fri May 20, 2022 11:23 pm

Re: Search an alpha field for a full stop

Post by LansaHelp »

Scanstring works just fine:
Use Builtin(SCANSTRING) With_Args(#MYTEXT #CHECKS) To_Get(#STD_NUM)
Post Reply