View Full Version : separate


digit
08-05-2004, 03:01 AM
dear friends,
is there someone who can tells me how can i separate more digits.
Examples:
112244554455,54
1234567897898,57
128761237836,89

So, from first digit i wanna to get 55.54, from 2nd - 898.57, from 3rd 6,89.
And to make 2 colums - 1st only first 10 digits - 2nd column - the other.
Im waithing your response ASAP.
Thanks

namliam
08-05-2004, 04:04 AM
Field1: Left([Yourfield],10)
Field2: Mid([Yourfield],11)

Greetz