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.