Pages: [1]
  Print  
Author Topic: [SOLVED] ReadCSV escape characters disappear even when quotes disabled  (Read 504 times)
tennenrishin
Full Member
***
Posts: 177


WWW
« on: April 19, 2013, 09:03:14 PM »

If the ReadCSV operator's "use quotes" parameter is off, the "escape character for quotes" parameter is hidden. This suggests that the "escape character for quotes" is only relevant when "use quotes" is on.

However, even with "use quotes" off, my ReadCSV operator seems to be removing '\' characters from the read content, unless I set "escape character for quotes" to some other character.

Code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.005">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.3.005" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="read_csv" compatibility="5.3.005" expanded="true" height="60" name="Read CSV" width="90" x="112" y="75">
        <parameter key="csv_file" value="C:\Users\isak\Desktop\a.txt"/>
        <parameter key="use_quotes" value="false"/>
        <parameter key="parse_numbers" value="false"/>
        <list key="annotations"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="content.true.nominal.attribute"/>
        </list>
      </operator>
      <connect from_op="Read CSV" from_port="output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

Quote from: a.txt
1
.*,CLS\(.*
« Last Edit: April 22, 2013, 11:07:47 AM by tennenrishin » Logged
Marius
Administrator
Hero Member
*****
Posts: 1794



WWW
« Reply #1 on: April 22, 2013, 07:22:37 AM »

Thanks for reporting. I have created an internal bug report.

Best regards,
Marius
Logged

Please add [SOLVED] to the topic title when your problem has been solved! (do so by editing the first post in the thread and modifying the title)
Please click here before posting.
Marcin
Global Moderator
Full Member
*****
Posts: 165


« Reply #2 on: June 17, 2013, 10:39:52 AM »

We have renamed the parameter ("escape_character") and removed the parameter dependency (i.e. the parameter is always displayed) to make clear that this character will not only be used for quotes. The next release will contain these changes.
Logged
Pages: [1]
  Print  
 
Jump to: