Switch to regex format '0,00' to format '0.00'

Asked

Viewed 260 times

0

I need to make an entry in the database, but I was sent sql to import with the culture (globalization or whatever) wrong.

That way the numbers in SQL are in this format:

'0,0 ou '0,00' ou '00,00' ou '000,00' ou seja, aspa simples + numero(s) + virgula + numero(s) + aspa simples

But I need them in this format:

'0.0 ou '0.00' ou '00.00' ou '000.00'

I would like through Notepad++ to replace all sql that swaps these commas for points, but only in the values that are in this format, because there are many other commas in this sql that should be maintained.

It is possible to do this?

Example of an Insert I want to use replace:

Insert into TB_META (COD_META,COD_CONFIGURACAO,COD_OBJETIVO,COD_UG_RESPONSAVEL,TIP_META,TXT_DESCRICAO,TIP_LEITURA,TIP_MEDIDA_META,TIP_FORMA_CALCULO,VAL_MINIMO,VAL_MEDIO,VAL_MAXIMO,DATA_INATIVACAO,NUM_PERIODO_INATIVACAO,COD_CONFIGURACAO_INATIVACAO,TXT_METRICA_CALC,TXT_EVIDENCIAS) values ('209','8','91','742','E','Gerar xxxxxxxxxxx.','>   ','%   ','U','5,53','6,5','7,48',null,null,null,'Ganhos xxxxxxxx','Métrica aprovada em xxxxxx.');

In this case '7.48' has to turn '7.48' to '5.53' and '6.5' has to turn '6.5''

regex

1 answer

5


Try using this regex in the search: ( d+),( d+)

and this string to replace: 1. 2

Browser other questions tagged regex

You are not signed in. Login or sign up in order to post.