in removing the quotes, you need to do a recursive routine to see if you
have double quotes ("color: "black and blue, red""
also keep track if the commas are in the double quote, so you ignore
them on this pass.
Jacopo Cappellato sent the following on 11/30/05 12:59 AM:
> Hi,
>
> you should remove all the quotes ("):
>
> 23432,TEST,long text or memo field here
> 23323,TEST,another memo field here
>
> Jacopo
>
>
[hidden email] wrote:
>
>> I'm having some trouble changing my delimited files to xml. How do you
>> guys go around text that is inside "" and then is delimited by ,. So the
>> file would like that
>> 23432,TEST,"long text or memo field here"
>> 23323,TEST,"another memo field here"
>>
>> My question is how do you set definitions for such file. I tried with
>> quotes around long or memo fields but then i bunch of errors.
>>
>> _______________________________________________
>> Users mailing list
>>
[hidden email]
>>
http://lists.ofbiz.org/mailman/listinfo/users>>
>
>
> _______________________________________________
> Users mailing list
>
[hidden email]
>
http://lists.ofbiz.org/mailman/listinfo/users>
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Locked
