Forum Discussion

elandfill's avatar
elandfill
Occasional Contributor
12 years ago

[Resolved] DataSource spraying quotes everywhere

I use a DataSource to read from a csv file. Here is the contents of the cell:

this is a test "test this is"

Here is what ends up in the DataSource:

"this is a test ""test this is"""

The POST request I do with this data then fails. Why are all these quotes being added?


if i remove the quotes:

this is a test test this is

Here is what ends up in the DataSource:

this is a test test this is

What is going on?
  • Hi,

    I'm not able to reproduce what you are saying. When I use a csv file with "test this is" the ouput in the datasource is "test this is".

    What properties do you have checked in the datasource if any?


    Regards,
    Marcus
    Smartbear support
  • elandfill's avatar
    elandfill
    Occasional Contributor
    Datasource: File
    File: is a .csv file
    Separator: ,
    Charset: Cp1252
    Trim is unchecked
    Quoted Values is unchecked

    for DataSource options, only "restart on run" is checked.
  • elandfill's avatar
    elandfill
    Occasional Contributor
    When I run it on the string

    "test this is"

    in the csv file, I get

    """test this is"""

    in the DataSource
  • Hi,

    Please attach csv file.


    Regards,
    Marcus
    Smartbear Support
  • elandfill's avatar
    elandfill
    Occasional Contributor
    btw, I'm using SoapUI pro. I guess I posted this in the wrong forum.
  • elandfill's avatar
    elandfill
    Occasional Contributor
    I just discovered it is Excel that is adding in the extra quotes. Sorry about that. Thank you for your time.