Cimload " inch in 1.4.1 item number or description field

[susieq_va99]

We have item numbers such as "3012.02 6.50" MIN" and we are running a cimload to update fields in 1.4.1. The Cimload will not get past the first Item Number field, due to " symbol. I have tried adding tilde(~) before ". I have done this before many many many years ago. Anyone know the format?
@@batchload ppptmt.p
"3012.02 6.50" MIN" "ST" "This item has inch quotes and will not load" "please help"
- -
.
@@end

 

[jruch]

From an old post - try putting the quote inside a pair of quotes. 6.50" becomes 6.50"""

 

[susieq_va99]

thanks, we tried this. also ~"(tilde quote), \" (backslash quote), '"' (single double single quote). Nothing has worked.

 

[Marco Mendoza]

We have item numbers such as "3012.02 6.50" MIN" and we are running a cimload to update fields in 1.4.1. The Cimload will not get past the first Item Number field, due to " symbol. I have tried adding tilde(~) before ". I have done this before many many many years ago. Anyone know the format?
@@batchload ppptmt.p
"3012.02 6.50" MIN" "ST" "This item has inch quotes and will not load" "please help"
- -
.
@@end

Test this: display quoter('hello"hello') format "X(20)"

The 2 quotes should work, if not is other the issue. On your example you must skip after the part number.

@@batchload ppptmt.p
"3012.02 6.50"" MIN"
"ST" "This item has inch quotes and will not load" "please help"
- -
.
@@end