- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Importing single quotation mark + scripting
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":
filename = fdmContext["FILENAME"]
inbox = fdmContext["INBOXDIR"]
file = inbox + "\\YYY\\" + filename
file_out = inbox + "\\YYY\\" + filename + ".out"
fin = open(file,"r")
fout = open(file_out,"w")
for line in fin:
except IOError, err:
fdmAPI.logError("My error"+ str(err))
Does anybody has some insights on this?, why is it taking ' as a comma?
Thank you and regards.