REGEX - How to Replace special case

[SiegfriedW]

Dear specialists,

I have following problem. I have a file in the following format:

I want to upload it into SAP and want to split with the seperator ,

Now I have the problem, that in the amount the decimal sign is also ,

Is there a way to replace the , (seperator) to ; with REGEX?

Best Regards

Sigi

[RaymondGiuseppi]

So you'd like to replace all occurrences of a character (,) unless it's enclosed in quotation marks ("), which won't be easy and code won't be very readable.

Couldn't you ask the file sender to stick to a more stict CSV format?

[SiegfriedW]

This is exactly what I want. The problem is, that I receive the file from a Payment Service Provider as a csv-file. And there is no possibility to change this