ww wrote: > I have data stored with both decimal and hyphens in the field for > example 123.234-123. I want to create a DICT item that will strip the > decimals and hyphens. I tried most of the obvious convertions with the > following providing the desired result however, it strips the hyphens > but truncates the data when it finds a decimal. I tried returning only > numerics etc. Any help would be appreciated. The '39' on line 8 > references attr 39 of the data file. > Seems others have answered your question again, but perhaps you are better reviewing the data storage! Data fields in jBASE should NOT be stored with embedded '.' in them unless you have some kind of arbitrary precision floating point going on (which I doubt you do). Numerics should be stored as scaled integers. Also, the delimiter @AM is what you use for different fields, not '.' or '-'; if you are having problems with conversions it is usually because you are trying to put square pegs in round holes.
Jim --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
