Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Importing single quotation mark + scripting

v.nonesJun 17 2015 — edited Jun 18 2015

Hi everyone

I am using FDMEE 11.2.3Hi have in my data several fields and one is ...,XXX'XXX,....,2000

I am not even mapping the XXX'XXX value but it seems that I cannot load the data since is trying to convert a non-numeric value into a number and I don't understand why.

I tried to solve this with a BefImport script trying to replace the ' character without being successful. I don't know also what it is wrong in my syntax.

if fdmContext["LOCNAME"] == "YYY":

     fdmAPI.logInfo(fdmContext["LOCNAME"])

     try:

          filename = fdmContext["FILENAME"]

          inbox = fdmContext["INBOXDIR"]

          fdmAPI.logInfo(filename)

          fdmAPI.logInfo(inbox)

          file = inbox + "\\YYY\\" + filename

          file_out = inbox + "\\YYY\\" + filename + ".out"

          fdmAPI.logInfo(file)

          fin = open(file,"r")

          fout = open(file_out,"w")

          for line in fin:

               lineIni=line.replace(''','_')

               fout.write(lineIni)

          fin.close()

          fout.close()

     except IOError, err:

         fdmAPI.logError("My error"+ str(err))

     os.remove(file)

     os.rename(file_out,file)

Does anybody has some insights on this?, why is it taking ' as a comma?

Thank you and regards.

This post has been answered by v.nones on Jun 18 2015
Jump to Answer

Comments

843851
If not Thread.sleep() then what? Why is this not satisfying you?
843851
oh, I am mistaken. Thanks
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 16 2015
Added on Jun 17 2015
3 comments
688 views