I have a text field (part_#) that contains part numbers and descriptions. (123 part for machine) The part numbers are not all numbers, nor are they all same length. I want to make a new field named Description.
What is the best way to leave the first set of text (up to the first space) in the part_# field and take the rest of the text (could be one word, or multiple words) and put them into a new field called Description? without loosing any relational connections?
Thank you in advnce.
Grant