This content has been marked as final. Show 5 replies
Hi There,1 person found this helpful
You might want to try referring to it as chr(34).
So I changed to replace(strfield, "chr(34)", "") but that didnt work. The import succeeded, but the values were still skipped and marked as NN (non numerical)
Any other ideas maybe??
Remnove the "" around chr(34) from your statement i.e. replace(strfield, chr(34), "")1 person found this helpful
I solved it by importing a textfile instead of the .csv file. Apparently there is a problem in these files because of the language setting in some plants. but the chr(34) works!
Edited by: JDeM on 4-mrt-2011 7:31
Glad to help