Imported CSV, getting Invalid opening quote

1 
{
  "CreationDate": "2018-9-3",
  "Commands": [
    {
      "Command": "csvRead",
      "Target": "ad.csv",
      "Value": ""
    },

This is my first lines of code in the macro.
No idea why it doesn’t work, copy pasted the model from the Demo Macros.

1 Like
2

Your macro command is ok. The error “Invalid opening quote” means that a inside the CSV file something is wrong, probably a missing " or one " too much.

1 Like
3

Did you find the error? I have received the same. And that happens at the beginning. In line 1 !!! How can this happen?
[error]
Line 1: Invalid opening quote at line 1
…
See that:
…
{
“Name”: “ToFill”,
“CreationDate”: “2020-9-4”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “teste1.csv”,
“Value”: “”
},
…

4

This is very correct. I removed all "and now the csv is being read. However now it puts all of the data from the first line in the first field. Strange …

5

although macro read csv, now it presents the following error:
[error]
Line 7: Internal variable “! COL2” not supported
…
I realy do not understand…

6

I had the same issue. What helped me was deleting the " in the first line and typing it again. Maybe there was an invisible char added by the (external) software by mistake.

7

Hello. I think i found 1 of possible solutions. Just delete any space bars before first quote. It need to be like:

first, second,“third, with commas, for example”, fourth

Here we have commas like separator, and we use quotes for isolating other commas in COL3. If we use space bar before first qoute, we ll got same error you got.

It s just because space bar not included in COL3 if we using quotes:

COL1, COL2, COL3 - it will work fine, but
COL1, “COL2”, COL3 - will not work bcs space bar between COL1, and "
Repair it like that:
COL1,“COL2”, COL3 - here it will work

space bar here is character, thats why this problem here