How Do I Delete Everything Before (Or After) The Comma "," In Notepad++

I just exported a list of SAM account names into a text file. The format in the text file is:
Display Name,SAMaccountName ex: Brian Dettewiller,bdettewiller

i have 955 lines of this data in the text file. How do I, in Notepad++, delete everything in front of the comma "," so that all I am left with is the SAMaccountName? I know this is a Replace function and something to do with the Extended options, but I do not know how to do this. The little bit of info there is on this isn't very clear to me.

Monterio

Asked: 2011-03-10

Advertise Here

1 Solution

LVL 10

Murugesan NagarajanSubject-matter expert at C++ C delivery, implementation, at UNIX oriented operating systems (Windows: CYGWIN_NT MINGW32_NT MINGW64_NT)Commented: 2011-03-10

Press Ctrl H ( or click "Search button" => Replace )

In the message box:
Mention the following in Find what:

([A-Za-z ]*),([a-zA-Z]*) *[a-zA-Z :]* *[a-zA-Z,]*

Open in new window

Mention the following in Replace with:

\2

Open in new window

Select Search mode as Regular Expression
then click Replace all
ReplaceRegularExpressionNotepadP.JPG

LVL 1

MonterioAuthor Commented: 2011-03-11

Hi, Murugesandins.

Thanks for the assistance. That did the trick. Your suggestion has deleted everything but has left a space in front SAM account name. Is it safe to assume that I can run the exact same thing but in the Replace field change the "\2" to whatever is representative for say a hyphen (-)? What would I use for that, and more importantly is there some sort of reference doc that has these character sets in it?

LVL 10

Murugesan NagarajanSubject-matter expert at C++ C delivery, implementation, at UNIX oriented operating systems (Windows: CYGWIN_NT MINGW32_NT MINGW64_NT)Commented: 2011-03-13

Kindly let me know:
1. the contents of the text file(opened in notepad++) => for example 3 or 4 lines
2. The output after replacement.

>> What would I use for that, and more importantly is there some sort of reference doc that has these character sets in it?
Can you explain this in detail.

LVL 1

MonterioAuthor Commented: 2011-03-14

I figured out what happened actually. The space that was left was due to the way I copied your suggestion into the field. Somehow it created a space before the first character of each SAM name on each line of the file. I restored the file, and was much more careful about the copy and it worked withouth any hiccups. So obviously I goofed up the copy & paste...an illegal character in there or something.

As far as my last question goes, I'm referring to the "/2"m, which I assume is represents the commna (","). If I want to substitute that commna for another character, where would I find a listing of the codes like, "/2" that represent an ACII character...what I refer to as a "character set".

LVL 10

Murugesan NagarajanSubject-matter expert at C++ C delivery, implementation, at UNIX oriented operating systems (Windows: CYGWIN_NT MINGW32_NT MINGW64_NT)Commented: 2011-03-14

In the following code

([A-Za-z ]*),([a-zA-Z]*) *[a-zA-Z :]* *[a-zA-Z,]*

Open in new window

\1 represents "Display Name"
\2 represents "SAMaccountName"

In the following code:

([A-Za-z ]*),([a-zA-Z]*) *([a-zA-Z :]* *[a-zA-Z,]*)

Open in new window

\1 represents "Display Name"
\2 represents "SAMaccountName"
\3 represents "ex: Brian Dettewiller,bdettewiller"

Also it is not /2 it is \2

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

How Do I Delete Everything Before (Or After) The Comma "," In Notepad++

Join & Write a Comment Already a member? Login.

Featured Post