Empty quote string "" import problem
9 years 2 weeks ago #617
by zpr
Empty quote string "" import problem was created by zpr
Hello.
I'm having a problem with empty quote strings "" when I am importing to i2L. Here's a example:
Importing the following csv to i2L:
I will get a Quote " in every 'Description' field:
Exporting back to CSV from i2L I get the following output:
I'm using i2L v2.4.5 f3 and Unity3d v4.6.4 f1
Thanks.
I'm having a problem with empty quote strings "" when I am importing to i2L. Here's a example:
Importing the following csv to i2L:
I will get a Quote " in every 'Description' field:
Exporting back to CSV from i2L I get the following output:
I'm using i2L v2.4.5 f3 and Unity3d v4.6.4 f1
Thanks.
Please Log in or Create an account to join the conversation.
9 years 2 weeks ago - 9 years 2 weeks ago #621
by Frank
Are you
Give I2L
5 stars!
Are you
Please lets us know how to improve it!
Replied by Frank on topic Empty quote string "" import problem
Hi,
I'm going to double check in excel to see if there has been any change in the csv format.
However, what you are seeing is kind of expected behavior.
When you export a csv from excel the empty columns are not exported as:instead, they are exported as:
When parsing the csv file, ("") and most (""") are interpreted as one quote (").
Is the csv file you show in the picture exported by a spreadsheet software or by an in-house tool? If its by a known software, please let me know so I can check how it outputs and adapt the code to handle that as well.
Nonetheless, I will double check in excel and google spreadsheet to verify thats the expected behavior.
However, a quick fix to make those csv work fine, is to replace (,"",) by (,,).
Hope that helps,
Frank
I'm going to double check in excel to see if there has been any change in the csv format.
However, what you are seeing is kind of expected behavior.
When you export a csv from excel the empty columns are not exported as:
Key,"",DescKey,,DescWhen parsing the csv file, ("") and most (""") are interpreted as one quote (").
Is the csv file you show in the picture exported by a spreadsheet software or by an in-house tool? If its by a known software, please let me know so I can check how it outputs and adapt the code to handle that as well.
Nonetheless, I will double check in excel and google spreadsheet to verify thats the expected behavior.
However, a quick fix to make those csv work fine, is to replace (,"",) by (,,).
Hope that helps,
Frank
Are you
Give I2L
5 stars!
Are you
Please lets us know how to improve it!
To get the betas as soon as they are ready,
check this out
Please Log in or Create an account to join the conversation.
Time to create page: 0.411 seconds