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.
There is spaces between all columns, example:
215 ; 11 ; 66 ; AE ; XXXXX XXXXX
I need it done as soon as possible. Thank you
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++
Here is the regular expression to use:
\1 ; \2
Here's a screen shot:
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.