ARRAY.TEST = TRIM(ARRAY.TEST,@FM) Dan
On Tue, Mar 13, 2012 at 11:26 AM, Mark Hogden <[email protected]> wrote: > 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.**** > > **** > > ** ** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On Behalf > Of *Durairaj > *Sent:* Monday, March 12, 2012 10:01 PM > *To:* [email protected] > *Subject:* Conversion of NULL value in an array**** > > ** ** > > 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**** > > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > 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**** > > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > 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 > -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. 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
