Anyone ever successfully use bat to import fields with commas in the fields? for example I want the "display name" field on a line to be lastn, firstn.<br><br>Since BAT is a csv, the bat help says this is possible...
<br><br><br><strong>5.If the value of the field includes a comma or double quotes, then that field must be enclosed in double quotes. Enclosing the field in double quotes is not required for characters other than comma and double quotes in the field value.
<br> For example if the line text label includes a comma in its value, the sample record would be: <br> 1231123245AB,2,9728437154,9728437154,"Mike,line1",9725557172,9725557196,9725557126,9725557148,9725557166,9725557171,Marketing
<br></strong><br><br>Formating it like this, always errors out bat though. This field accepts a comma if you enter it through ccmadmin, but regardless of how i format the csv, a comma in the field is never taken. I have tried this on 2 installs of CM
4.1.3, a CM 4.1.2, and a cm 4.1. All the same <br><br>Any others have similar issues? or better, a fix?<br><br><br>-- <br>Nick Marus<br><a href="mailto:nmarus@gmail.com">nmarus@gmail.com</a><br>