while loading a CSV file I need to see if a field is a numeric value, it can be -14.00 or 0 or 14.00


the field is defined as A18 during the file read and may contain none numeric characters.


heres what I have tried

  
                         0/05/15            Date:                  Report All       28.17.          d.p 1+                    xxapckrp      
                         1:41:50            Time:                 c.              
    Balance               Amount Open       Amount C Due Date Cur Remark               Invoice              T Ref      Date     Sort Name                 Supplier      
-----------          --- ------------ ------------ - -------- --- -------------------- -------------------- - -------- -------- ------------------------- --------      
 0000000000                      0.88          .88 Y 10/15/15 USD                      109690               V 1012043  09/30/15 MARK                      winc      
 0000000000                    634.32       634.32 Y 10/08/15 USD                      247952               V 1010669  09/23/15 MARK                      winc      

with filter CAST(T1.AMOUNT AS NUMERIC) <= 0 OR CAST[T1.AMOUNT AS NUMERIC) >= 0

the results are the same

This message has been edited. Last edited by: ray_In_Vancouver,

The PATTERN function might help:

PATTERNX/A18 = PATTERN(18,AMOUNT,'A18');
NUMERIC/A1   = IF (PATTERNX LIKE '%A%' OR '%a%' OR '%X%') THEN 'N' ELSE 'Y';