If the value starts with X7 ignore it consider rest of the letters

[qlikviewforum]

Hi,

If the first 2 letter of a value starts with "X7" then we need to ignore the first two letters and rest has to be considered as the value.

For example, if the value of the field is X7RTXS then we should consider the value as only RTXS. Please help me to achieve this,

X7EGJGF --> EGJGF

X7GWEERY --> GWEERY

[JonnyPoole]

load

     if( left( [FieldName],2) = 'X7', mid([FieldName],3), [FieldName] as NewFielName

from

<source>

[qlikviewforum]

I think this will work

if(left('FieldName',2)='X7',Mid('FieldName',3)) as Temp

[maxgro]

if(left(field,2)='X7', Right(field, len(field)-2), field) as newfield