topic Re: Extract right hand values from a specified position in QlikView

Extract right hand values from a specified position

Thu, 18 Sep 2014 10:22:00 GMT

Hi ,

I have a text field and I would like to extract all its characters from the position twuelve to the end. The strings do not have allways the same size so I can not use a simple right(field,x) command.

How can I get this?

Thanks.

Re: Extract right hand values from a specified position

rubenmarin — Thu, 18 Sep 2014 10:25:56 GMT

You can use Mid(field, 12)

Re: Extract right hand values from a specified position

geert_gelade — Thu, 18 Sep 2014 10:26:20 GMT

Try mid(field,12,len(field)).

Re: Extract right hand values from a specified position

MK_QSL — Thu, 18 Sep 2014 10:28:59 GMT

Mid(YourFieldName,12) as YourRequiredFIeld

Re: Extract right hand values from a specified position

ychaitanya — Thu, 18 Sep 2014 10:31:06 GMT

HI Luis

Use Mid(FieldName, Start_Character,End_Character) to fetch any part of string.

Regards

Chaitanya

Re: Extract right hand values from a specified position

MK_QSL — Thu, 18 Sep 2014 10:35:51 GMT

Sorry but

mid(field,12,len(field)) is not the right solution... if you want to use Len(Field) you have to use as below

MID(field,12,Len(field)-12+1)

Correct me if I am wrong...