Extract Limited no. of length from a alpha numeric field.

[Anonymous]

Hi Guys,

There is a field containing alphanumeric data.

say : a12364g454433332

want to extract limited lengths ,

ex: a1236

or

a12364g

How this can be achieved at script level in QV.

[#2]

mid('a12364g454433332',1,5)

mid('a12364g454433332',1,6)

Greetz,

Andreas

[#3]

or use left:

left('a12364g454433332',5)

[Anonymous]

Hi ,

Thanks for the reply,,

But i need this to happen with all the records in a particular field.

Can u tell me how to achieve this in script..

Regards

[#5 · Accepted solution]

LOAD mid(field,1,5) AS part,

* FROM bla;

[Anonymous]

Thanks,

the mid() logic worked..