# BAQ-Calc conversion from Character to Integer

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).

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).

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).

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).

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).

Do you know if it is possible to do a calculated conversion from another calculated field that is character based data type?  For example, I have a calculated field (.i.e 256) that is character based and would like to do an integer conversion of that calculated character field 256 into an integer field 256.

---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).