Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract right hand values from a specified position

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.

1 Solution

Accepted Solutions

You can use Mid(field, 12)

View solution in original post

5 Replies

You can use Mid(field, 12)

View solution in original post

Creator
Creator

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

MVP
MVP

Mid(YourFieldName,12) as YourRequiredFIeld

Creator III
Creator III

HI Luis

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

Regards

Chaitanya

MVP
MVP

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...