separate

digit

Registered User.
Local time
Today, 16:01
Joined
Jan 23, 2003
Messages
44
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
 
Field1: Left([Yourfield],10)
Field2: Mid([Yourfield],11)

Greetz
 

Users who are viewing this thread

Back
Top Bottom