help in script

[#1]

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

[#2 · Accepted solution]

You can simply write:

Load * from tablename where len(fieldname)<>0;

[#3]

Hi,

The script could look like this:

Load field1,

field2,

field3

from ...

where not isnull(field3) and len(trim(field3)) > 0

;

[rubenmarin]

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