Forum Discussion
Solved
If statement gives error token leftbracket expected
Im getting a token leftBracket expected error: I'm trying to add a "0" to the end of the field LotTxt if the length of the text is not 10. Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[...
Hi JimT99 ,
Could the left bracket error come from here. It seems like there is a double open bracket:
Here your code with the bracket in bold:
Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[[LotTxt], CONCATENATE(grading_data[LotTxt]),"0")
Does this solve your issue? 🙂
Hi JimT99 ,
Could the left bracket error come from here. It seems like there is a double open bracket:
Here your code with the bracket in bold:
Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[[LotTxt], CONCATENATE(grading_data[LotTxt]),"0")
Does this solve your issue? 🙂
yes...that was it. (Embarassed). Now it tells me that "If" isn't recognized.
Expression.Error: The name 'If' wasn't recognized. Make sure it's spelled correctly.