Removing Double quotes from Data Table

Help Studio
, , , , , , , , ,
1

I first Read a CSV file to the Data Table

The data looks like this:

“09/01/2008,P09 ABC DEF ACCT,50999,7777, ,-1349212.690,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777, ,376427.901,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-669654.680,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-679940.280,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,3790323.990,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-1619628.740,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-11482.201,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,160314.870,”
“09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,2851.801,”

I want the data to look like:

09/01/2008,P09 ABC DEF ACCT,50999,7777, ,-1349212.690,
09/01/2008,P09 ABC DEF ACCT,50999,7777, ,376427.901,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-669654.680,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-679940.280,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,3790323.990,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-1619628.740,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,-11482.201,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,160314.870,
09/01/2008,P09 ABC DEF ACCT,50999,7777,000 ,2851.801,

2

Hi @J_Jalapeno ,

Could you let us know what was the delimiter used in the Read CSV Activity ?

3

The delimiter used was a Comma

4

HI,

If need datatable which has 6 columns from the text, the following will work. Can you try this?

image
image757×670 21.8 KB

Sample
Sample20231010-1L.zip (2.9 KB)

Regards,