How to extract substrings from a string using regular expressions

[Yoichi]

Hi,

Can you try the following sample using Regex.Group?
This sample output not only each value but also excel table.

mc = System.Text.RegularExpressions.Regex.Matches(strData,"(?<=^|\n)(?<STATUS>.*?)\s+(?<DATE>\d+/\d+/\d+)\s+(?<ID>\d+)\s+(?<AMOUNT>\S+)\s+(?<NUMBER>\d+)\s+(?<NOTE>.*)")

Then we can access each value like m.Groups("DATE").Value

Sample
Sample20240128-1.zip (7.9 KB)

Regards,