notepad++ CSV word replace

010010

Commendable
Jun 29, 2016
44
0
1,610
Hello, i am editing a Text file in order for it to comply with the CSV syntax needed for Envoy; unfortuantley the long list of Names, numbers and email addresses is in the wrong order, it should be as follows:

First Last, Email@Domain.co.uk, PhoneNumber

At the moment it is in this format:

First Last, PhoneNumber, Email@Domain.co.uk

i am using Notepad++ and i am aware of "CTRL+H" but not sure of how to use it in this situation. Any suggestions would be much appreciated. Thanks.
 

randomizer

Distinguished
You can try using the regular expression find/replace to rearrange the file. Something like this might work:

Find:
[fixed]^([^,]*),([^,]*),(.*)$[/fixed]
Replace:
[fixed]\1,\3,\2[/fixed]

This has only been lightly tested. It'll be simpler and more reliable to do it in Excel if you can.
 

010010

Commendable
Jun 29, 2016
44
0
1,610


decided to use this method seen as i will only need to do it once.
 

TRENDING THREADS