I have data in the excel sheet . one of the columns value is of the pattern “ABC-123”
ABC is same for all the values , only the numbers change
I have loaded the data into the queue and then pulled the data from queue to the workflow .
I want to validate whether the data is in the correct format .
I am using decision box .
Could any one tell me what should be the condition that i should use
Actually i am checking whether the field is just empty or filled in .
i have four columns in my excel sheet which i loaded it to the queue . Now i extracted it and stored it in the variable using assign activity .
Then i am using a flow decision
If the data is correct , then Proceed in opening the application and filling in the data .
If the data is wrong , then quit .
I have used the condition -
string.IsNullOrEmpty(ProductCode) and Quantity <> “” and Isnumeric(Quantity) and UnitPrice <>“” and isnumeric(UnitPrice) and CostCentre=“”
But I think this condition is not working .
Could you please help me out here .