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
