How to split a field into 2 fields?

[Guest]

I imported a spreadsheet from Excel and would like to split one field into
two fields.

Many of the records in Field1 have a note in parenthesis ( ). If a record
has anything contained in parenthesis, I would like to move that data to
Field2.

What's the best way to accomplish this?

 

[Guest]

To get the word inside the parenthesis try something like

SecondWord:
IIf(InStr([MyLeeter],"("),Mid([MyLeeter],InStr([MyLeeter],"(")+1,Len([MyLeeter])-InStr([MyLeeter],"(")-1),"")

FirstWord:
IIf(InStr([MyLeeter],"("),Left([MyLeeter],InStr([MyLeeter],"(")-1),[MyLeeter])

 

[Guest]

Will this work if there are multiple words?

Often times, the text I have between parenthesis is a phrase (i.e. several
words).

To get the word inside the parenthesis try something like

SecondWord:
IIf(InStr([MyLeeter],"("),Mid([MyLeeter],InStr([MyLeeter],"(")+1,Len([MyLeeter])-InStr([MyLeeter],"(")-1),"")

FirstWord:
IIf(InStr([MyLeeter],"("),Left([MyLeeter],InStr([MyLeeter],"(")-1),[MyLeeter])

--
Good Luck
BS"D

I imported a spreadsheet from Excel and would like to split one field into
two fields.

Many of the records in Field1 have a note in parenthesis ( ). If a record
has anything contained in parenthesis, I would like to move that data to
Field2.

What's the best way to accomplish this?

 

[Guest]

It should work, try it

--
Good Luck
BS"D

Will this work if there are multiple words?

Often times, the text I have between parenthesis is a phrase (i.e. several
words).

To get the word inside the parenthesis try something like

SecondWord:
IIf(InStr([MyLeeter],"("),Mid([MyLeeter],InStr([MyLeeter],"(")+1,Len([MyLeeter])-InStr([MyLeeter],"(")-1),"")

FirstWord:
IIf(InStr([MyLeeter],"("),Left([MyLeeter],InStr([MyLeeter],"(")-1),[MyLeeter])

--
Good Luck
BS"D

I imported a spreadsheet from Excel and would like to split one field into
two fields.

Many of the records in Field1 have a note in parenthesis ( ). If a record
has anything contained in parenthesis, I would like to move that data to
Field2.

What's the best way to accomplish this?

 

[Guest]

Thank you for the help. That worked.

It should work, try it

--
Good Luck
BS"D

Will this work if there are multiple words?

Often times, the text I have between parenthesis is a phrase (i.e. several
words).

To get the word inside the parenthesis try something like

SecondWord:
IIf(InStr([MyLeeter],"("),Mid([MyLeeter],InStr([MyLeeter],"(")+1,Len([MyLeeter])-InStr([MyLeeter],"(")-1),"")

FirstWord:
IIf(InStr([MyLeeter],"("),Left([MyLeeter],InStr([MyLeeter],"(")-1),[MyLeeter])

--
Good Luck
BS"D


:

I imported a spreadsheet from Excel and would like to split one field into
two fields.

Many of the records in Field1 have a note in parenthesis ( ). If a record
has anything contained in parenthesis, I would like to move that data to
Field2.

What's the best way to accomplish this?