Need a help
I am giving input data as mentioned below . The bot will fetch and run based on the input one by one in loop. I want to capture the total number of input data given if an user gives in the input file Is it possible to capture that in orchestrator?
Note: I am a beginner of uipath!
Welcome to Uipath community
You can try with reflex expressions
It will get only number from the input data
can you tell where i need to give the reflex expression . Is it possible to capture that in log or in orchestrator
Where the user will give the input data/ file? @VB_Chel
The log message in the orchestrator that what we are giving in the studio. So you need to give the input string inside the expression.
Use assign activity and pass that expression in RHS
Thanks for helping !
The user will give the input data in excel which is stored in the user’s local system.
Then how will you read the excel file? @VB_Chel
If you can able to read the excel file. If yes try with the below following
Read the excel file and store it in data table variable - dtread
use for each row in data table activity
use assign activity
LHS -create an string variable
RHS - System.Text.Regularexpressions.regex.match(currentrow(“column name”).ToString.trim,”\d*$”).ToString
It will get the number.
I used Read Range workbook and called the excel file.
I don’t want the number mentioned in the Input file. i want number of quantities for example as mentioned below i need to get “total number of 6 input is used”
Sorry for wasting ur time
If you need row count of the excel
- Read range activity store it as stop
If yes try with this below expression