Analytics Software

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.