"Regular Expression for my output"

[suresz449]

Hi Folks,

while I run my script I am getting output like as Test_9UP_ab_UNIT.
In my output the value 9 and ab are changing dynamically so, please can any one give me the regular expression for the above string.




Thanks and Regards,
Suresh D

[ravi.gajul]

Assuming UP is always preceeded by a anumber between 0-9 and _Unit preceded by two characters
Test_[0-9]UP_[a-z][a-z]_UNIT

if this doesn't help
try
Test.*

[suresz449]

Hi Ravi,

You are giving regular expression for 9 and ab but in my output sometimes the value may be 10,11,...... and ab,abc,abcd,azfdg,....... etc.these values are changing dynamically so, please provide the regular expression for given string.

[ravi.gajul]

Well then .....Test.*...... should have helped.

[Ankesh]

Hi Sures,

Can you try this..

Code:

strText="Test_101UP_abcde_UNIT" Set RegEx = CreateObject("VBScript.RegExp")

'The below is the patter which can be used in your case
'\d{1,} - means any digit which will occur atleast once and may appear n times
'[a-z]{2,} - any two digit character to n length characted
'$ - indicates the end of the string

Code:

RegEx.Pattern ="^Test_\d{1,}UP_[a-z]{2,}_UNIT$" result=RegEx.Test(strText) If result=True Then msgbox "Pass" Else msgbox "Fail" End If Set RegEx=Nothing

let me know if it works.

Regards,
Ankesh

[suresz449]

It's working good, Thanks Ankesh.

[Ankesh]

Glad that it worked.

[shivu.hanu]

test_\[1-9][0-9].*up_\[a-z][a-z]_unit