To check if a value is a text

[Chakravarthy GRK]

Hi All

How to check if a field is text or number. based on which the item will turn to mark completion / exception.

In the decision box currently i am using to check if a field is empty like Data.productcode <>"". on the similar lines
do we have something.

i remember we have something in vb like isnumeric.

Thank you all

 

[Sachin_Kharmale]

Hi Chakravarthy,

For checking the current field number or text. you can simply use IsNumber() function in Decision stage.
if current field contains numeric data then it will return true otherwise it will return false.
based on true or false you can mark item as Completed or Exception.

View attachment 1558671777309.png
Fig 1- Decision Stage

View attachment 1558671956012.png
Best Regards,
Sachin

 

[democko_kamil]

You could also regex to check - "([A-z]+)" for text (you would neet to add any special character to the list, if you want to check for them too), or "([0-9]+)" for number

 

[Chakravarthy GRK]

S & D
You guys are super , thnxa ton for your help