notepad++ reg expressions to swap two values

Question

i'm trying to swap latitude and longitude values in notepad++ with regular expressions. i tried to search some guide on the web but i didn't understand how to do. i have a file in which there are: "longitude,latitude" and i want to get: "latitude,longitude" in each row

Example (with two rows):

   12.5164654350527,41.8919188281474
   12.5164650441393,41.891919097598

   becomes

   41.8919188281474,12.5164654350527
   41.891919097598,12.5164650441393

Which regular expression do i have to use?

Answer 1

Try with following regex:

(\d+\.\d+),(\d+\.\d+)

and replace it with:

\2,\1

Answer 2

Search for:

([0-9]+(\.[0-9]+)?),([0-9]+(\.[0-9]+)?)

Replace with:

\2,\1

This catches numbers like 1, 1.1 but not 1. or .5. My previous regexp ([0-9]+.?[0-9]*),([0-9]+.?[0-9]*) would allow for 1..