Sometimes it is necessary to convert data from number format, which includes separation to format without them. It means, from the format: x,xxx,xxx.## to the format: xxxxxxx,## (from: 1,250,387.25 to: 1250387,25).

This can be done for example in the notepad++ application with the following approach:

(!) Regular expression has to be ON

1. Replace “,”

Find what: (\d)\,(\d)
Replace with: \1\2

2. Replace “.” with the “,”:

Find what: (\d)\.(\d)
Replace with: \1,\2