FDM import format - expression for amount

1008730 Jan 24, 2014 11:00 PM

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!

1. Re: FDM import format - expression for amount

Francisco Amores Jan 27, 2014 11:43 AM (in response to 1008730)

Hi,

You can have an import script to remove first char of amount.

Regards
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: FDM import format - expression for amount

JeffJon Jan 28, 2014 3:40 PM (in response to 1008730)

Simple import script like below would take care of it:

Function RemoveR(strField, strRecord)
'------------------------------------------------------------------
FDM DataPump Import Script:
'
'Created By:     wladmin
'Date Created:   3/17/2012 6:43:08 PM
'
'Purpose:
'
'------------------------------------------------------------------
RemoveR=Replace(StrField,"£","")
End Function
Like Show 0 Likes(0)

Actions
3. Re: FDM import format - expression for amount

1008730 Jan 28, 2014 10:19 PM (in response to JeffJon)

That works! Thanks a bunch!
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.