Extract right hand values from a specified position

[#1]

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.

[rubenmarin · Accepted solution]

You can use Mid(field, 12)

[geert_gelade]

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

[MK_QSL]

Mid(YourFieldName,12) as YourRequiredFIeld

[ychaitanya]

HI Luis

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

Regards

Chaitanya

[MK_QSL]

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