We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
11 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How Do I Delete Everything Before (Or After) The Comma "," In Notepad++
Posted on 2011-03-10
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
Active 1 day ago
Press Ctrl H ( or click "Search button" => Replace )
In the message box:
Mention the following in Find what:
Select Search mode as Regular Expression
then click Replace all
ReplaceRegularExpressionNotepadP.JPG
In the message box:
Mention the following in Find what:
([A-Za-z ]*),([a-zA-Z]*) *[a-zA-Z :]* *[a-zA-Z,]*
\2
Select Search mode as Regular Expression
then click Replace all
ReplaceRegularExpressionNotepadP.JPG
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?
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?
Active 1 day ago
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.
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.
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".
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".
Active 1 day ago
In the following code
\1 represents "Display Name"
\2 represents "SAMaccountName"
In the following code:
\2 represents "SAMaccountName"
\3 represents "ex: Brian Dettewiller,bdettewiller"
Also it is not /2 it is \2
([A-Za-z ]*),([a-zA-Z]*) *[a-zA-Z :]* *[a-zA-Z,]*
\1 represents "Display Name"
\2 represents "SAMaccountName"
In the following code:
([A-Za-z ]*),([a-zA-Z]*) *([a-zA-Z :]* *[a-zA-Z,]*)
\2 represents "SAMaccountName"
\3 represents "ex: Brian Dettewiller,bdettewiller"
Also it is not /2 it is \2
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Utilizing an array to gracefully append to a list of EmailAddresses
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 3 hours left to enroll
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.