stringregexp help

[gcue]

i am trying to capture "#REO;Cantors-SIM" from this lines of text like this one:

G CN=\#REO;Cantors-SIM3 #REO;Cantors-SIM C

here is what i have so far and am not sure why its not working

$group = StringRegExpReplace($line, ".*5([\S]+)", "")

thanks in advance =)

[Xenobiologist]

Do you some more information? Examples of lines. Shouldn't be that hard to create the correct pattern.

[gcue]

here are more examples...

should get #SL Library from

G CN=#SL;Library3 #SL;Library C

should get RMAD from

G CN=RMAD3 RMAD C

should get Socket Data Services from

G CN=Socket;Data;Services3 Socket;Data;Services C

thanks again for your help!

Edited June 1, 2012 by gcue

[Xenobiologist]

Well, there is no rule, right?

a) Get the words between =\ and ; and ; and 3 or C

between = and 3 or C

c) between = and 3 or C without ;

Edited June 1, 2012 by Xenobiologist

[gcue]

correct. but sometimes theres no "" after CN=

[Bowmore]

This will work for all your examples

$group = StringRegExpReplace($line, "^.* ([S]+) [S]*$", "1")

[gcue]

ur right!! works fantastic

i added this also

StringReplace($group, ";", " ")

thank you very much!

[Xenobiologist]

I had this

$group = StringRegExpReplace($line, ".*?CNW+(.*?)3.*", "$1")