How to get the string between two strings in VBScript through regexp?

Asked Feb 24 '20 at 15:23

Active Feb 24 '20 at 15:35

Viewed 24 times

I have the sets of string that will always start with ?20 and end with ?30 or ?31 or ?32 and so on.

For example ?20needed_text?30 ?20needed_text?31 and so on...

I need to extract the needed text. It is necessary to stress that needed_text may contain any character including digits, letters, specific characters and etc.

Can anyone help with a proper regex?

I tried the following pattern but it does not work:

"\?20(.*?)\?3[0-9]"

this is my code. I get empty values in my echo...

set regex = new regexp  
regex.global = true
regex.pattern = "\?20(.*?)\?3[0-9]"
set payment_purposes = regex.execute(row)
for each payment_purpose in payment_purposes 
wscript.echo payment_purpose
next

Thank you.

edited Feb 24 '20 at 15:35

asked Feb 24 '20 at 15:23

Nikolay Oleynikov

Why doesn't it? It works perfectly. Grab `match.Submatch(0)` value. To get overlapping matches use `"\?20(.*?)(?=\?3[0-9])"` – Wiktor Stribiżew Feb 24 '20 at 15:24
And what is expected? See [this regex demo](https://regex101.com/r/hZ9ANB/1), there is a match between `?20` and the closest `?30`. (Just realized there can be no overlapping matches here, so `\?20(.*?)\?3[0-9]` should work as per the current requirements.) – Wiktor Stribiżew Feb 24 '20 at 15:28
set regex = new regexp regex.global = true regex.pattern = "\?20(.*?)(?=\?3[0-9])" set payment_purposes = regex.execute(row) for each payment_purpose in payment_purposes wscript.echo payment_purpose next – Nikolay Oleynikov Feb 24 '20 at 15:31
this is my code, echo is empty :( – Nikolay Oleynikov Feb 24 '20 at 15:31
1

Are you sure the `row` text is what you expect it to be? – Wiktor Stribiżew Feb 24 '20 at 15:36
yes, just checked it with echo – Nikolay Oleynikov Feb 24 '20 at 15:39
I get `EREF+362002378231140355?21SV wwrsstung U1/U2: 001/?2200ww/12321611/1 71.39` if I use `wscript.echo payment_purpose.SubMatches.Item(0)` (or `payment_purpose.SubMatches(0)`). How do you initialize `row`? Are you sure there are no linebreaks in between the start/end markers? – Wiktor Stribiżew Feb 24 '20 at 15:39
Are you sure there are no linebreaks in between the start/end markers? Try replacing `.` with `[\s\S]` – Wiktor Stribiżew Feb 24 '20 at 15:42
There are in some places linebreaks – Nikolay Oleynikov Feb 24 '20 at 15:43
1

So, again, [this is the answer](https://stackoverflow.com/a/45981809/3832970) – Wiktor Stribiżew Feb 24 '20 at 15:44

How to get the string between two strings in VBScript through regexp?

0 Answers0