Regular Expressions in VBA

[Aidy680]

Not sure if this is the right forum....

I have an expressions that reads currently:

\nSubject:\s{2}[A-Z]{3}\s{1}\d{2}

which finds the following:

Subject: DEC 07 AAAA (30) 20.7 EXAMPLE
X_MS_Has_Attach:

What expression would I now need to use to get just the first line? I tried using:

\r

which I thought would find the carraige return character but to no avail.

Anyone?

 

[RoyVidar]

Are you using re.multiline = true? If so, try switching to false.

I'm far from an expert, but isn't \r carriage return? Could you try \n (newline)?

But, are you sure that pattern really returns the two lines, and not just

Subject: DEC 07

Roy-Vidar

 

[Aidy680]

Roy thanks for your reply.

No I'm not using multiline.

Also apologies but you're quite right. It only returns:

Subject: DEC 07

I'll give your "newline" suggestion a try and update here soon.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/2380d458-3366-402b-996c-9363906a7353.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Aidy680]

Sorry guys for the lack of follow-up on this but I got it working in the end so thanks for your assistance.