Skip to main content
日本語

Why do I get an error message "Quotes are not paired" when reading a CSV file?

  • Updated

Question

When reading a CSV file, I get an error message "Quotes are not paired".
What is the cause and what can I do for this?

 

 

 

Answer

Possible causes
This error has occurred in the past cases under the following circumstances:

  1. The CSV file failed to be read because there were values in the read CSV file that had an incomplete pair of " " (double quotation marks).

    An example would be the following CSV file:
    ----------------------------------------
    "A", "B", "C"
    "D", "E", "F
    ----------------------------------------


  2. When PSP processing is enabled by specifying the same file in the read and write processes, reading and writing are performed in parallel, so the data being written was read, and reading of the CSV file failed.

 


Workaround

  1. When there are values that do not have an incomplete pair of " " (double quotation marks)
    Open the CSV file to be read and check if it contains double quotation mark.
    If it does, check if there are any places where " " is not paired, and edit the file so that " " is paired completely.

    If there are any places where the " " is not paired, it falls under the following specification restrictions.
    Please refer to the following help page file for details.

    When the data contains delimiter character, " (double quotation), or new line, make sure to put " at the beginning and the end of data.

    When " is included in data, put that as 2 consecutive quotations like "".


    Limitations of CSV category
    https://www.hulft.com/help/en-us/HULFTSquare/Content/CN_MPP/CN_message/msg_CSV.htm#limitations


    In addition, there is a past case where the error was resolved by using the Read Variable-Length File Connector instead of the Read CSV File Connector. For more information on the Variable-Length Connector, please refer to the following help pages.

    Read Variable-Length File
    https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/variablelength_get_data.htm

    Variable-Length Wizard
    https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/variable_wizard.htm



  2. When PSP processing is enabled by specifying the same file in the read and write processes
    Disable the PSP processing.
    To disable PSP processing, select the script in the Designer, right-click on it, and select "Script Menu" from the menu.

 

 

Supplementary information

PSP has the following specification limitation.

Files that are processing targets between the read component and write component that perform processing with PSP can't be operated.

　
Also, the above is not guaranteed to work because it falls under the following specification limitations.

There is no guarantee of the behavior of the operation when write or other operations for a file are processed in multiple threads.

Comments

0 comments

Article is closed for comments.