Subject Re: csv field data
From Charlie <>
Date Mon, 19 Jul 2021 17:59:11 -0400
Newsgroups dbase.getting-started

Ken..  Thanks for that build tip.  Think I found the solution with this:

shipcost = str(master->shipcost,7,2)
arr= "{^price^:[^"+ltrim(shipcost)+"^]*^method^:[^Fedex^]}"

It actually works, then a macro in libre to change ^ = "  and * = ,

Thanks again!!!!

Ken Mayer Wrote:

> On 7/14/2021 7:02 AM, Charlie wrote:
> > Yes it is a json which I am absolutely not familiar with.  I am still using 11.
> >
> > Gaetano D. Wrote:
> >
> >> On 13/07/2021 22:58, Charlie wrote:
> >>> I hace a program that Myrvin helped me with a while ago.  Basically all it is doing is taking data that I have replaced into fields in a table and converting the data to a csv file.  That is easy to do igf it is cut and dry data.  But I need to put av array in the postage column.  It is like this:  {"price":["5.00","10.00"],"method":["Standard","Priority"]}
> >>>
> >>> Of course the commas are screwing up the columns.  Is there a way of changing this statement so that the commas will not interfere with the structure of the csv file?
> >>>
> >>> Thanks for any help
> >>>
> >>>
> >> That structure is a JSON, do you have dBase 2019? I think I have a demo
> >> code that I may be able to tweak to export this JSON to CSV but won't
> >> have time to look into it until tomorrow evening.
> dBASE 2012 is where the JSON control first appeared. Unfortunately
> arrays are tricky unless you are using something that can interpret JSON.
> Charlie -- are you writing this out to send to someone else? If so, you
> can build the JSON data yourself. If you need to read it in, ... well,
> that's different. If you need to generate the JSON data, you know the
> format, just build the strings *as* JSON, not as CSV. (By the by,
> "Commas are screwing up the columns" -- because "CSV" stands for "Comma
> Separated Values", so of course they would throw things off ...)
> Ken
> --
> *Ken Mayer*
> Ken's dBASE Page:
> The dUFLP:
> dBASE Books:
> dBASE Tutorial:
> dBASE Web Tutorial: