QS- Blank Value

Karahs — Mon, 02 May 2016 12:25:30 GMT

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

Re: QS- Blank Value

sunny_talwar — Mon, 02 May 2016 12:27:24 GMT

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 = ' '

topic Re: QS- Blank Value in App Development

QS- Blank Value

Re: QS- Blank Value