empty cells

[mambi]

hi everyone,

i have a table with many columns containing empty cells (with null value)  as in the example below :

categories	field1
category 1	sport
category 2	music
category 3	travel
category 4
category 5	games
category 6
category 7	books

for the column field1  i want to keep the blank cells after the loading script 

i can get the result by using : if(isnull(fields),'',fields) as col in the load script but i have many columns  so i don't want to the this test for over 10 fields , is there any way do this automatically (like verbatim for spaces)

thanks

[whiteline]

Hi.

In script you can use NullAsValue field1, field2, ...;

[sujeetsingh]

See this sample please

[kiranmanoharrode · Accepted solution]

Dear Mambi,

try below script;

NullAsValue *;

Test:

Load *Inline [

categories	field1
category 1	sport
category 2	music
category 3	travel
category 4	'  '
category 5	games
category 6	'  '
category 7	books

];

Regards

Kiran Rode

+918976977897

[#5]

if(field1=' ',' ',field1)

[Anonymous]

Hi Mambi,

     please use the LEN Function in place of ISNULL.

like:

        if(LEN(Fields),Fields,' ')  AS COL

it will be work.

Thanks

SHAIK

[#7]

hi

try this

if(len(field1)=0,' ',field1)

Regards

[mambi]

thanks sir,

it's worked for me.