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