Search found 3289 matches

by bn
Thu Oct 10, 2019 11:35 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Various ways of matching a line
Replies: 7
Views: 345

Re: Various ways of matching a line

Hi Michael, here is an example to turn your data into an array. It supposes that your data is in a field. I take it as it is as words separated by spaces 1 heather founder 42 mary engineer 3 john intern 2 pat CEO 5 bob accountant on mouseUp local tData, tArray put field 1 into tData put tData into t...
by bn
Wed Oct 02, 2019 10:34 am
Forum: Android Deployment
Topic: Searching in documents folder at Android
Replies: 8
Views: 339

Re: Searching in documents folder at Android

I missed that

Thanks Klaus
by bn
Tue Oct 01, 2019 11:01 pm
Forum: Android Deployment
Topic: Searching in documents folder at Android
Replies: 8
Views: 339

Re: Searching in documents folder at Android

Hi Urosch, the idea is to fill the script local variable when you start your search, i.e on openField on openField if the text of me is "Nach Profilen suchen" then set the textColor of me to "black" put empty into me set the defaultFolder to specialFolderPath("documents") -- do your filling of the s...
by bn
Tue Oct 01, 2019 9:49 pm
Forum: Android Deployment
Topic: Searching in documents folder at Android
Replies: 8
Views: 339

Re: Searching in documents folder at Android

Hi Urosch, one thing I noticed is that you get the content of the document folder everytime when "textchanged" You could reduce this step to a one time step in the openField handler. It uses a script local variable. That is a variable that is accessible by all handler in the same script. It is decla...
by bn
Tue Oct 01, 2019 8:50 pm
Forum: Android Deployment
Topic: Searching in documents folder at Android
Replies: 8
Views: 339

Re: Searching in documents folder at Android

Hi Urosch, filter zwischenSpeicher with "*" & tsearch & "*" works. Your solution did not work because you put your filter into quotes. Everything in quotes is treated as literal. In your case the variable tSearch. It is not a variable anymore but just the word. filter zwischenSpeicher with "*(&tsear...
by bn
Tue Oct 01, 2019 12:47 pm
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

Kaveh, glad it helps. Is this helpful for your project? This does not solve the problem of a cell containg more than one line. But I don't know of a way in livecode to put multiple lines into one cell of a table. I had a look at the code again and there is one remnant line of an earlier attempt in h...
by bn
Tue Oct 01, 2019 12:15 am
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

Hi Kaveh, I found the problem. The first one was a bug I did not catch with only one column. I overwrote rows with row numbers instead of only applying them to the first item only. The second problem was in "four_rows" where you had a "\u" as a literal and it broke my assumption that "\u" is always ...
by bn
Mon Sep 30, 2019 9:18 pm
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

Hi Kaveh, https://docs.google.com/spreadsheets/d/1l7UcSbZW3AzMwXAwQyHV3pBRlVkKPBIm_lDrdx9MXbY/edit?usp=sharing when I open the url in a browser I see 4 columns but only one is retrieved via your retrieval routine. And that one column is the same as before. Could you test this in your copy of "putJas...
by bn
Mon Sep 30, 2019 9:05 pm
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

kaveh1000 wrote:
Mon Sep 30, 2019 9:01 pm
Least I can do for you Bernd!!

https://docs.google.com/spreadsheets/d/ ... sp=sharing
Thanks Kaveh,

but this one also has only one column. Could you add a couple of columns?

Thanks
Bernd
by bn
Mon Sep 30, 2019 8:56 pm
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

Hi Kaveh,

could you put up a Google Sheet with a couple of columns and a couple of rows the way you did the other ones?
I would like to test above stack with more than one column.

Kind regards
Bernd
by bn
Mon Sep 30, 2019 4:02 pm
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

Hi Kaveh, here is a stack that does the whole thing: get the google data clean it, turn json into array, turn array into a table. It uses a regular field with hGrid and vGrid turned no and tabstops set to 100. the url is hardcode in the button. It would be interesting to test this with more than one...
by bn
Mon Sep 30, 2019 9:43 am
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

here is the stack I tested the display of the 16729 variants of XXXX unicode chars. Meaning using 4 "chars/numbers" to code the hex value of the char. The source is: ftp://ftp.unicode.org/Public/UNIDATA/UnicodeData.txt jasonUnicode.livecode.zip Please be a bit patient when displaying the chars. When...
by bn
Mon Sep 30, 2019 9:05 am
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

@Thierry: Bonjour Monsieur :) @Kaveh I tested numToCodepoint with all 16729 variants of XXXX - unicode. That seems to work, some characters are not displayed but apart from ASCII 0 to 31 which are not displaying anyways that was probably a font problem. I tested in your stack you posted above with y...
by bn
Sun Sep 29, 2019 10:57 pm
Forum: Talking LiveCode
Topic: Getting JSON from Google Sheets with unicode chars
Replies: 23
Views: 823

Re: Getting JSON from Google Sheets with unicode chars

hexadecimal number assuming all start with \u and are 4 chars That might be an unwise assumption: this is json format for whatever: https://www.json.org I take this as meaning they always have escape + u + 4 chars '\' escape escape 'u' hex hex hex hex hex: digit 'A' . 'F' 'a' . 'f' from https://www...

Go to advanced search