I have a CR formula that I want to use in Ignition.
IF {GFSITMATT_COPPERLIQ.ATTVALCOD_0} <> "NONE" THEN
extractstring({ATEXTRA_COPPERLIQ.TEXTE_0},'',' =') + "-" + extractstring({ATEXTRA_COPPER.TEXTE_0},'',' =')
ELSE
extractstring({ATEXTRA_COPPER.TEXTE_0},'',' =')
What it does is it takes the data like 1/2" = .50 and extracts just the 1/2". Anyone know how to do this? I've tried everything.
You'll have to provide a bit more information for anyone to be able to help.
Where in the designer are you using this, and what is providing the data? Show what you tried so far and what that resulted in. You mention crystal reports, are you attempting to build an equivalent report in Ignition, or are you attempting to parse a report from SAP?
If you are attempting to build a report in Ignition, this manual page might be of interest:
Sorry. First time.
It is using a SQL Server data source and I was trying to add it as a text shape on a label that I need to print.
In that case, the keychain expressions I linked above would be one approach. The keychain expression would go in the text property of the text shape.
Another option is to add a script datasource to your report that takes your SQL data and pre-processes it into the data you want to display/print. If you do this approach then you have access to python and java methods for string manipulation.
Given the complexity of the expression I would 100% do it in a scripting data source or right in SQL. Editing keychain expressions espeically long ones is very annoying through designer ime.
I like to keep report components as simple as possible and to only display the data provided.