Re: LC converts phone number to scientific notation

2022-09-11 Thread kee nethery via use-livecode
I had the same problem with long integer numbers being imported into a spreadsheet. My solution was to append “a” to the numbers before they got imported into the spreadsheet. Kee Nethery > On Sep 9, 2022, at 3:00 AM, Klaus major-k via use-livecode > wrote: > > Hi friends, > > I have a

Re: LC converts phone number to scientific notation

2022-09-10 Thread Klaus major-k via use-livecode
Hi Mark, > Am 10.09.2022 um 08:55 schrieb Mark Waddingham via use-livecode > : > > On 2022-09-09 11:40, Klaus major-k via use-livecode wrote: >> Hi Panos, >>> Am 09.09.2022 um 12:27 schrieb panagiotis m via use-livecode >>> : >>> Hello Klaus, >>> I guess what happens here is that if you fetch

Re: LC converts phone number to scientific notation

2022-09-10 Thread Mark Waddingham via use-livecode
On 2022-09-09 11:40, Klaus major-k via use-livecode wrote: Hi Panos, Am 09.09.2022 um 12:27 schrieb panagiotis m via use-livecode : Hello Klaus, I guess what happens here is that if you fetch item X of line Y and use it directly, LC treats it as a number and displays it in scientific

Re: LC converts phone number to scientific notation

2022-09-09 Thread Alex Tweedly via use-livecode
No, not all are 2-digits.   USA is one digit, many are 3 digits, none are (yet) 4 digits. A phone number would have a leading zero in many countries; usually indicating it's a non-local number (kind of similar to the leading 1- in long distance in the US, e.g. 1-800-555-1212). In the UK,

Re: LC converts phone number to scientific notation

2022-09-09 Thread Alex Tweedly via use-livecode
No, I just need to learn to not type emails on my iPhone :-) I do it so rarely, I forget to be careful about autocorrect. On 09/09/2022 16:39, Bob Sneidar via use-livecode wrote: Someone needs to debug their emails. ;-) Bob S On Sep 9, 2022, at 06:32 , Klaus major-k via use-livecode

Re: LC converts phone number to scientific notation

2022-09-09 Thread Bob Sneidar via use-livecode
OK As it turns out, it is nearly impossible to format a series of digits to an international format, separating the different parts by delimiters like - and (). Refer to web link for details. https://www.tipard.com/mobile/international-phone-number-format.html In short, the country code can be

Re: LC converts phone number to scientific notation

2022-09-09 Thread Klaus major-k via use-livecode
Hi Bob, > Am 09.09.2022 um 17:38 schrieb Bob Sneidar via use-livecode > : > > I have a function called formatPhone() I can modify it to support > international notation and send it to you. thank you, will then store it for future use. > Are all country codes 2 digits? And why would a phone

Re: LC converts phone number to scientific notation

2022-09-09 Thread Bob Sneidar via use-livecode
Someone needs to debug their emails. ;-) Bob S On Sep 9, 2022, at 06:32 , Klaus major-k via use-livecode mailto:use-livecode@lists.runrev.com>> wrote: Put (“” & item 9 of globe) onto item 6 of tnewline ___ use-livecode mailing list

Re: LC converts phone number to scientific notation

2022-09-09 Thread Bob Sneidar via use-livecode
I have a function called formatPhone() I can modify it to support international notation and send it to you. Are all country codes 2 digits? And why would a phone number have a leading 0? Bob S > On Sep 9, 2022, at 03:00 , Klaus major-k via use-livecode > wrote: > > Hi friends, > > I

Re: LC converts phone number to scientific notation

2022-09-09 Thread Klaus major-k via use-livecode
Hi Alex, > Am 09.09.2022 um 15:18 schrieb Alex Tweedly via use-livecode > : > > How about > > Put (“” & item 9 of globe) onto item 6 of tnewline or this way. :-) > Alex > > Sent from my iPhone > >> On 9 Sep 2022, at 11:40, Klaus major-k via use-livecode >> wrote: >> >> Hi Panos, >>

Re: LC converts phone number to scientific notation

2022-09-09 Thread Alex Tweedly via use-livecode
How about Put (“” & item 9 of globe) onto item 6 of tnewline Alex Sent from my iPhone > On 9 Sep 2022, at 11:40, Klaus major-k via use-livecode > wrote: > > Hi Panos, > >> Am 09.09.2022 um 12:27 schrieb panagiotis m via use-livecode >> : >> >> Hello Klaus, >> >> I guess what happens

Re: LC converts phone number to scientific notation

2022-09-09 Thread Klaus major-k via use-livecode
Hi Panos, > Am 09.09.2022 um 12:27 schrieb panagiotis m via use-livecode > : > > Hello Klaus, > > I guess what happens here is that if you fetch item X of line Y and use it > directly, LC treats it as a number and displays it in scientific notation. obviously! > On the contrary, if you first

Re: LC converts phone number to scientific notation

2022-09-09 Thread panagiotis m via use-livecode
Hello Klaus, I guess what happens here is that if you fetch item X of line Y and use it directly, LC treats it as a number and displays it in scientific notation. On the contrary, if you first put item X of line Y into a variable, then the variable is treated as text, so it is not converted.

LC converts phone number to scientific notation

2022-09-09 Thread Klaus major-k via use-livecode
Hi friends, I have a very strange problem, but also found a workaround for it. I first convert an 8 MB CSV file with 6 lines to TAB delimited data, then I parse the file and just extract some columns from the 6 lines to display in a field. E.g. the column "number dialled", which