sammers101
Registered User.
- Local time
- Today, 10:26
- Joined
- May 11, 2012
- Messages
- 89
I'm getting the error: expression is typed incorrectly or it is too complex
Basically I want to truncate before either a " #", " annual", or " tp"
series1: Left([comic],IIf(InStr(1,[comic]," #")=0,Len([comic])+1,InStr(1,[comic]," #"))-1)
series2: Left([series1],IIf(InStr(1,[series1]," annual")=0,Len([series1])+1,InStr(1,[series1]," annual"))-1)
series3: Left([series2],IIf(InStr(1,[series2]," tp")=0,Len([series2])+1,InStr(1,[series2]," tp"))-1)
Basically I want to truncate before either a " #", " annual", or " tp"
series1: Left([comic],IIf(InStr(1,[comic]," #")=0,Len([comic])+1,InStr(1,[comic]," #"))-1)
series2: Left([series1],IIf(InStr(1,[series1]," annual")=0,Len([series1])+1,InStr(1,[series1]," annual"))-1)
series3: Left([series2],IIf(InStr(1,[series2]," tp")=0,Len([series2])+1,InStr(1,[series2]," tp"))-1)