Splitting by delimiter vs LOCATE() function equivalent

NateBI
NateBI Contributor
in Magic ETL

Hi All,

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.

image.png

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

Answers

Categories