Solved

how to handle empty string like coliumns=" " i want to insert mysqldb incolumn int type empty string means as Null but it shows error .

below is my error

I want to write these type columns (columns=””)to NULL IN mysqldb

Best answer by Bikram

@deepikamani007

can you please try to use the below code in expression evaluator and check if it works for you.

${str:isNullOrEmpty(record:value("/emailid"))?NULL:record:value("/emailid")}

Thanks & Regards

Bikram_

Did this topic help you find an answer to your question?

+1

can you please try to use the below code in expression evaluator and check if it works for you.

${str:isNullOrEmpty(record:value("/emailid"))?NULL:record:value("/emailid")}

Thanks & Regards

Bikram_

Sign up