Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
my requirement is not to load the data(particular row) if a particular field for that row is blank or having blank spaces in it
thanks in advance
You can simply write:
Load * from tablename where len(fieldname)<>0;
Hi,
The script could look like this:
Load field1,
field2,
field3
from ...
where not isnull(field3) and len(trim(field3)) > 0
;
Hi Nishit, you can use the Index() function to look for a character in a string:
Index(FieldName, ' ') // returns the position where it finds the first blank space; returns 0 if there is none
So you can add the where sentece:
Where Index(FieldName, ' ')=0