Open Hub destination flat file with trailing minus sign

[Former Member]

Could someone please tell me how to change my Open Hub destination settings so that I no longer have trailing minus signs on my negative amounts? This is occurring when I produce a CSV destination file using Open Hub.

Thank you,

Tim

[Former Member]

Newell,

You may need to post this in BW forums for more responses.

Also check Edwins reply in this thread:

Regards,

---Satish

[Former Member]

Satish,

These are currency amounts with negative signs, not sytem settings like Edwin refers to. My example would be 10.00- instead of -10.00. The wrong dollar amount has the minus sign on the end.

Thanks,

Tim

[Former Member]

So if you have the input as 10.00-, you want to be as -10.00. If it is correct then you can do in standard mapping.

If source fields-->endswith minus (text function) --->replace - with space --> then concat - with the replaced valued along with trim --> target field

else

pass as it is.

Regards,

---Satish