Hi - Trying to split this up through Access 2010 query.
Example: "COMPANY FF - DAVE GROHL"
String lenth is variable and delimiter is "-". I have this working for one side.
CONTACT: Trim(IIf([SCOMPANY] Like "*-*",Right([scompany],Len([scompany])-InStr(1,[SCOMPANY],"-")),"."))
Can not get the company side to work?:banghead:
COMPANY: IIf([SCOMPANY] Like "*-*",Left([scompany],Len([scompany])-InStr(1,[SCOMPANY],"-")-2),[SCOMPANY])
Any thoughts??
Thanks
Example: "COMPANY FF - DAVE GROHL"
String lenth is variable and delimiter is "-". I have this working for one side.
CONTACT: Trim(IIf([SCOMPANY] Like "*-*",Right([scompany],Len([scompany])-InStr(1,[SCOMPANY],"-")),"."))
Can not get the company side to work?:banghead:
COMPANY: IIf([SCOMPANY] Like "*-*",Left([scompany],Len([scompany])-InStr(1,[SCOMPANY],"-")-2),[SCOMPANY])
Any thoughts??
Thanks