Is it possible to do an integer conversion calculated field from a calculated field that is character based? For example, we have a calculated field 256 that is character based that we want to convert into a calculated integer field. It seems like you can't convert from a calculated field?
---In vantage@yahoogroups.com, <vic.drecchio@...> wrote:
Ah, I would combine it all into one calc’d field.
Something like: INT(SUBSTRING(YOUR_FIELD, 4, 3))
If the dash in the P/N is not static, then you can use the INDEX() function to search for the dash and set it dynamically on the fly.
If you don’t have it already, download the Progress Ref Manual from the FILES section of this site.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cchang@...
Sent: Thursday, November 07, 2013 4:47 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] BAQ-Calc conversion from Character to Integer
We have a Part Number field which is a character field (i.e. ABC-256) and did a calculated field to bring back the right three characters only (i.e. 256). We then want to convert the characters 256 into an integer. The CSMLength field is a character field (does this mean it's a non-numeric value even if its numeric coming from a character based field?) I thought the integer function "converts an expression of any data type..."
---In vantage@yahoogroups.com, <vic.drecchio@...> wrote:You seem to have the correct syntax. Are you sure everything in CSMLength is convert-able to INT? Meaning, perhaps there’s a non-numeric value stored somewhere in one of the records being selected.
For giggles, try limiting your selection with a filter on a known good record and see if you still get the conversion error.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cchang@...
Sent: Thursday, November 07, 2013 4:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ-Calc conversion from Character to Integer
I have a calcualted field that is a character Data Type field that I want to convert to an Integer calculated field. Does anyone know what the string function is? I tried using the function Integer(CSMLength) where CSMLength is a character field but it gives me an error. Looking to convert a character field (i.e. 256) into an integer field (256).