Skip to main content
Participant
May 25, 2024
Question

Photoshop variable dataset doesn't parse csv correctly.

  • May 25, 2024
  • 4 replies
  • 482 views

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.

This topic has been closed for replies.

4 replies

Stephen Marsh
Community Expert
Community Expert
May 26, 2024
quote

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.

 

 

Participant
May 25, 2024

@Stephen Marsh 

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.

Bojan Živković11378569
Community Expert
Community Expert
May 25, 2024

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.

Stephen Marsh
Community Expert
Community Expert
May 25, 2024

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.