• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
1

Photoshop variable dataset doesn't parse csv correctly.

New Here ,
May 24, 2024 May 24, 2024

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.

TOPICS
Windows

Views

204

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe
Community Expert ,
May 24, 2024 May 24, 2024

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 24, 2024 May 24, 2024

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 25, 2024 May 25, 2024

Copy link to clipboard

Copied

@Stephen_A_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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 26, 2024 May 26, 2024

Copy link to clipboard

Copied

LATEST
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:

 

Layer 1.png

 

In this example, two-sets of open and close double-quotes are required to 'escape' the first quote:

 

Layer 2.png

 

I had to use tab-delimited as comma-separated wouldn't work correctly when using a comma in the content with escaped double-quotes.

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines