Splitting by delimiter vs LOCATE() function equivalent
I want to fill the nulls in column A with the values in column B (or C if B is null).
A case statement did not work here so I am aiming to achieve this by combining the columns and then separating them by delimiter. Unfortunately, by separating them we are - of course- back to square one.
I was able to use this method for dates because I could do a LEFT(Date_shared,10) and extract the first date in the merge. However, for IDs, the first ID could be a length between 4 and 14.
It's a simple LEFT(FIND()) or LOCATE() sql situation but there doesn't seem to be a 'find position' function in the Magic ETL
All help appreciated