Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Mikael
2014-02-06T17:50:03Z
Hi. I'm trying to use RegEx.Match to extract ISINs in a text file. An ISIN is always a two-letter country code and a ten digit ID, so the regex is really simple:
\b[A-Z]{2}\d{10}\b

However trying to use {REGEX(Match|Test test AA1234567890 test test|\b[A-Z]{2}\d{10}\b)} only returns the function name again.

I'm guessing the function parser gets confused by the curly brackets used around the quantifiers, but I can't find any documentation on how to make VC only parse them in a regex context.
Sponsor
Forum information
Support
2014-02-06T22:43:32Z
I think the best way right now is to use the .NET code execute Task for matching your regex but we will take a closer look at the parser to see if we can make it better - for supporting stuff like this.

We will probably take a look next week. For now I am moving this request to "Feature requests" forum. If you have any questions about the .NET code task and how to accomplish this there then please let me know!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2014-02-12T08:33:37Z
Could you try the same with this version:

http://www.visualcron.co....aspx?g=posts&t=3805 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Mikael
2014-02-12T14:20:43Z
Hi, I installed and tried it with that version and it works as expected now.

{REGEX(Match|2014-01-30 00:00;SE0123456789_SEK;EXAMPLE COMPANY A;280214|\b[a-zA-Z]{2}[0-9]{10})}

returns "SE0123456789" as expected.

Thanks for your assistance.
Support
2014-02-14T13:24:21Z
Thanks for the feedback!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top