Where condition with delimiter

[remo0017]

Hi Everyone,

How can i put a where condition in the load statement to pull out all the records between the delimiter '/'

Example:

/AAAAA/BBBBB/

/CCCC/DDDDD/

/EEEE/FFFFFF/

/GGGG/HHHHH/

Is there anything like /*/*/ something that can work ? which can pull out all the records irrespective what string lies between the delimiters ?

Something like

LOAD

*

from <filename>

where field1='/*/*/' or field1='/*/*/*/*/';

* pulling all records irrespective of which string is between the delimiters.

Thanks very much

[remo0017]

Nopes that doesn't work too

[remo0017]

it gives all

/aaa/bbb/

/aaa/bbb/ccc/

/aaa/bbb/ccc/ddd/

/kkk/hhh/

I want to see only

/kkk/hhh/

/aaa/bbb/

[settu_periasamy]

May be try like this.

LOAD * Where Test like '/*/*/' and SubStringCount(Test,'/')=3;

LOAD * INLINE [
Test
/aaa/bbb/
/aaa/bbb/ccc/
/aaa/bbb/ccc/ddd/
/kkk/hhh/
];

[shiveshsingh]

Hi

Please try this

T:

load * inline

[Field

/AAAAA/BBBBB/

/CCCC/DDDDD/

/EEEE/FFFFFF/

/GGGG/HHHHH/];

NoConcatenate

W:

load PurgeChar(Field,'/') as Field1

Resident T;

[marcus_sommer]

You could use wildmatch() for it:

LOAD

*

from <filename>

where wildmatch(field1, '/*/*/', '/*/*/*/*/');

- Marcus