TimWells

Discussions

ETL - Get/Remove Values after First Space
Hi All, I am trying to separate the string's below to form two different columns. So my current column containing all the value is called 'Type' and i want to separate it to be two columns 'Medium' and 'Campaign' 'paid Car_Loans' should be 'paid' and 'Car Loans' 'callext Car Loans 2021' should be 'callext' and 'Car Loans…
Replace in SQL
I have a column which is bringing in some field values in between crotchets or square brackets [ ] and also in between inverted commas " " BUT not all values come through like this. I am trying to write a SQL to drop the [ ] and " " in the front and back of the values. im using REPLACE(REPLACE(`COLUMN NAME`, '[', ' '),…

ETL - Get/Remove Values after First Space
Hi All, I am trying to separate the string's below to form two different columns. So my current column containing all the value is called 'Type' and i want to separate it to be two columns 'Medium' and 'Campaign' 'paid Car_Loans' should be 'paid' and 'Car Loans' 'callext Car Loans 2021' should be 'callext' and 'Car Loans…
Replace in SQL
I have a column which is bringing in some field values in between crotchets or square brackets [ ] and also in between inverted commas " " BUT not all values come through like this. I am trying to write a SQL to drop the [ ] and " " in the front and back of the values. im using REPLACE(REPLACE(`COLUMN NAME`, '[', ' '),…