LC converts phone number to scientific notation

[Alex Tweedly]

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 <use-livecode at lists.runrev.com> wrote:
> 
> Hi Panos,
> 
>> Am 09.09.2022 um 12:27 schrieb panagiotis m via use-livecode <use-livecode at lists.runrev.com>:
>> 
>> 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 put item X of line Y into a variable, then
>> the variable is treated as text, so it is not converted.
> 
> Yo, that's why my workaround erm. works. :-)
> Thank you for the explanation!
> 
>> Kind regards,
>> Panos
>> --
>> 
>>> On Fri, 9 Sept 2022 at 13:01, Klaus major-k via use-livecode <
>>> use-livecode at lists.runrev.com> wrote:
>>> 
>>> Hi friends,
>>> 
>>> I have a very strange problem, but also found a workaround for it.
>>> 
>>> I first convert an 8 MB CSV file with 60000 lines to TAB delimited data,
>>> then I parse the file
>>> and just extract some columns from the 60000 lines to display in a field.
>>> E.g. the column "number dialled", which contains phone number like
>>> -> 447973100123
>>> 
>>> The CSV files are definitively correct but I found that in the resulting
>>> field some of these numbers
>>> appear in scientific notation
>>> -> 4.47888E+11
>>> 
>>> This does not happen with phone numbers with a leading ZERO: like
>>> -> 07557162491
>>> So maybe this a small hint?
>>> 
>>> However I do not even touch these items I just use:
>>> ...
>>> put item 9 of tLine into item 6 of tNewLine
>>> ## tLine is the line from the CSV and tNewLine is for the data in the
>>> display field.
>>> ...
>>> 
>>> My simple workaround, no idea why, but it obviously works:
>>> ...
>>> put item 9 of tLine into ttt
>>> put ttt into item 6 of tNewLine
>>> ...
>>> This avoids the scientific notation, what the hell is going on here?
>>> Any hints welcome.
>> 
> 
> Best
> 
> Klaus
> 
> --
> Klaus Major
> https://www.major-k.de
> https://www.major-k.de/bass
> klaus at major-k.de
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode