Trim LDAP extract

Olivier Chantraine

Hello,
i need to remove every first (ex:CN=toto), from my ldap export.
its easy if there is only one.
but my extract containt sometime more.

ex:
CN=toto,CN=test,DC=contoso,DC=local

and then, the replace option remove every CN.
If i use the mark option, its ok, but i can’t remove marqued texte (or i dont find the option)

Could you help me with that ?
Thanks :)

Alan Kilborn

@Olivier-Chantraine

Your problem statement is a bit vague, but with my interpretation of it, I would try:

Find: \A(?s)(.*?)(?-i)CN=\w+,
Replace: ${1}
Search mode: Regular expression

Alan Kilborn

@Olivier-Chantraine said in Trim LDAP extract:

i can’t remove marqued texte (or i dont find the option)

This option doesn’t exist because you can just use Replace instead.

Olivier Chantraine

@Olivier-Chantraine said in Trim LDAP extract:

Hello,
i need to remove every first (ex:CN=toto), from my ldap export.
its easy if there is only one.
but my extract containt sometime more.

ex:
CN=toto,CN=test,DC=contoso,DC=local

and then, the replace option remove every CN.
If i use the mark option, its ok, but i can’t remove marqued texte (or i dont find the option)

Could you help me with that ?
Thanks :)

Sorry, i will try to be clear,
i have a csv with multiple line (txt line)
each line start with CN=
CN=toto,CN=test,DC=contoso,DC=local
CN=tota,OU=test,DC=contoso,DC=local
CN=tata,OU=test2,DC=contoso,DC=local
CN=tAto,CN=test2,DC=contoso,DC=local

i want to remove the first “CN=text,”
with option mark text, i use :

^CN.*?,

and it work well (for marking only)
but , if i replace, the regex erase all “CN=text,” in the same line

PeterJones

@Olivier-Chantraine said in Trim LDAP extract:

and it work well (for marking only)
but , if i replace, the regex erase all “CN=text,” in the same line

That’s because after the substitution, the next CN=text, is the first CN=text, on the line, and it will match again.

I think what you want is
FIND = (?-s)^CN=.*?,(.*)$
REPLACE = ${1}

That will delete the first CN=..., on each line, leaving the rest of the line intact.

----

Useful References

Alan Kilborn

@Olivier-Chantraine

From the revised explanation of the problem, I can see why you liked the Mark idea (that wouldn’t work). :-)

Olivier Chantraine

@PeterJones said in Trim LDAP extract:

@Olivier-Chantraine said in Trim LDAP extract:

and it work well (for marking only)
but , if i replace, the regex erase all “CN=text,” in the same line

That’s because after the substitution, the next CN=text, is the first CN=text, on the line, and it will match again.

I think what you want is
FIND = (?-s)^CN=.*?,(.*)$
REPLACE = ${1}

That will delete the first CN=..., on each line, leaving the rest of the line intact.

----

Useful References

Please Read Before Posting

Template for Search/Replace Questions

Formatting Forum Posts

Notepad++ Online User Manual: Searching/Regex

FAQ: Where to find other regular expressions (regex) documentation

Ty, its working :)