Re: [mvdbms] Digest for mvdbms@googlegroups.com - 3 updates in 1 topic

[Mark Brown]

Num(X) + 0

I use it for unknown values that must be numeric.

On Tue, Jan 31, 2023, 10:30 <mvd...@googlegroups.com> wrote:

mvd...@googlegroups.com

Google Groups

Topic digest
View all topics

• D3 OCONV that strips SPACES but preserves DECIMAL POINTS - 3 Updates

D3 OCONV that strips SPACES but preserves DECIMAL POINTS

frosty <johntr...@gmail.com>: Jan 31 10:03AM -0800 Is there an output conversion in D3 that will strip out non-numeric characters but not strip out a decimal point?   I want spaces to go away. But I don't want decimal points to go away.   For example, if the data is " 123.45" (not the leading space) I want "123.45".   MCN strips the space but also strips the decimal point, yielding "12345" which is, from what the bean counters tell me, a different number than "123.45" -- go figure.   Maybe I'm just having a Senior Moment©? And the conversion I'm looking for is a thing?

geneb <ge...@deltasoft.com>: Jan 31 10:18AM -0800 On Tue, 31 Jan 2023, frosty wrote:     > I want spaces to go away. But I don't want decimal points to go away.   > For example, if the data is " 123.45" (not the leading space) I want > "123.45".   Try trim().   g.   -- Proud owner of F-15C 80-0007 http://www.f15sim.com - The only one of its kind. http://www.diy-cockpits.org/coll - Go Collimated or Go Home. Some people collect things for a hobby. Geeks collect hobbies.   ScarletDME - The red hot Data Management Environment A Multi-Value database for the masses, not the classes. http://scarlet.deltasoft.com - Get it _today_!

frosty <johntr...@gmail.com>: Jan 31 10:24AM -0800 If I was writing a BASIC program and not a Dictionary definition, I would most certainly do that.   I may wind writing some BASIC to CALL from the DICT. But there's a lot of DICTs to refactor if I go that route.   A mask character conversion that strips spaces but retains decimal points would be a very quick implementation.     On Tuesday, January 31, 2023 at 11:18:58 AM UTC-7 geneb wrote:

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to mvdbms+un...@googlegroups.com.