Doing some tests to find certain characters that are rejected by an importing program. Characters are tested in the fourth field, after PART field. They all start with "qqq". So the test for "
!" is "
qqq!".
Test2 and Test9 are adding an extra "\" that I recognize from RegEx. So the "
\" and "
"" chars are problems in the receiving program.
"TEST1","Active","PART","qqq'","","RENTALS",2.0000,"",,"","",1,0,1,"","",,"","",,1.0000,"","","","","",,,,,,,,,"",,,"",,,"","",2154.00000000,"joe",2018/11/15,10:50:00,"joe",2018/11/16,01:05:00,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST2","Active","PART","qqq\"","","RENTALS",2.0000,"",,"","",1,0,1,"","",,"","",,1.0000,"","","","","",,,,,,,,,"",,,"",,,"","",2155.00000000,"joe",2018/11/15,10:52:00,"joe",2018/11/15,11:05:00,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST3","Active","PART","qqq:","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2150.00000000,"joe",2018/11/14,15:44:00,"joe",2018/11/16,00:33:00,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST4","Active","PART","qqq;","","RENTALS",2.0000,"",,"","",1,0,1,"","",,"","",,1.0000,"","","","","",,,,,,,,,"",,,"",,,"","",2156.00000000,"joe",2018/11/15,10:53:00,"",,,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST5","Active","PART","qqq,","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2157.00000000,"joe",2018/11/15,11:30:00,"",,,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST6","Active","PART","qqq-","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2158.00000000,"joe",2018/11/15,11:32:00,"",,,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST7","Active","PART","qqq_","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2159.00000000,"joe",2018/11/15,11:33:00,"joe",2018/11/15,11:34:00,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST8","Active","PART","qqq*","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2160.00000000,"joe",2018/11/15,11:35:00,"",,,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST9","Active","PART","qqq\\","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2161.00000000,"joe",2018/11/15,11:38:00,"joe",2018/11/16,00:33:00,2018/11/16,01:10:00,"",,"","INVITEM",""
"TEST10","Active","PART","qqq/","","RENTALS",1.0000,"",,"","",1,0,1,"","",,"","",,1.0800,"","","","","",,,,,,,,,"",,,"",,,"","",2162.00000000,"joe",2018/11/15,11:41:00,"",,,2018/11/16,01:10:00,"",,"","INVITEM",""
Is there a way to stop the "\" from being inserted? I am sure that other characters may be treated the same way.
I am using the default settings for Export. Only options set are for Comma Separation, Delimit Strings, and Double Quote Delimiter.