Hi Community,
we just started to push Salesforce Data into Pigment.
Currently we face the issue, that our Salesforce amounts (Type currency) cannot be imported into Pigment as number, due to the currency symbols.
Is there any workaround instead of converting all Salesforce amount currency fields into number fields? (we have a lot)
Thanks,
Daniel
Best answer by Gawain
View original
+5
Hello Daniel,
When configuring the import, have you tried using the specific formatting options to remove the currency symbols as Prefix or Suffix on the “Amount” column?
If you have inconsistency in your Amount column, then I would rather suggest you load it as a Text property and use LEFT(), RIGHT(), CONTAIN(), MID(), TRIM() functions to clean the Amount and then convert in a different column as a number using the VALUE() function.
Hope this helps
Thanks Gawain, i was able to convert the data with the LEFT(), RIGHT(), CONTAIN(), MID(), TRIM() functions
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
