notepad++ CSV word replace

[010010]

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]

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.

 

[Alabalcho]

Import the original file into Excel, re-arrange columns, export it back as CSV (or make a formula to assemble it)

 

[010010]

Import the original file into Excel, re-arrange columns, export it back as CSV (or make a formula to assemble it)

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