Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
do like this:
at script level:
mid(CompanyName,3,len(CompanyName)) as CompanyName
Hi,
use subfield(FieldNAme,' ',2)
or
replace(FieldName,'M3M','')
Regards
in your case:
Take it 4 which is the position from where string should start:
mid(CompanyName,4,len(CompanyName)) as CompanyName
try like this
=replace(Project_field_NAME','M3M',null()) as new_project
Hi Anil
Does the roject column has values starting with M3M for all vaues.
if yes then u can go with Left trim .
Regards
Timba
Hi Anil,
Try
replace(FieldName,'M3M','')
Regards,
Jagan.
Hi Anil,
Try like this: keep a extra space after M3M
Replace(FieldName,'M3M ','') as FieldName
Regards
KC
try this hope this help you
ltrim((purgechar ( 'project','M3M' )) as project
Hi Jyothish
what would be the case if M3M is in between the values.
Plz let me knw how to proceed.
Regards
Timba