Regex in calculated field

Hi Mike,

Thanks for reaching out. Indeed as you touched upon, and correctly speculated, the only way to accomplish would be via a Freehand SQL Calculated Field as you'll have to utilize a DB-specific Function in order to do this, which are only available via Freehand. Please let me know if you have any further questions on this.

Regards,

Mike

Would you happen to have an example of how this would look in freehand sql ?

Clermont,
Florida
USA 34714

From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, April 23, 2020 11:06 AM

To: Yates, Mike <Mike_Yates@bmc.com>

Subject: [EXTERNAL] New Comment in "Regex in calculated field"

Hi Mike,

I don't have any specific examples, but there are examples online, such as this one for SQL Server or this one for MySQL. There are several options to get this result and will depend on your RDBMS and what you're looking to return.

The following is an example I came up with to return all results before 'L' using MySQL.

My query:

Result:

You can see the original data in the left-most column, and the string before 'l' in the second column. My DB isn't case sensitive so there's no difference between 'l' vs. 'L', so that may be something else to look for on your end as well, though this wouldn't be applicable looking for '!' of course.

Please let me know how goes and whether you have any additional questions.

Regards,

Mike

So I did get it to work … Backend database is MSSQL and this is what I cam up with to get the result I needed …

REPLACE(LEFT(full_inst_name, (CHARINDEX('!', full_inst_name))),'!','')

Thanks for the pointers …

Clermont,
Florida
USA 34714

From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, April 23, 2020 11:45 AM

To: Yates, Mike <Mike_Yates@bmc.com>

Subject: [EXTERNAL] New Comment in "Regex in calculated field"

Hi Mike,

Awesome! You're welcome. This considered, I'll go ahead and close this case out then, but please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike