Splitting Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db that has over 220k entries. My problem is that I one field is
very long called SKU descr. Ity has 8 numbers a space and anywhere form 20 to
30 characters after. Is it possible to split this field in 2 and call the
numbers SKU ID and have the rest of the text stay in SKU description.

Thank you,

Chris
 
To get the first 8 characters, use the Left function. To get whatever starts
at position 10 and goes to the end, use the Mid function:

Left(CompleteString, 8) and Mid(CompleteString, 10)
 
Back
Top