Can you help e understand why I am getting this error when using INSTR() in the transform and cleanse?
What data source do you use?
We use Oracle 9, Windows 10 Enterprise 64 bit
But running 32bit TOAD DATA POINT
Try to use it like this, check the Use SQL Transforms option, remove the square brackets around the column name and instead of the quotes around string value, use tick marks. See the image below.
Thank you for the response!
It worked, but I had to use it like this:
INSTR(KEY
, 'a')
2 Likes