topic How to trim column value in QlikView

How to trim column value

yadav_anil782 — Thu, 03 Dec 2015 07:04:03 GMT

Dear Comunity,

i have one column name is"project"

and value is

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

Re: How to trim column value

Anonymous — Thu, 03 Dec 2015 07:07:01 GMT

do like this:

at script level:

mid(CompanyName,3,len(CompanyName)) as CompanyName

Re: How to trim column value

PrashantSangle — Thu, 03 Dec 2015 07:07:25 GMT

Hi,

use subfield(FieldNAme,' ',2)

replace(FieldName,'M3M','')

Regards

Re: How to trim column value

Anonymous — Thu, 03 Dec 2015 07:08:28 GMT

in your case:

Take it 4 which is the position from where string should start:

mid(CompanyName,4,len(CompanyName)) as CompanyName

Re: How to trim column value

avinashelite — Thu, 03 Dec 2015 07:10:38 GMT

try like this

=replace(Project_field_NAME','M3M',null()) as new_project

Re: How to trim column value

Thu, 03 Dec 2015 07:12:02 GMT

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

Re: How to trim column value

jagan — Thu, 03 Dec 2015 07:57:45 GMT

Hi Anil,

Try

replace(FieldName,'M3M','')

Regards,

Jagan.

Re: How to trim column value

jyothish8807 — Thu, 03 Dec 2015 08:10:14 GMT

Hi Anil,

Try like this: keep a extra space after M3M

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

Regards

Re: How to trim column value

ahmar811 — Thu, 03 Dec 2015 08:30:38 GMT

try this hope this help you

ltrim((purgechar ( 'project','M3M' )) as project

Re: How to trim column value

Thu, 03 Dec 2015 10:01:54 GMT

Hi Jyothish

what would be the case if M3M is in between the values.

Plz let me knw how to proceed.

Regards

Timba

Re: How to trim column value

mohammadkhatimi — Thu, 03 Dec 2015 10:16:58 GMT

Hi,

Try this..

subfield(FieldName,' ',2) as NewField

Regards,

Mohammad

Re: How to trim column value

Anonymous — Thu, 03 Dec 2015 11:07:20 GMT

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

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

Re: How to trim column value

nagarjuna_kotha — Thu, 03 Dec 2015 11:43:46 GMT

Hi Anil,

Please find below script.

Data:

Load * Inline

[

Company

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;

Re: How to trim column value

nagarjuna_kotha — Thu, 03 Dec 2015 11:47:02 GMT

Above scrpit Gives you result like below:

Re: How to trim column value

jyothish8807 — Thu, 03 Dec 2015 12:57:53 GMT

Hi Timba,

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

Regards