Restricting the subfield output

[#1]

Hi,

I have the following piece of data

Statement : I love singapore

Statement : An Apple.

Now  I am using subfiled to split the string subfield(Statement,' ').

The output i am looking for is

love

Singapore

Apple

i.e., i want remove all the substrings whose length is less than 4.

Please provide your thoughts on how to implement this.

Regards,

Amar

[khadeer]

Hi,

if(len(subfield(Satatement,' ')>=4,subfield(Statement,' '))

Hope it helps you.

Regards,

Khadeer

[#3]

Hi,

See the attachment.

[tresesco]

try this:

Load

if(len(subfield(trim(Satement),' '))>=4,subfield(trim(Statement),' ')) as NewStatement

[#5]

Hi Venugopal,

I am using a personal edition. Kindly post the script here

[#6 · Accepted solution]

Hi,

TestData:
Load  * Inline [
Statement
I love India
I love World
Community is Best
];

FieldList:
Load * where Len(vSubField) >= 4;

Load
SubField(Statement, ' ') as vSubField
Resident TestData;