One Star

how to remove "quotes" from output delimiter file

Hi
I am filtering rows based on a column in the delimiter file. but the problem is the output file is putting every text in quotes. I am using row filtering. I removed the quotes in the advanced CSV options also. but output still contains quotes. Is there a way around it. The row in my input file is
1216760401:WIDGET:eating.health.com:/2008/06/25/think-thin-your-think-it-off-guide/:0000011ae96c10790000000005ffe123:::::13.8.125.11
and after going through filter it comes out like
"1216760401":"WIDGET":"eating.health.com":"/2008/06/25/think-thin-your-think-it-off-guide/":"0000011ae96c10790000000005ffe123":"":"":"":"":"13.8.125.11":""
4 REPLIES
One Star

Re: how to remove "quotes" from output delimiter file

Hello,
If you uncheck CSV options in advanced setting tab, your file will not have quotes.
(it work like that on my TOS2.4.1)

José
One Star

Re: how to remove "quotes" from output delimiter file

I tried again if I put just "" in the text enclosure box, it put spaces in the output
1216760401 : WIDGET : eating.health.com : /2008/06/25/think-thin-your-think-it-off-guide/ : 0000011ae96c10790000000005ffe123 : : : : : 13.8.125.11 :
One Star

Re: how to remove "quotes" from output delimiter file

No, you should UN-check the "CSV options" box. That worked for me when I tried it.
newColumn:newColumn1:newColumn2:newColumn3
Rutherford:Cleveland:Harbor DrSmiley Very Happyes Moines
Benjamin:Tyler:N Kentwood:Bismarck
LyndonSmiley Tongueolk:North Atherton StreetSmiley Frustratedalem
Theodore:Harrison:French Camp Turnpike Road:Austin
Zachary:GarfieldSmiley Frustrated Rustle St:Annapolis

using the "" in the text enclosure box puts spaces for me (as does using '')
newColumn:newColumn1:newColumn2:newColumn3
Calvin : Roosevelt : North Erringer Road : Salem
William : Jackson : San Diego Freeway : Austin
George : Tyler : Westside Freeway : Indianapolis
Chester : McKinley : Fairview Avenue : Phoenix
Andrew : Ford : Cerrillos Road : Atlanta

and putting nothing in the text enclosure box throws an error
One Star

Re: how to remove "quotes" from output delimiter file

IT WORKED GREAT.........
THANKS A LOT.