cancel
Showing results for 
Search instead for 
Did you mean: 

Casting // Type conversion

MichalMichalak
Level 2
Hi All, Is there any way to cast/convert data types in BP Expression Editor?
3 REPLIES 3

John__Carter
Staff
Staff
There are a number of conversion functions like ToNumber for use within an expression. If you want to cast the output of an expression, just use a data item with the type you want in the Store In field. Be aware though that casting is not magic - there are limitations to what can be converted, and an exception will be raised is the cast is illegal.

MichalMichalak
Level 2
Thank You @John Carter, I'll experiment with those 🙂

Hi All, I imported excel to local undefined collection. Excel has fields Date and Quantity. when i imported them the datatype is text for every column. How to change datatype back to date ,quantity for whole column where my excel has 1000 rows. Thank you in advance