Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use Mid(field, 12)
You can use Mid(field, 12)
Try mid(field,12,len(field)).
Mid(YourFieldName,12) as YourRequiredFIeld
HI Luis
Use Mid(FieldName, Start_Character,End_Character) to fetch any part of string.
Regards
Chaitanya
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...