Re: Need to convert HTML page with table to JSON

2018-11-27 Thread Keisuke Miyako via 4D_Tech
the web site you mentioned uses this file https://github.com/abdmob/x2js but the real challenge is to cajole HTML code that is not strictly XML 2018/11/28 14:41、Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>のメール: Anyone have some sample code they can share, or point

Need to convert HTML page with table to JSON

2018-11-27 Thread Tim Nevels via 4D_Tech
I have a very simple web page that contains a single table that I’d like to convert to JSON. I can grab the web page with the HTTP Get command. So that’s easy. I found a website that will let me past that web page text and it will created exactly the JSON that I need — http://convertjson.com/h

Re: v13 - Exporting tab delimited

2018-11-27 Thread Douglas von Roeder via 4D_Tech
Chip: Unless you must use tabs, what about CSV? I think that was a big reason why the CSV "standard" created. -- Douglas von Roeder 949-336-2902 On Tue, Nov 27, 2018 at 4:10 PM Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Chip, > > Character code for a Soft Return is 11 > > Randy E

RE: v13 - Exporting tab delimited

2018-11-27 Thread Randy Engle via 4D_Tech
Chip, Character code for a Soft Return is 11 Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip Scheide via 4D_Tech Sent: Tuesday, November 27, 2018 3:51 PM To: benedic...@comcast.net Cc: Chip Scheide <4d_o...@pghrepository.org>; 4d_tech@lists.

Re: v13 - Exporting tab delimited

2018-11-27 Thread Chip Scheide via 4D_Tech
Thomas & Chuck the intent is to create the export file in such a manner that NO user intervention is required to open the file with the embedded returns. changing the end of row marker will work, but then the user(s) need to know that -- and they won't or they won't remember etc -- after all the

Re: v13 - Exporting tab delimited

2018-11-27 Thread Charles Miller via 4D_Tech
You will need to change end of row delimiter to asomething other than a carriage return. Perhaps a tilde. You will need to set up excel as well to use the new character. Just make sure that if you have such a character in any text field you escape it. Regards Chuck On Tue, Nov 27, 2018 at 5:09 P

v13 - Exporting tab delimited

2018-11-27 Thread Chip Scheide via 4D_Tech
I would like to be able to embed a return and/or line feed into column in a tab delimited file (opening with Excel). ex: data data text data with return more data data Excel will give me: Col1Col2Col3 DataDatatext data with more data data I can not se

Re: Create text object

2018-11-27 Thread Chip Scheide via 4D_Tech
well... not exactly programatically - it does require a creating an object (or duplicating an existing one). - You can place a text object anywhere on the form (I am assuming you mean a static text object, like a field/variable label). - Name to object. - set the property 'invisible by default'.

Creating a text object

2018-11-27 Thread Peter Mew via 4D_Tech
Hi I should have said 4D v13.6 Mac Yosemite thanks -pm ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.

Create text object

2018-11-27 Thread Peter Mew via 4D_Tech
Hi Is it possible to, programatically, create an object that consists of text from an element of an array, and place it at a specific location on a form thanks -pm ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com

Re: AreaList Pro version 10.1 released

2018-11-27 Thread Jeffrey Kain via 4D_Tech
Best version of ALP ever. We've been using the final candidate builds in production for a few months now in 32-bit and 64-bit and it's rock solid. > On Nov 27, 2018, at 1:24 PM, Philippe Ganter via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > http://www.e-node.net/alp > http://www.e-node.net/ftp

AreaList Pro version 10.1 released

2018-11-27 Thread Philippe Ganter via 4D_Tech
http://www.e-node.net/alp http://www.e-node.net/ftp/AreaListPro/AreaListPro_ReleaseNotes.pdf AreaList Pro version 10.1 uses a native technology to edit enterable cells. New features also include: - Highly improved redrawing speed - Support of RTL/bidirectional text - Maximum column width - Column

Re: JSON from Google Sheet to Property Object

2018-11-27 Thread Sannyasin Siddhanathaswami via 4D_Tech
Aloha all, I created the method to convert a Google Sheet JSON to a property:value collection of objects. This has the advantage of being able to use all of the collection method (such as query). Here’s the code. //get Google Sheet via JSON and convert to property:value Collection of objects