Hi Evelyne Ridyard 

Just run a search and replace using regular expressions by checking the box for regular expressions in the replace dialogue. Based on this one example you would do this:

Search for:
(\d+),00\s\$

Replace with:
$1 $

So that would convert 30,00 $ to 30 $. Is that what you wanted?

It would be a good idea to provide more examples though.  This pattern replace is fairly safe as long as the format would be something like this in the target:

123,00 $

1.234,00 $

1.234.567.890,00 $

It will only replace the end part but leave all the numbers.  But it would be good to see more examples to be sure.

Hi Evelyne Ridyard 

Just run a search and replace using regular expressions by checking the box for regular expressions in the replace dialogue. Based on this one example you would do this:

Search for:
(\d+),00\s\$

Replace with:
$1 $

So that would convert 30,00 $ to 30 $. Is that what you wanted?

It would be a good idea to provide more examples though.  This pattern replace is fairly safe as long as the format would be something like this in the target:

123,00 $

1.234,00 $

1.234.567.890,00 $

It will only replace the end part but leave all the numbers.  But it would be good to see more examples to be sure.

I'm not sure we are talking about the same thing. Here is a screenshot. The auto-suggestion gives me 30,00 $ instead of 30 $. Isn't there a way to make it suggest the right format? Thank you!