splitting data in one field into 2 fields 1

[ch4meleon]

Im hoping someone can help with this one, i have a field in a table that contains a 6 digit number followed by a description, i want to split this into 2 fields, the number and the description seperated ?

any help gratefully received

 

[Ach005ki]

Have you tried something like

for the numeric:

SUBSTR([i]CombinedField[/i],1,6) AS MyNumberField

for the non-numeric:

SUBSTR([i]CombinedField[/i],7,LEN(TRIM(CombinedField))-6) AS MyDescriptionField

- the LEN bit will calculate the length of the trimmed field and then substract 6 from this... as you've already taken the first six characters for your number field

 

[PHV]

In the query grid:
number: Val(Left([yourField], 6))

description: Mid([yourField], 7)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ch4meleon]

Thank you both for replying !! PHV thats great, nice and easy