Reading specific text from a string using X++ functions

(0) Share

Report

Posted on by Mohan_AX

106

Dear AX Experts,

Can someone please share an idea on how to read specific text from a string ? example as below

Example String = "thisisPIV567898invoicenumber"

Required output text = PIV567898

Note: The position of text can be changed, irrespective of the position, I need to read first instance of text starting with "PIV" followed by 6 digits

More examples of string as below

"PIV984567secondinvoiceexample"

"/inv/PIV056342/zvest"

"Z&X MAN FOREST INVPIV052514, PIV060148 PIV062270 " ( in this scenario output should be PIV052514).

Please help, thanks in Advance

I have the same question (0)

All responses (4)

Answers (2)

Martin Dráb 236,270 Most Valuable Professional on at

Like (1)

Report

RE: Reading specific text from a string using X++ functions

An alternative solution is using regular expressions.

Was this reply helpful? Yes No
Mohan_AX 106 on at

Like (0)

Report

RE: Reading specific text from a string using X++ functions

Thank you very much Andre and Blue Wang.

It worked well and I got the required output.

Thanks

Mohan

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

RE: Reading specific text from a string using X++ functions

Hi Mohan,

Please use the method suggested by Andre, the simple example is as follows:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-string-run-time-functions#strscan

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,959 Super User 2025 Season 2 on at

Like (0)

Report

RE: Reading specific text from a string using X++ functions

Hi Mohan,

Using the strScan() function, you can determine the position of the text PIV. Then you can use the subStr() command to read from the start of PIV until the end of the 6 numbers.

Was this reply helpful? Yes No