Error Databricks 'charindex'. This function is neither a registered temporary function nor a permanent function registered in the database 'test'.; line 6 pos 32

Error in DataBricks SQL 'charindex'. This function is neither a registered temporary function nor a permanent function registered in the database 'test'.; line 6 pos 32

Instead of this 

CHARINDEX('.', JDEAccount)

Use This 

INSTR(JDEAccount, '.')