How to trim column value

[yadav_anil782]

Dear Comunity,

i have one column name is"project"

and value is

M3M COSMOPOLITAN

M3M COSMOPOLITAN

M3M COSMOPOLITAN,M3M GOLF ESTATE - Fairway East

M3M COSMOPOLITAN,M3M URBANA

now i want to represent project name without "M3M "  . plz suggest how to remove m3m  from all the values  in chart expression .

i attached screenshop

[mohammadkhatimi]

Hi,

Try this..

subfield(FieldName,' ',2)  as NewField

Regards,

Mohammad

[Anonymous]

with replace(), sequence or position does not matter...

It will serach the M3M in complete string and will replace it

[nagarjuna_kotha]

Hi Anil,

Please find below script.

Data:

Load * Inline

[

Company

M3M COSMOPOLITAN

M3M COSMOPOLITAN

M3M COSMOPOLITAN M3M GOLF ESTATE - Fairway East

M3M COSMOPOLITAN M3M URBANA

];

Load

Company,

Replace(Company,'M3M ','') as FieldName

Resident Data;

DROP Table Data;

[nagarjuna_kotha]

Above scrpit Gives you result like below:

[jyothish8807]

Hi Timba,

Same approach can be used if M3M is present in between also

Regards

KC