- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-22 07:13 PM
I Have Got Output As Text Data item - 1 day 5 hours
But I Want separated Value Like in separate separate Data item - day=1 hours=5
but my output text formate may change every time like that
1 day 5 hours
OR
5 days 1 hour
OR
9 hour 35 mins
------------------------------
Chetan Ninghot
------------------------------
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 07:17 AM
I was able to replicate the scenario and get the desired output. I believe the information provided in below screenshots will be helpful.
I'm fetching Days, Hours, Minutes and Seconds in separate data items which you may use further as per your requirement.
Choice stage:
Multi calc stage:
For each multi calc stage, update first line with corresponding text value (Day, Hour etc.). Note that I have not used plural terms so that when the input is singular like '1 Hour', it will also be captured.
In the second line, +4 is mentioned to skip the term 'Day' or 'Days'. For each multi calc stage, update this value accordingly. If needed, I can provide screenshots of the remaining multi calc stages.
------------------------------
Arun K J
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 07:17 AM
I was able to replicate the scenario and get the desired output. I believe the information provided in below screenshots will be helpful.
I'm fetching Days, Hours, Minutes and Seconds in separate data items which you may use further as per your requirement.
Choice stage:
Multi calc stage:
For each multi calc stage, update first line with corresponding text value (Day, Hour etc.). Note that I have not used plural terms so that when the input is singular like '1 Hour', it will also be captured.
In the second line, +4 is mentioned to skip the term 'Day' or 'Days'. For each multi calc stage, update this value accordingly. If needed, I can provide screenshots of the remaining multi calc stages.
------------------------------
Arun K J
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 07:33 AM
Arun K J
Thank You For Your Response
Pleas Send Another Calculation Screenshot. it may helful for me
I am Trying To Used It
If It Work Properly I will Inform You
------------------------------
Chetan Ninghot
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 07:45 AM
Please find the screenshots of all Multi calc stages below:
It worked for a number of different input values. Please let me know if you are facing any trouble with any particular input.
Days:
Hours:
Minutes:
Seconds:
Note: Give the choice criterions in the same order as I have given for it to work as per the common timestamp logic.
------------------------------
Arun K J
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 11:25 AM
Arun K J
Thanks For Prviding Solution Ans Solutuion Screenshot
its Work Properly For this input 25 Days 20 Hours 55 Minutes 40 Seconds
even it work properly
1)6 days 9 hours 2)23 hours 19 mins
but Its Fails for
1)2 day 1 hour
2)1 hour 19 mins
Note:-its work for singular Value not for Plurar Value
can you provide solution for it
------------------------------
Chetan Ninghot
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 01:27 PM
The problem was not with Singular/Plural. It was with the case sensitivity. I have made a small correction to address that.
Please find the corrections below:
1) Added a stage to convert input to Upper case.
2) Changed the terms like day, hour etc in Choice stage to upper case.
3) Changed the terms in all multi calc stages to Upper case. Providing screenshot of multi calc stage for Day in Choice stage below:
Just like this, change the Hour, Minute, and Second to all upper case -> HOUR, MINUTE, SECOND.
This will resolve the issue. Please check next comment for the correct output of the inputs you have mentioned.
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 01:38 PM
A) 1 day 5 hours
B) 5 days 1 hour
C) 9 hour 35 mins
The only difference is, in the process I have built, the keyword used in the choice and the multi calc stage for minutes is 'MINUTE'. If the input you are using mentions it as min or mins, corresponding change needs to be done to mention 'MIN' as the keyword in the choice and in the multi calc stage for minutes criteria . You can make the correction as mentioned in the screenshots below:
Correction in Choice:
Correction in Multi Calc stage of minutes criteria:
Please check and let me know of this resolves your issue.
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 02:05 PM
Thank You very much providing proprer solution
of my Query
Thanks Lot
------------------------------
Chetan Ninghot
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-10-22 02:15 PM
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------