This content has been marked as final.
Show 5 replies
-
Re: How to remove Blank values ?
Peter Rieper May 10, 2017 7:19 AM (in response to Deepika Shinde)are you sure that field is really empty?
syntax should be:
LOAD * FROM ....
WHERE LEN(TRIM(MyField));
Peter
-
Re: How to remove Blank values ?
Deepika Shinde May 10, 2017 7:53 AM (in response to Peter Rieper)Yes Peter,
field is empty.
I tried with Trim() also.
Still blank data is loading
Regards,
Deepika
-
Re: How to remove Blank values ?
Peter Rieper May 10, 2017 8:38 AM (in response to Deepika Shinde)Then please post some sample data.
-
-
-
Re: How to remove Blank values ?
beck bakytbek May 10, 2017 8:40 AM (in response to Deepika Shinde)Hi Deepika,
look at this blogs:
1.https://www.youtube.com/watch?v=pGpdfMpmWoE
2. https://www.youtube.com/watch?v=l20fjOQgbRc
i hope that helps to resolve your issue
Beck
-
Re: How to remove Blank values ?
tsotne shengelia May 10, 2017 10:03 AM (in response to Deepika Shinde)delete (table name)
where isnull(column name )