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)

Verified answer

André Arnaud de Cal... 302,639 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Verified answer

Blue Wang on at

Like (0)

Report
Copy link

Link copied!

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
Mohan_AX 106 on at

Like (0)

Report
Copy link

Link copied!

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
Martin Dráb 238,576 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

An alternative solution is using regular expressions.

Was this reply helpful? Yes No