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 email@example.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: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of cchang@...
Sent: Thursday, November 07, 2013 4:47 PM
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..."
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.
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).