Convert Text Values to Numbers Using the "Text to Number" Text Helper

In Keragon, data type mismatches can prevent smooth data mapping between workflow steps. If you’re working with numeric values stored as text, use the Text to Number Text Helper to convert them into proper number values. This ensures compatibility with number fields in your workflow actions.

How to Use the Text to Number Text Helper

00:00: You may have trouble mapping your values in the fields. 00:02: If the data type doesn't match for example text or string value 00:06: to a number field. You can use the text to number action to 00:10: convert text values to numbers. 00:14: First go to your workflow editor. 00:19: Click the plus icon. 00:22: Access the helpers menu. 00:25: Select the text helpers option. 00:28: Choose the text to number action. 00:31: Click on the text field. 00:34: Map the text value that contains the number that you want to transform. 00:39: Save the changes made. 00:42: Click the test step button. 00:45: View the outputs tab 00:48: You should see the text converted into a number of value. 00:52: This guide covered the process of converting text values to numbers in caragon.

  • Open your workflow editor.

  • Click the + icon to add a new step.

  • In the step selection panel, click "Helpers".

  • From the Helpers options, select "Text Helpers".

  • Choose the "Text to Number" action.

  • Click the Text field.

  • Use the Variable Selector to map the text value that contains the number you want to convert.

  • Click "Save" to apply changes.

  • Click "Test Step" to preview the result.

  • Go to the Outputs tab to view the converted numeric value.

Example Result:

  • Input: "123.45"

  • Output: 123.45 (as a number)

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more