Conversion of NULL value in an array

[Durairaj]

Hi all,

I have an array with the combination of alphanumerical and NULL values.

My requirement is avoid the the NULL values in this array. I have tried with CONVERT function but it's not working.

Can anyone help me with this?

For example: 

ARRAY.TEST = 'FX1000':@FM:'NULL':@FM:'FX2000':@FM:'NULL':@FM:'FX3000'

Thanks & Regards,

Durairaj. N

[Mark Hogden]

NAMC = DCOUNT(ARRAY.TEST,@FM)

FOR N = NAMC TO 1 STEP -1

   IF ARRAY.TEST<N> = “” THEN DEL ARRAY.TEST<N>

NEXT N

 

Or

 

CHANGE @FM:@FM TO @FM IN ARRAY.TEST  and then check for first and last null values.

--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[Daniel Klein]

ARRAY.TEST = TRIM(ARRAY.TEST,@FM)

Dan

[Kevin Powick]

On Tuesday, 13 March 2012 17:37:41 UTC-4, comp.lang.smalltalk wrote:

ARRAY.TEST = TRIM(ARRAY.TEST,@FM)

I believe that will only remove the first occurrence of a single FM from the array.  Not what the OP wants at all. 

Considering that I suppose it's possible to have multiple back-to-back nulls in the array, the OP could opt for Mark Hogden's first, reverse loop solution, or save a few cycles and just process the array with the Nulls included, but checking for their existence along the  way.

MAXX = DCOUNT(TEST.ARRAY,@FM)

FOR NDX = 1 TO MAXX

   IF TEST.ARRAY<NDX> # "" THEN

      ...STATEMENTS

   END

NEXT NDX

--

Kevin Powick

--

Kevin Powick

[Durairaj]

Thanks to all. 

TRIM function is working fine.

[FAISAL FAYYAZ]

Hi,

Try this

ARRAY.TEST = TRIM(ARRAY.TEST,'','D')

Regards,

Faisal

--

[Kevin Powick]

On Wednesday, 14 March 2012 03:37:07 UTC-4, Muhammad Faisal wrote:

Hi,

Try this

ARRAY.TEST = TRIM(ARRAY.TEST,'','D')

Not only does that not remove null attribute values, it also has the, possibly undesirable,  side-effect of removing leading, trailing and redundant spaces from the entire array, including non-null attributes.

--

Kevin Powick 

[Kevin Powick]

On Tuesday, 13 March 2012 17:37:41 UTC-4, comp.lang.smalltalk wrote:

ARRAY.TEST = TRIM(ARRAY.TEST,@FM)

Dan

Dan,

Your answer is correct.  Sorry for stating otherwise.

I mistakenly though that for using TRIM to remove leading, trailing, and redundant characters other than spaces, one had to include the 'R' parameter.  TRIM(ARRAY,@FM,'R').  It yields the same result, and I guess is the default behaviour when 'R" is not included.

--

Kevin Powick 

[zakihy...@gmail.com]

Sent from my BlackBerry® smartphone from Uganda Telecom

---

From: Kevin Powick <kpo...@gmail.com>

Sender: jb...@googlegroups.com

Date: Wed, 14 Mar 2012 07:10:01 -0700 (PDT)

To: <jb...@googlegroups.com>

ReplyTo: jb...@googlegroups.com

Subject: Re: Conversion of NULL value in an array

--