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@lists.runrev.com> wrote: > > Hi Panos, > >> Am 09.09.2022 um 12:27 schrieb panagiotis m via use-livecode >> <use-livecode@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@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 > kl...@major-k.de > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
