My bank provides csv export files where the amount sits in a field without a positive or negative sign. The sign (in my case A for -/- and B for +) sits in it's own field. Do you have a trick or suggestion that makes it possible to create the export amount field based on the amount field and the value in the sign field.
Example: amount = 500, sign field = A. Export amount = -/- 500
Example: amount = 250, sign field = B. Export amount = 250