Where to find Documentation?

ColinHaze

Hi,

I am trying to split a string and I cannot find which method to Use. Ive tried the substring_index method and the split_string Method and both have failed. I am trying to extract the city name out of a string that looks like this "CARROLLTON,TX/"

Thank you

MichelleH

@ColinHaze In that case, you can use the MySQL documentation since that is the version of SQL Domo uses. Here is the documentation of their string functions: https://dev.mysql.com/doc/refman/8.4/en/string-functions.html

MichelleH

@ColinHaze If you are using MagicETL, then I recommend using the SPLIT_PART function in the Formula tile.

ColinHaze

MichelleH

I am actually using SQL Transformation.

MichelleH

@ColinHaze In that case, you can use the MySQL documentation since that is the version of SQL Domo uses. Here is the documentation of their string functions: https://dev.mysql.com/doc/refman/8.4/en/string-functions.html