Desktop productivity for business analysts and programmers

Converting string to numeric using query builder

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

Converting string to numeric using query builder

Hi

 

Is there any way to do this? I tried a computed column OLD_VAR * 1 but got the error attached, I want to do this on point click because is faster than creating a program just to convert one var.

 

 

Attachment

Accepted Solutions
Solution
‎11-17-2016 11:47 AM
Community Manager
Posts: 2,696

Re: Converting string to numeric using query builder

You can do it by defining an Advanced Expression as a calculated column with the INPUT function, using something like:

 

  input(t1.CNPJ_CPF,best12.)

 

(replace "best12" with appropriate informat spec to get the precision you need).

View solution in original post


All Replies
Solution
‎11-17-2016 11:47 AM
Community Manager
Posts: 2,696

Re: Converting string to numeric using query builder

You can do it by defining an Advanced Expression as a calculated column with the INPUT function, using something like:

 

  input(t1.CNPJ_CPF,best12.)

 

(replace "best12" with appropriate informat spec to get the precision you need).

Occasional Contributor
Posts: 16

Re: Converting string to numeric using query builder

Thanks Chris !! ;-)
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 376 views
  • 1 like
  • 2 in conversation