topic Extract The Data From Particular Formate in Product Forum

Extract The Data From Particular Formate

ChetanNinghot — Mon, 03 Oct 2022 18:19:00 GMT

Hi
I Have Getting Output As Dynamic Formate Sometime 164 Km . About 2 days 3 hours
Sometime 12000 Km . About 23 hours 25 mins
Sometime 1778 Km . About 1 day 1 hour

Depending Apoun Output I want Output As separate Formate
Km=164 , days=2 , hours=3
Km=12000, hours=23 , mins=25
Km= 1778 , day=1, hour=1




------------------------------
Chetan Ninghot
------------------------------

RE: Extract The Data From Particular Formate

ritansh.jatwani — Mon, 03 Oct 2022 21:34:00 GMT

HI @Chetan Ninghot,

1) Use "Split text" action of "Utility Strings" to split on the basis of keyword "Sometime"
2) This split will give you data in tabular form of 3 different rows.
3) Now create a logic to get the value of Km, day and hour value using string manipulation techniques i.e. using Mid function, Instr funtion etc.

Please let me know if you are facing challenges in building up the logic and I can help you with that.

------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

RE: Extract The Data From Particular Formate

ChetanNinghot — Tue, 04 Oct 2022 05:39:00 GMT

Hi
Ritansh Jatwani
thank you for your Response
as per Question my output varries

- 164 Km . About 2 days 3 hours ............................... first time i got this output
- 12000 Km . About 23 hours 25 mins .........................second time i got this output
-1778 Km . About 1 day 1 hour ...................................Third time i got this output

may formate of output Change
Km , days ,hour
km, hours, mins
km, day , hour

like That but in Utitlity -split text not Work For That it required Input "Slit Char" in Delimetre but my Formate Chage Every Time How it
separted Each Value

------------------------------
Chetan Ninghot
------------------------------

RE: Extract The Data From Particular Formate

ManpreetKaur1 — Tue, 04 Oct 2022 11:13:00 GMT

HI @Chetan Ninghot,

Are there any other possible combinations which can come apart from Days hours and hour min combination?

------------------------------
Manpreet Kaur
Manager
Deloitte
*If you find this post helpful mark it as Best Answer
------------------------------

RE: Extract The Data From Particular Formate

ChetanNinghot — Tue, 04 Oct 2022 13:37:00 GMT

HI
Manpreet Kaur

my Output Is 164 Km . About 2 days 3 hours
and it Possibility Combination Is
Km , days ,hour
OR
km, day, hour
OR
km, hours,mins

------------------------------
Chetan Ninghot
------------------------------

RE: Extract The Data From Particular Formate

zdenek.kabatek — Wed, 05 Oct 2022 06:15:00 GMT

Hi, Chetan,

how about using Utility - Regex?
\d* Km
\d* days
\d* hours
\d* mins

Regards

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

RE: Extract The Data From Particular Formate

ArunK_J — Mon, 10 Oct 2022 15:17:00 GMT

Hi @Zdeněk Kabátek ,

I'm currently learning the scope of Regex pattern matching.
In this particular case I have a doubt. The input text value seems to be dynamic. It says 'day' for 1 day and 'days' for any value greater than or equal to 2.
Please let me know how to provide the Regex pattern in this case.
Also, please confirm if the action we need to use for this purpose is what I have mentioned in the screenshot below:

Thanks & Regards

------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------

RE: Extract The Data From Particular Formate

devneetmohanty07 — Mon, 10 Oct 2022 16:27:00 GMT

Hi @ArunK_J

For the days part, you can use the following regex: '\d* day+s*'

From the test above, you can see that both day and days can be included if you use the above expression.

The working is simple:

\d* says that any number can appear 0 or more times
day+ says that the keyword 'day' must appear at least once in this expression
s* says that the word s can appear 0 or more times as it is optional in nature

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------