How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask SteveCaliendo Your Own Question
SteveCaliendo
SteveCaliendo, Computer Software Engineer
Category: Microsoft Office
Satisfied Customers: 116
Experience:  Computer Software Engineer Over 15 years professional experience as a software development engineer. Awarded 8 US Patents
629026
Type Your Microsoft Office Question Here...
SteveCaliendo is online now
A new question is answered every 9 seconds

I need help with notepad++If i have this text format:2841

This answer was rated:

I need help with notepad++


 


If i have this text format: 2841 ; 21 ; 41 ; AE ; XXXXX XXXXX


 


and want it changed to: 2841 ; 21 ; 41 ; AE ; JOHN ; SMITH


 


How do I do that, automaticly??? As you can see, its the 5th column from the first format.

Hello my name is XXXXX XXXXX I will assist you today. I have a quick question for you before I can assist.

Is that he only place where you have a space, between the first and last name at the end of the row? I know there will be space after the last name but that is ok.

example

1236;23;85;AE;XXXXX XXXXX
7596;95;75;PO;XXXXX XXXXX
7895;65;47;ER;BOB SMITH


Regards,

Hans E Uebelhoer



Customer: replied 3 years ago.

Hi Hans.


 


There is spaces between all columns, example:


 


215 ; 11 ; 66 ; AE ; XXXXX XXXXX

Ok, I see now. If those were the only spaces this would be very easy to do. Do you have a deadline when this needs to be done by. I need a some time to test this and see if I can get something to work for you.

Regards
Hans Uebelhoer
Technical Support Manager
Blackboard Inc.
Customer: replied 3 years ago.

I need it done as soon as possible. Thank you

Ok, I will get this done ASAP

Hans
Customer: replied 3 years ago.

Great

Hi, I wanted to let you know I am still looking into this and I wanted to check, are the spaces you want to remove and replace with a semicolon a set number of spaces to the right from the right margin?

Hans
Customer: replied 3 years ago.

I dont want to remove the spaces, i just want to add " ; " between first name and last name, from the 5th columns, using an expression in notepad++

Hi,

 

Here is the regular expression to use:

 

Find:

 

([A-Za-z]) ([A-Za-z])

 

Replace with:

 

\1 ; \2

 

Here's a screen shot:

 

 

graphic

 

 

Just for your information, what this does is look for any case where letters (either capital or lower case) are separated by a space. It then saves those values into \1 and \2. Then, it replaces the text with \1 (the first character) a space + a semicolon + a space, and then next character, \2.

 

Please let me know if you need further assistance.

 

Best Regards,

 

Steve

SteveCaliendo, Computer Software Engineer
Category: Microsoft Office
Satisfied Customers: 116
Experience: Computer Software Engineer Over 15 years professional experience as a software development engineer. Awarded 8 US Patents
SteveCaliendo and 2 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions