Field name with space issue

[#1]

Hi guys,

I am writing this script

NoConcatenate

          [$(vCustomFieldName)]:

          LOAD TxnID, CustomFieldValue as [$(vCustomFieldName)]

          From [$(Path)$(_CompFileName)_v_CustomFieldsForTxnNames.qvd]

          (qvd)

          Where CustomFieldName = '[$(vCustomFieldName)]';

It works when the value of vCustomFieldName does not have any space in between. when it has space then the

"WHERE" clause does not work.

Can you plz suggest me that what should be right statement of hwere caluse when we spaces in value of vCustomFieldName.

Regards,

Saurabh

[hic · Accepted solution]

You have one pair of quotes to much. Use the following instead:

Where CustomFieldName = '$(vCustomFieldName)';

HIC