I need to do an insert in the database, but I have been sent the sql to import with the wrong culture (globalization or whatever).
In this 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 to use notepad ++ to do a replace in any sql that exchanges these commas for points, but only in the values that are in that format, because there are many other commas in this sql that must be maintained.
Is it possible to do this?
Example of an insert that 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 the '7.48' has to turn '7.48' the '5.53' has to turn '5.53' and '6.5' has to turn '6.5'