This content has been marked as final.
Show 4 replies
-
Data loss when loading from local file
janiuusihannu Jun 14, 2011 6:55 AM (in response to janiuusihannu)EDIT: Solved, I tried this over and over again and changed the Quoting setting from MSQ -> Standard. Somehow that caused the loss of data...
-
Data loss when loading from local file
Stephen Redmond Jun 14, 2011 6:58 AM (in response to janiuusihannu)Glad you found it.
BTW - this is not a "loss" of data. It just gets to a certain point where the msq quoting indicates and end of file. So you end up only getting the first XXX lines. It just doesn't get to the end of the file.
Regards,
Stephen
-
-
Data loss when loading from local file
Stephen Redmond Jun 14, 2011 6:56 AM (in response to janiuusihannu)Hi,
Not a limitation, it is just a problem with the encoding of the file and the quoting used. Try changing from msq to standard.
Regards,
Stephen-
Data loss when loading from local file
Johan Idh Jun 14, 2011 7:01 AM (in response to Stephen Redmond )The cause is generally an unbalanced quote charater on a line making the rest of the file being treated as one record, MSQ supports multiline data by this method.
-