Search an alpha field for a full stop
Posted: Fri Sep 15, 2023 4:00 am
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?
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?