Where to find Documentation?

ColinHaze · October 2024

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 · October 2024

@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 · October 2024

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

ColinHaze · October 2024

MichelleH

I am actually using SQL Transformation.

MichelleH · October 2024

@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

Where to find Documentation?

Best Answer

Answers

Categories