range a..b : extraxt a and b

Finance and Operations/AX Developer Forum
1

Hello, Does anyone know how to extract the first and last item from a range entered through the query of a report, f.i. itemid : xx.xx.xxxx…yy.yy.yyyy Range(fieldnum(table,tablefield)).value() == xx.xx.xxxx…yy.yy.yyyy Can I extract the numbers xx.xx.xxxx and yy.yy.yyyy from the range or am I obligated to use substrings? thx in advance, Kathleen

2

Hi To my knowledge, there is no parser available, so you’ll have to use string commands.

3

What are the string commands that are available for parsing? Are there some commands like SubString? For extracting a string from another? And something like StrPos for determining position of one string within the other?

4

Hi Bojan, You can see the list of functions at AOT → System Documentation → Functions. Take a look at functions prefixed with “str”… and yes… there is a subStr function as well. Cheers

5

10x Chee Kang, I have also found some of them under AOT->Classes->Global. They have worked ok.