Small and medium business | Business Central, N...

Extracting groups with Regex pattern

(2) Share

Report

Posted on by ibogovic

Greetings,

I'm trying to figure out how Regex codeunit works in Business Central.

For example, lets say I have a Regex expression /(.*)/(.*)/(.*)/ and a text /Test123/Test456/Test789/.

How can I extract the values:

- Test123

- Test456

- Test789

I tried using the /Regex.Match(..)/ procedure, but it only extracts the whole value /Test123/Test456/Test789/ instead of separating it:

I'm a complete beginner in using the Regex, but according to the /regex101.com/, this should work. I'm not sure what am I missing here (unfortunately, there are not many examples on how to use Regex for BC):

My guess is that I need to use /Regex.Group(....)/ method, but I didn't figure out how to do it yet.

Can someone please help me to achieve this?

Thank you.

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 78,900 Super User 2025 Season 1 on at

Like (0)

Report

Extracting groups with Regex pattern

Hi, there is a simple example about Text.Split(List of [Text]) Method in the following post, I hope it can give you some tips.

https://yzhums.com/9273/

Thanks.

ZHU
gdrenteria 15,506 Most Valuable Professional on at

Like (0)

Report

Extracting groups with Regex pattern

Hi

Maybe this can help you

https://www.beyondit.gmbh/post/split-multiline-text-into-records

BR

GR
Suggested answer

Mohamed Amine Mahmoudi 17,181 Super User 2025 Season 1 on at

Like (0)

Report
Extracting groups with Regex pattern

Hi,

In your case you must use the function split to extract the values

e.g.

Values := YourText.Split('/');

Best regards,

Mohamed Amine MAHMOUDI