3 Replies Latest reply: Jan 28, 2014 2:19 PM by 1008730 RSS

FDM import format - expression for amount

1008730 Newbie
Currently Being Moderated

In the file, the amounts are found with £ sign. For example,-£29,918.00. I'll get invalid data and empty content error while importing. When I removed that sign it worked.

 

Is there an expression in the import format to remove the sign from the amounts? Thank you!

 

 

 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points