Issue using ] in a variable

Wed, 03 Oct 2012 16:08:58 GMT

Hi,

I am trying to make the following code work but it errors out with error stating Garbage at the end of line. Please advise:

Let z=']';

test:

load * inline [zField

'$(z)'];

Re: Issue using ] in a variable

MayilVahanan — Wed, 03 Oct 2012 16:19:14 GMT

Try like this

Let z=']';

Tst:

Load * Inline

[

Col1,Col2,Col3

RO_0001,S1,4/15/2010

RO_0001,S2,3/19/2012

RO_0001,S2,1/10/2011

RO_0002,S2,3/25/2010

RO_0002,S2,8/8/2012

RO_0002,S1,10/10/2019

RO_0003,S1,12/12/2009

RO_0003,S2,10/01/2012

RO_0003,S2,06/05/2011

RO_0003,S2,05/05/2009

$(z) Where Col2='S2';

Hope it helps