topic Re: Remove characters before a special character in QlikView

Remove characters before a special character

Mon, 01 Sep 2014 13:57:08 GMT

Hi,

So I have a field which has a '-' at different places within the field. In all cases I want to only show the characters that appear after the -.

For example:-

stu-art should be art

s-tuart should be tuart

What type of expression can I use to get around this?

Thanks

Stuart

MK_QSL — Mon, 01 Sep 2014 14:02:15 GMT

Subfield(YourFieldName,'-',2) as YourFieldName

Subfield(YourFieldName,'-',-1) as YourFieldName

ashfaq_haseeb — Mon, 01 Sep 2014 14:04:25 GMT

try below

subfiled(field,'-',2)

Regards

ASHFAQ

Mon, 01 Sep 2014 14:06:11 GMT

Hi,

Sorry i should have said that the field could be any lenght.

For example we could have

ffffffffffffffffffffffffff-f

ggggggggggggggggggggggggggggggggggggggggg-aa

ashfaq_haseeb — Mon, 01 Sep 2014 14:09:00 GMT

That should work.

Regards

ASHFAQ

ecolomer — Mon, 01 Sep 2014 14:12:31 GMT

Use SubField:

Subfield(FieldName,'-',2) as NewFieldName