SQL Server fields concatenated in Zoho table
Hi!
I'm using UploadFromDB.bat to move a table from SQL Server to Zoho.
The Zoho table has the same columns as the SQL Server.
But the data from two of the columns are concatenated. In all the subsequent columns, the data is shifted one column over to the left, and the last column, of course, is empty.
The data in the messed up column has a comma that (I suspect) is supposed to separate the two fields:
11th Annual Meeting of the Society of AAA BBB ,Society of AAA BBB
Could some data have a character that's causing a problem for the batch job? Maybe I need to escape out some set of characters? Of is there something in the batch job that I should change (like maybe changing the field delimiter or something like that)?