Re: how to format text for copy-pasting as a spreadsheet table

Paul, thank you! And no offense taken. I work so intermittenly with LC that whenever I take up a new project I feel like a beginner, having to recall things I once knew. I'm very grateful to have this list as a resource. -- Nicolas Cueto On 9 February 2018 at 10:42, Paul Hibbert via use-livecod

Re: how to format text for copy-pasting as a spreadsheet table

Nicolas, please don’t give up just yet, I don’t think this is too difficult. I’ve posted a sample in the user forum [ http://forums.livecode.com/viewtopic.php?f=7&t=30584 ] that I think may work for what you describe. The example I tried u

Re: representing this character from a pdf

On Thu, Feb 8, 2018 at 1:08 PM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > > That is the actual ASCII 63 wingdings character. He wants the right arrow, something not even IN the wingdings character set (at least on Mac). > I went into LibreOffice (where it won't paste th

Re: how to format text for copy-pasting as a spreadsheet table

Correct that my code just enables a paste into a non-plain text app without extra lines (but colors and other formatting is retained). Once the plain text bug fix code is released, an intermediate step will not be needed to clean formatting as long as plain text is what was placed on the clipboard

Re: how to format text for copy-pasting as a spreadsheet table

Craig wrote: > I should be able to paste directly into any spreadsheet. One would think it should, but long experience copy-pasting from/to LC confirms "directly" just doesn't work. An intermediary step, such as a text editor app, is always needed. Brian wrote: > If you are talking about gettin

Re: representing this character from a pdf

> Bob S. wrote > Better. Not the exact one tho. The dingbat one is thicker. I didn't name a fontsize. The one you get in the rtftext (in your case fs20/2=10) is dependent on the scale of the pdf when you copied the char. So the size should be related to the surronding textsize both in the pdf a

Re: representing this character from a pdf

Don't ask me what a curvong cat looks like. I meant CurvING. ;-) Bob S > On Feb 8, 2018, at 14:29 , Bob Sneidar via use-livecode > wrote: > > I get a square box with a question mark. If I paste the result of this in > Word, I get what looks like a right curvong cat claw. :-) > > Bob S ___

Re: representing this character from a pdf

I get a square box with a question mark. If I paste the result of this in Word, I get what looks like a right curvong cat claw. :-) Bob S > On Feb 8, 2018, at 14:21 , hh via use-livecode > wrote: > >> Bob S. wrote: >> {\rtf1\mac {\fonttbl{\f0\fnil \fcharset77 Wingdings;}{\f1\fnil \fcharset77

Re: representing this character from a pdf

Better. Not the exact one tho. The dingbat one is thicker. Honestly if all he needs is an icon, I always just zoom in 2x or 4x, get a screen shot of the character, and paste it into my favorite png editor. Bingo. Hi res graphic. Bob S > On Feb 8, 2018, at 13:47 , BNig via use-livecode > wro

Re: representing this character from a pdf

> Bob S. wrote: > {\rtf1\mac {\fonttbl{\f0\fnil \fcharset77 Wingdings;}{\f1\fnil \fcharset77 > (Message);}} > {\colortbl;\red0\green0\blue0;} > \pard \f0 \fs20 \cf1 \u61672?\f1 \fs22 \'00} So, on Mac it is numToCodepoint(61672) in font "Wingdings" ___ u

Re: representing this character from a pdf

maybe he likes put numToCodepoint(0x2794) HEAVY WIDE-HEADED RIGHTWARDS ARROW' (U+2794) Kind regards Bernd -- Sent from: http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html ___ use-livecode mailing list use-livecode@lists.ru

Re: representing this character from a pdf

That is the actual ASCII 63 wingdings character. He wants the right arrow, something not even IN the wingdings character set (at least on Mac). Bob S > On Feb 8, 2018, at 12:04 , BNig via use-livecode > wrote: > > would this do? > > put numToCodepoint(0x270D) > > from > http://www.alanw

Re: representing this character from a pdf

put the clipboardData ["htmltext"] & cr & cr & the clipboardData["rtftext"] produces: � {\rtf1\mac {\fonttbl{\f0\fnil \fcharset77 Wingdings;}{\f1\fnil \fcharset77 (Message);}} {\colortbl;\red0\green0\blue0;} \pard \f0 \fs20 \cf1 \u61672?\f1 \fs22 \'00 } > On Feb 8, 2018, at 12:01 , Bob Snei

Re: representing this character from a pdf

These government pdfs are nasty in general, and made with something sloppy. When I try pasting it into LibreOffice, I get nothing at al! -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ use-livecode mailing list use-livecode@lists.runrev.com Please vi

Re: representing this character from a pdf

would this do? put numToCodepoint(0x270D) from http://www.alanwood.net/demos/wingdings.html Kind regards Bernd -- Sent from: http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html ___ use-livecode mailing list use-livecode@li

Re: representing this character from a pdf

I have checked this every which way. I converted the PDF to Word. Word says it's the wingdings font. LC tells me it is ascii 63. Either LC is lying, or else this character is getting converted somhow. Bob S > On Feb 8, 2018, at 11:49 , Bob Sneidar via use-livecode > wrote: > > This is quit

Re: representing this character from a pdf

This is quite odd. On my Mac, when I type a question mark with the WingDings font in Word I do NOT get a forward error I get something completely unrelated. If I copy it, then in the LC message box I enter put charToNum(the clipboarddata["text"]) I get 63, which is the character for question mar

Re: representing this character from a pdf

It's Wingdings ASCII 63 size 10pt. Bob S > On Feb 8, 2018, at 11:35 , Dr. Hawkins via use-livecode > wrote: > > For the form at http://www.uscourts.gov/file/19456/download, I am trying to > replicate the fat little arrow to the right of question 1 (and so forth)> > > When I paste into live

representing this character from a pdf

For the form at http://www.uscourts.gov/file/19456/download, I am trying to replicate the fat little arrow to the right of question 1 (and so forth)> When I paste into live code, though, it doesn't work, orator gets converted. Does anyone know how to to keep this character in a livecode field? -

Re: Execute multiple MySQL commands

On Thu, Feb 8, 2018 at 8:20 AM, Ludovic THEBAULT via use-livecode < use-livecode@lists.runrev.com> wrote: > > > Just for infos, multiple statements works with SQLite but not with Mysql. They also work with postgreSQL. This was a major factor in my switching. I think mySQL now has rollback, but

Re: Execute multiple MySQL commands

NP. From the dictionary statement about *some* database systems supporting multiple SQL statements, I gather that *some* do not, so they have to take the lowest common denominator approach. Bob S > On Feb 8, 2018, at 08:07 , Ludovic THEBAULT via use-livecode > wrote: > >> Le 8 févr. 2018 à

Re: Execute multiple MySQL commands

> Le 8 févr. 2018 à 16:48, Bob Sneidar via use-livecode > a écrit : > > I know where! The Dictionary: > > > SQLStatement string > A string in Structured Query Language. (Do not include a semicolon at the end > of the SQLStatement.) >Note: Some database systems, such as Oracle, are > capa

Re: Execute multiple MySQL commands

> Le 8 févr. 2018 à 16:34, Bob Sneidar via use-livecode > a écrit : > > I thought I read somewhere that the LC API does not support multiple > statements? > > Bob S Ok, thanks ! ___ use-livecode mailing list use-livecode@lists.runrev.com Please v

Re: how to format text for copy-pasting as a spreadsheet table

See my code here: https://github.com/bwmilby/lc-misc/blob/master/ClipboardHelper/clipboardhelper.livecodescript "updateClipboardHtmlText" will take the HTMLText on the clipboard (which gives the extra lines) and replace the tags so it doesn't do that. I'm not sure if this will do what you want tho

Re: Execute multiple MySQL commands

I know where! The Dictionary: SQLStatementstring A string in Structured Query Language. (Do not include a semicolon at the end of the SQLStatement.) >Note: Some database systems, such as Oracle, are capable of handling a multiple-line SQL statement. Bob S > On Feb 8, 2018, at 07:34 , B

Re: how to format text for copy-pasting as a spreadsheet table

You can. You will just get 2 returns instead of the one when you paste it anywhere but in an app that knows how to handle the contents of that clipboard. Bob S > On Feb 8, 2018, at 06:40 , dunbarx via use-livecode > wrote: > > put "cat" & tab & "dog" & tab & "eel" & return & "red" & tab & "

Re: Execute multiple MySQL commands

I thought I read somewhere that the LC API does not support multiple statements? Bob S > On Feb 8, 2018, at 02:24 , Ludovic THEBAULT via use-livecode > wrote: > > Hello, > > I’ve an « syntax error » as result if i want to execute multiple MySQL > commands, even with transactions. > > It

Re: how to format text for copy-pasting as a spreadsheet table

I have code that can bypass step 1 (8.1.9 probably can too since I think that bug fix is in there). If you are talking about getting an actual table, then it is possible but may require some code to pull off. I would need to do some testing to figure out what is on the clipboard after the spreadsh

[ANN] Release 8.1.9

Dear List Members, We are pleased to announce the release of LiveCode 8.1.9 Stable. By "Stable", we mean that no reported regressions have been introduced in 8.1.9, compared to the previous Stable release. LiveCode 8.1.9 contains more than 25 extra bug fixes and new features, compared to LiveCode

Re: how to format text for copy-pasting as a spreadsheet table

Hi. Not sure I understand. If I make a list: put "cat" & tab & "dog" & tab & "eel" & return & "red" & tab & "blue" & tab & "yellow" into myList set the clipBoardData to myList I should be able to paste directly into any spreadsheet. There is a thread that describes an issue pasting into google

Sync with Google Contacts, iCloud or Apple Contacts

I am using Mac OS X. I have my contacts synced between different applications: - Google Contacts - Apple Contacts - FullContact - iCloud - BusyContacts All works nicely and as far as I can see all changes are saved and synced, including thumbnail photos. Now I am looking for the f

Execute multiple MySQL commands

Hello, I’ve an « syntax error » as result if i want to execute multiple MySQL commands, even with transactions. It is normal ? If i execute one command at time, it’s work. Thanks ! Here a sample script : revExecuteSQL tDatabaseID,"BEGIN TRANSACTION » put "INSERT INTO savemyTable (column1)