search string and create a new field

[sivarajs]

Hi,

I have a string like 'ABC CDE EFG HIJ'

From this i need to take first letter of each substring e.g., 'ABC CDE EFG HIJ'-ACEH

I tried to identify space then to fetch the particular string but it didn't work and

also i used subfield like left(subfield('ABC CDE EFG HIJ',' '),1) i got first letter but when concat its not giving correct result

Any idea...

Regards

Sivaraj

[Anonymous]

Hi Sivaraj,

This seems to work:

Load

          concat(Field) as Result;

Load

left(subfield('ABC CDE EFG HIJ',' '),1) as Field

AutoGenerate 1;

[sivarajs]

I tried but its not working

[Anonymous]

It gives me a string ACEH, isn't this what you're looking for?

[sivarajs]

This is what i want, but is not giving for me

Can you explin the way you have tried?