Jump to content
  • 0

Triggered action how to convert from text255to number/integer/currency ?


CapNcook

Question

Hi Everyone,

I have a field that is text 255 that contains number and letters. Ex.
image.png.605b6af20016ed7605bf8caa7371b3b6.png

I place them in a variable and I use replace to remove the text and only retain numbers(All good).
image.png.61dab8abc359ac01fc3638d9f8ac6b81.png


But the problem is when I use this variable to and store the value in a currency,integer, or number field I get Datatype mismatch error. What should I do? 

image.png

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

What I do here is that I create a table with 3 fields.

A text 255, an ID field, and a formula field with a formula that converts the contents of the text field to float or int (remove the nun numerical values as well.)

I used an insert block to pass the value to that table's text255 field and pull the value of the formula field. 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...