Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
So my question is i have hightlighted some words in the below code, i want to print the blank spaces count. I have blank spaces in my excel n want to remove their count but not getting their count. Am i using the right way to do so?
[Sheet1$]:
LOAD
[DOCUMENT NO],
[DOCUMENT DATE],
[DOCUMENT TYPE],
[DOCUMENT STATE],
[ACTIVITY DATE],
[FILE FORMAT],
[CLIENT CODE],
[CLIENT NAME],
[CLIENT EMAIL],
[ALT EMAIL],
[BCC EMAIL],
[LOGIN USERNAME],
[SOURCE FILE],
[EXCHANGE],
[IntDmatLogID],
[ClientType],
if(BO_Reason='General Bounce'or BO_Reason=' ' or BO_Reason='Soft Bounce - General','Soft Bounce','Hard Bounce') as dd,
[BO_Reason]
FROM []
(biff, embedded labels, table is Sheet1$);
Table2:
Load*Inline
[
ClientType,ClientTypeNew
1,'ECN'
2,'Non-ECN'
];
Table3:
Load*Inline
[
BO_Reason,Bounce_Category
'General Bounce','Soft Bounce'
' ','Soft Bounce'
'Hard Bounce','Hard Bounce'
'Soft Bounce - General','Soft Bounce'
Thanks& Regards,
Kshitija
Don't see where are you doing the count? Can you elaborate a little please
UPDATE: To handle blank space, I would usually use Len(Trim(BO_Reason)) = 0 as the condition instead of BO_Reason = ' '