[solved] $Regext() for multiple numbers

[ThomasM]

Hi there,

here is another one.

I have a .TXT-File only containing one line: TAG:timecode=02:12:34:23
I want to populate a Variable using $regext($read("%s_original_path%\Timecode.TAG"),"(\d+)") in populate variables node, but it only gives me the first two digits (in this case 02).

How can I retrieve all eight numbers for a string looking like 02123423 ?

Thanks in advance,

thomas

[emcodem]

Hi Thomas!

"\d+" means "the first number in the string plus any following number" - it does not work for your case because ":" is not a number.

The following means: "start from = and take everything up to the line end ($)"

Code: Select all

=(.+?)$

Notice that the parenthesis () are for defining that we do not want to include the = Symbol itself.

A common Special tipp: in regex i mostly use this sequence "START(.+?)END"... it means match anything between... E.g. for XML parsing:

Code: Select all

<tag>(.+?)</tag>

cheers!

[momocampo]

Hello Thomas,
Well, emcodem was, as usual, quicker as I but you can also do with "classic" populate variable like this :

populate.JPG (46.9 KiB) Viewed 8230 times

You will obtain only your number.

Cheers.

Benjamin

[janciev]

Hi,

please try

Code: Select all

 [^\d]

It works here.

Cheers,
Igor

[emcodem]

please try

Code: Select all

 [^\d]

Take care, the "^" (when used in brackets) means do NOT match (otherwise it means start of line), so this regex means do not match numbers.

Sorry i did not see that the ":" should not be included in the result. This should do it:

Code: Select all

(\d+):(\d+):(\d+):(\d+)

cheers!
emcodem

[janciev]

Hi,

indeed that was inverted logic! Thanks for correcting!

Igor

[ThomasM]

Hi all,

thank you for your help - helps here in the archive a lot reading out log-files.

@emcodem,
works***per***fect***ly. Thank you!

@Momocampo
Nice idea. I will have a look at these functions. Thanks!

@Jnaciev,
yeah - I tried that also and broke. But anyway - Thank you too!

all the best,
tom