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 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 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


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 item X of line Y and use it
>>> directly, LC treats it as a number and displays it in scientific notation.
>> obviously!
> 
> Panos isn't correct here...
> None of the code you posted would cause a string to be converted to a number 
> - the engine only does that when you pass a string to something which expects 
> a number (and returns one).
> Specifically the 'item' chunk is a string chunk - it just manipulates fetches 
> or stores sequences of characters into other sequences of characters.
> So the problem you are having is elsewhere - and not in the code which 
> reorders the strings of the lines you have imported.
> It is either happening when you import the data, or when you are displaying 
> it.

Well, the imported (dropped) file does not contain these strings then I am only
setting the text of a field to the collected lines (tNewLine) after the repeat 
loop:
...
put item 9 of tLine into item 6 of tNewLine
...

> Indeed, LCS doesn't use scientific notation when converting numbers to 
> strings implicitly - you need to use `format()` to get numbers in that string 
> form.

Hm, the debugger also has this problem and the bug does not seem to be fixed 
yet:



OK, anyway, do you have a hint on how to debug this with my 6 lines file?
I checked the "item 9" (see above) and even "item 6 of tNewLine" after the line 
above for scientific notation, 
no dice, I can only see this behavior in the field after I filled in the new 
data?

Will keep on exploring...

> However, LCB *does* use scientific format when converting numbers to strings 
> (currently at least - we've got an item on the todo list to improve that 
> behavior). For example, the variable viewer in the SE is a treeview widget, 
> so if a variable holds a number that will display in scientific notation if 
> it has above a certain number of significant digits.

Thanks for chiming in!

> Warmest Regards,
> 
> Mark.
> 
> -- 
> Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
> LiveCode: Everyone can create apps

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


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 
notation.


obviously!


Panos isn't correct here...

None of the code you posted would cause a string to be converted to a 
number - the engine only does that when you pass a string to something 
which expects a number (and returns one).


Specifically the 'item' chunk is a string chunk - it just manipulates 
fetches or stores sequences of characters into other sequences of 
characters.


So the problem you are having is elsewhere - and not in the code which 
reorders the strings of the lines you have imported.


It is either happening when you import the data, or when you are 
displaying it.


Indeed, LCS doesn't use scientific notation when converting numbers to 
strings implicitly - you need to use `format()` to get numbers in that 
string form.


However, LCB *does* use scientific format when converting numbers to 
strings (currently at least - we've got an item on the todo list to 
improve that behavior). For example, the variable viewer in the SE is a 
treeview widget, so if a variable holds a number that will display in 
scientific notation if it has above a certain number of significant 
digits.


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps

___
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


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, numbers are, 
for example, 01x1 ddd , but a local number will never begin with a 0.


Alex.

On 09/09/2022 16:38, Bob Sneidar via use-livecode wrote:

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 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 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


___
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


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 
mailto:use-livecode@lists.runrev.com>> wrote:

Put (“” & item 9 of globe) onto item 6 of tnewline


___
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


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 1 to 3 digits, the dial out code *should* be 
00 but some countries don't comply with the standard, and use a different code, 
which can be 2 to 3 digits, etc.

To internationalize formatPhone() I would need a database of each country and 
how they format their phone numbers, and boo on that idea.

Here is my formatPhone() code as it stands for US and Canada. (I think it is 
included in the Master Library as well.) If the phone number is not not 7 or 10 
digits after extracting the extension, then it returns the original value.

FUNCTION formatPhone thePhoneNumber, theFormat
   -- text
   -- mid
   IF theFormat is empty THEN
  put "classic" into theFormat
   END IF

   IF thePhoneNumber is empty THEN
  return thePhoneNumber
   END IF

   if "ext" is in thePhoneNumber then
  put offset("ext", thePhoneNumber) into tChar
  put char tChar to -1 of thePhoneNumber into theExtension
  put char 1 to tChar -1 of thePhoneNumber into thePhoneNumber
   else if "x" is in thePhoneNumber then
  put offset("x", thePhoneNumber) into tChar
  put char tChar to -1 of thePhoneNumber into theExtension
  put char 1 to tChar -1 of thePhoneNumber into thePhoneNumber
   end if

   REPEAT WITH i = 1 to the number of chars of thePhoneNumber
  IF char i of thePhoneNumber is a number THEN
 put char i of thePhoneNumber AFTER theNewValue
  END IF
   END REPEAT

   put the length of theNewValue into theLength

   IF theLength is not among the items of "7,10" THEN
  return thePhoneNumber && theExtension
  exit formatPhone
   END IF

   put "-" BEFORE char -4 of theNewValue

   IF theLength is 10 THEN
  IF theFormat is "classic" THEN
 put ") " AFTER char 3 of theNewValue
 put "(" BEFORE theNewValue
  ELSE
 put "-" AFTER char 3 of theNewValue
  END IF
   END IF

   IF theExtension is not empty THEN put " " & theExtension AFTER theNewValue
   return theNewValue
END formatPhone

Bob S


On Sep 9, 2022, at 08:51 , Klaus major-k via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

Hi Bob,

Am 09.09.2022 um 17:38 schrieb Bob Sneidar via use-livecode 
mailto:use-livecode@lists.runrev.com>>:

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.

___
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


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 number have a leading 
> 0? 

I don't have the slightest idea, I am just processing the CSV files, 
wherever they come from and whatever they may contain... 8-)

> Bob S

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


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
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


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 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 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


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,
>> 
>>> 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 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

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


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 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 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 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


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 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 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 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


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.

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 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 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


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 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