I tried with the transformer "substringextractor" but I remove the "1" from my thousandth when there is no comma at the beginning.
I saw that there was a transformer "LastSectionOfStringRemover", maybe it exists for the beginning?

I tried with the transformer "substringextractor" but I remove the "1" from my thousandth when there is no comma at the beginning.
I saw that there was a transformer "LastSectionOfStringRemover", maybe it exists for the beginning?

Best answer by chrisatsafe
Hi @clozanolpz ,
You can use a StringReplacer in the Replace Regular Expression Mode with the following text to replace:
^,