The imported file is always a string and the part I need is always a substring that looks like "123456.1234567890" The decimal separator is always a period The num function needs to work on systems that have either the period or the comma, as the native decimal separator thanks -pm
On Tue, Dec 12, 2017 at 10:19 PM, Charles Miller via 4D_Tech < [email protected]> wrote: > If this is always a long why is the striking XXXX.XX or XXXX,XX > It might be simpler but I would first doa substrinmg from 1 to position of > either , or . and then a num on that. > You will have to identify what system you are on and what localization is > set to and then understand what localization created text file for import > > > Regards > > Chuck > > On Tue, Dec 12, 2017 at 4:24 PM, Peter Mew via 4D_Tech < > [email protected] > > wrote: > > > Hi > > I thought I had this understood, but aparrently not. > > Im Importing some numbers from a file as strings.The Numbers have a > period > > as decimal point. > > Because they are long decimal numbers and I need to do some calculations > I > > convert them to longints with NUM() > > everything works fine on a UK system that has its decimal point as a > period > > When I run on a German system that has its a comma as its decimal point > the > > conversion screws up > > So I tried using NUM(string;".") as the conversion (I thought, to force > the > > Decimal point to be a period) > > but this seems to make no difference as the conversion, is still > sccrewed > > up. > > Could Someone point me in the direction of what I've misunderstood. > > Thanks > > -pm > > Im testing this by changing the localisation on the mac to German, and > > comma as the decimal point. > > Mac OS 10.10.5 4D v13.6 > > ********************************************************************** > > 4D Internet Users Group (4D iNUG) > > FAQ: http://lists.4d.com/faqnug.html > > Archive: http://lists.4d.com/archives.html > > Options: http://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:[email protected] > > ********************************************************************** > > > > > -- > ------------------------------------------------------------ > ----------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Server connectivity > http://www.informed-solutions.com > ------------------------------------------------------------ > ----------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
