Copy link to clipboard
Copied
Photoshop's variable Dataset csv parsing is wrong. When I upload a dataset with following structure:
KeyName1, KeyName2
key1, """key2"""
Photoshop sees second variable as
`key2"`
So it doesn't recognise a first quote for some reason.
Copy link to clipboard
Copied
Why 3 sets of double quotes?
https://prepression.blogspot.com/2016/08/photoshop-variables-leading-double.html
Edit: what final result do you require? Knowing the desired outcome, one can work backwards.
Copy link to clipboard
Copied
I have conducted tests on my side, and everything functions as anticipated. The term ""dvd"" is correctly imported as "dvd" on the Type layer. For testing purposes, I am utilizing a plain text file with tabs as the data set separator.
Regarding your inquiry, I presume your ultimate objective is to have text enclosed in double quotes.
Copy link to clipboard
Copied
Why 3 sets of double quotes?
This is not 3 sets of double quotes. A quote defines a second column, then two quotes are used to have a quote in a text. CSV file can be something like:
T1, T2
key1, """key2 some other info, and more"""
I need Photoshop to parse the second column as:
"key2 some other info, and more"
Instead, it parses it as:
key2 some other info, and more"
I checked your link, but I wasn't able to make it work. When an additional quote is added at the beginning it just says "too many variables". And even if it did work, it is still a bug, this is not how csv is parsed.
Copy link to clipboard
Copied
This is not 3 sets of double quotes. A quote defines a second column, then two quotes are used to have a quote in a text.
By @glebk99295698
My understanding is that such files are generally tab-delimited or comma-separated, the tab or comma defines each column, not the "quotes". Some software encloses a text string in straight double-quotation (inch) marks to stop the software from parsing the data and recognising the comma as a separator character.
Anyway, the following works for me in Ps 2024 with a tab-delimited text file, the double-quotes are not needed in this example, they are 'unescaped' and don't output:
In this example, two-sets of open and close double-quotes are required to 'escape' the first quote:
I had to use tab-delimited as comma-separated wouldn't work correctly when using a comma in the content with escaped double-quotes.