Split a text field into two separate fields

[mrussell71]

I have a text field (Description) that I want to split into two different fields (Part_Def) and (Footnote). The Description field has a text string at the beginning, i.e. "[part definition]". After the closing bracket there is another string that I want to parse out into a separate field.

How should I set up a query to parse this information into two fields? I want to break the original string at the " ] ". Everything to the left placed in the Part_Def field, including the " ] " And everything to the right in the Footnote field.

Thanks for the help.

 

[mrussell71]

Never Mind, I figured it out.

part_def: Left([DESCRIPTION],InStr([DESCRIPTION],"]&quot)

and then,

TempDesc: Right([DESCRIPTION],Len([DESCRIPTION])-InStr([DESCRIPTION],"]&quot)

 

[jjonesal]

If you don't want the brackets included....

col1: Left([Description],InStr(1,[Description],"]&quot-1)

col2: Mid([Description],InStr([Description],"]&quot+1,Len([Description])) J. Jones
jjones@cybrtyme.com