member: CN=SCHDC0001,OU=Domain Controllers,DC=usa,DC=xl
member: CN=MRYDC0001,OU=Domain Controllers,DC=usa,DC=xl
member: CN=CHIDC0001,OU=Domain Controllers,DC=usa,DC=xl
member: CN=YT2DC0001,OU=Domain Controllers,DC=usa,DC=xl
member: CN=EXTDC0002,OU=Domain Controllers,DC=usa,DC=xl
member: CN=BDADC0005,OU=Domain Controllers,DC=usa,DC=xl
member: CN=ME1DC0001,OU=Domain Controllers,DC=usa,DC=xl
and i just want the value of CN=xxxxxxxx
the end result should give me
SCHDC0001
MRYDC0001
CHIDC0001
YT2DC0001
help on extract, very simple
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Re: help on extract, very simple
Easy, just use EasyPattern search/replace
Set the replacement to:
and check the Extract option
Code: Select all
CN=[ capture( longest 1+ not comma ) ]
Code: Select all
$0\r\n