CSV with comma in string

[Hiren]

Hi,

I am using CSV file generated by TestStand 4.5 import/export function that has one of the string variable with comma in it ("This is comma, Test."). But the property loader can't load this file and errors out. Is there a way to solve this problem? I do not want to use the tab txt file as csv is more readable.

Thank you,

Hiren

[Courtney_L]

Hey Hiren,

Thanks for posting! When you say the property loader errors out, do you see an error window or associated error code? If so, could you provide a screenshot?

[Hiren]

Hi Courtney,

Thanks for the reply. The error screen shot.

The CSV file looks like:

START

<Step Name>

<Locals>,Variable Value

<FileGlobals>,Variable Value

testString,"This is comma(,) test."

<StationGlobals>,Variable Value

END

Thanks,

Hiren

[crossrulz]

Sorry, but there's no way to discrimate a comma being a delimiter and a comma as part of a value.  I think in this instance, you are going to have to go to the tab delimiter.