Forum Discussion

JimT99's avatar
JimT99
Icon for Helper I rankHelper I
4 years ago
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[...
if
syntax
tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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? 🙂
 
  • JimT99's avatar
    JimT99
    Icon for Helper I rankHelper I
    4 years ago

    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.