cancel
Showing results for 
Search instead for 
Did you mean: 

Strings Manipulation and Regex solutions

MayankGoyal2
Level 8
Hi, I have couple of questions regarding string and regex -

1) If I have a String and have to find position of all occurrences of a word (occurrences) in it and return all position in a collection, is there any VBO for the same?
2) If in above case the word to find is not constant, hence I want to define a Regex for it, then find all occurrences of regex in String and return a collection with matched value of String and position (collection with 2 fields) is there any VBO for this?

------------------------------
Mayank Goyal
------------------------------
15 REPLIES 15

@ewilson - Great update there to keep a note of, I use a lot of assets from DX Exchange myself and was aware of many actions, though I think I kind of skipped over this VBO completely but as you said it makes a lot of sense to check the development cards over DX regularly since it would be must easier to roll out frequent updates there. I have a list of many actions which would be great if they can be published as well since I have created a lot of code stages to get around those. I will surely post the DX ideas section with them as you suggested.

@Paul JHM Van Doorn - Though I completely agree with your statement that one should not just ask a new question without doing any due diligence over an ongoing thread like that, but in this case I would beg to differ since her question wasn't really related to any regular expression that can be googled or discovered on YouTube which seems to be like a part of the syllabus of any ongoing online course. Her question wasn't even related to some regular expression query and was rather targeted to an use case which was the same question that got asked in the first place but never really got answered.

If you observe carefully the thread, even I can't see where really the answer is given. The last answer is pretty much an open ended answer where it has been suggested to use a custom VBO and whatsoever no solution file or example was attached which can confirm how to find the positions and as Eric also mentioned the DX Exchange VBO also lacks this feature as of now.

Threads like this seem to be a good case to be continued since we ourselves tell the other members a lot of times to check similar questions a lot in the community and if there is a thread which corresponds to such a query, it should be addressed completely rather than them opening a new thread altogether or duplicating it. Just my view and opinion on open ended threads and how they should be handled. I am completely open to hear your opinions and views on the same.​​​​

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

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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

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

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

@devneetmohanty07  I'd love to get your input on any of the assets on the DX. Here's the link for the DX Asset Ideas page:

https://digitalexchange.blueprism.com/site/global/ideas/index.gsp

While I'm here, I'll add my $.02 on the idea of continuing old threads. Personally, I wish people would just create a new thread to ask their question and link any related/older threads. ​In my opinion, that makes it easier to keep track of questions, answers, and variations. 🤷‍♂️


Cheers,



------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

Hi guys,

Eric:
I support your wish to have folks start a new thread for either similar or distantly related subjects. I have pointed out my view on this before, but continuing on years old threads with slightly related questions seems to prevail. Perhaps BP could be persuaded to add an button to a thread that closes it once answered?

Devneet:
Since a while, BP took the excellent initiative to add a footer 'Related content' that can be used for easily finding related issues from the BP community forums. In any question I have, it would be a dead giveaway to start looking there.
Also, I am quite sure to have seen instructions online to do solve the original question asked in this thread in 2020. Likely that would be YouTube, but it could also be Udemy that I have access to via my work. The 101 link was added to help out inquisitive souls that want to test and see what Regex can do. That's usually the road I take; get directions, do some testing, followed by tweaking and we're in business.
For the fun of it, I quickly searched for the exact question: 'regex get all occurrences of a string with positions' and got directly to the first site (stackoverflow) providing me with an answer. Given that, I wouldn't dream of asking the question on this forum. When the thing is still unclear after I'd been playing with it for a while, I would formulate a question that solves where my research got stuck. But then again, perhaps that's just me trying to learn something new.
Don't get me wrong, I do like a lot of answers explaining how things work, but I sometimes have my doubts about the questions. And yes, if you want to learn you have to ask questions, heck, I ask questions all the time! But always aim to make it a good question.

------------------------------
Happy coding!
Paul
Sweden
------------------------------
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)

Paul,

That idea actually is really great, I also thought of this sometime back that the threads once marked with 'Best Answer' should be either closed automatically or should instead have a button to mark the same. I agree with you Eric as well, the open ended thread thing really creates a lot of unnecessary back and forth jumps and is overall really difficult to keep track of things. Perhaps, Paul either one of us can create this idea for the same though I know till we don't have enough votes it won't be considered but worth a try as I will connect with my networks as well to have it highlighted.

I agree completely with your points as well, that's a great point of view from your end about only relying on the community once you are stuck with your research work at some point. Even I do that so I can completely understand where you are coming from.

I will share my experience on one thing though with you, before being a part of the community I used to help a lot of people on  RPA groups hosted on personal messaging apps and many self published forums related to any issues they faced with code stages or C# implementation. One thing I noticed was that most of the people actually asking those questions were either business users mostly or were in RPA space but not from a technical background so that they can understand the code behind that. So whenever, I used to post these snippets of code directly to them, they would be ask me how to integrate the same with Blue Prism. Though now also even when there are LMS on how to integrate code stages still having DLL's and References are something which make this topic vast in sense. Other thing is I believe 'Stack Overflow' is the ultimate resource for any developer out there no doubts on that but sometimes I don't feel a business user would feel comfortable looking at those from a distance.

This is where I feel the Blue Prism Community shines as the answers here can be technical but are presented in a much friendlier way with markups and all. Plus in order to increase the engagement on the Blue Prism Community as well, I think it would be better if we can redirect most of the traffic from other forums related to Blue Prism directly on the Community site. That way the Blue Prism Community can grow better by miles like a one stop solution point by the community members and for the community members.

------------------------------
----------------------------------
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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

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

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

Hi Devneet,

Another thing missing on this forum is the ThumbsUp button that I'd like to click on your answer. 

I will concoct an ideation entry tomorrow now. Even though I speculate that it may not collect the number of votes set as a minimum motivation for development by BP, as supplier of a service the good folks at BP might be persuaded to go with it anyway.

https://community.blueprism.com/innovate/ideas/viewidea?IdeationKey=d6ee2e7e-6e45-4bbe-ade6-564bd63d962b

------------------------------
Happy coding!
Paul
Sweden
------------------------------
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)

Thanks a lot Paul for your thoughts and initiating the idea. They are as insightful as always and you already have my vote up there 🙂

I will try to get it as much spotlight as possible from my connected peers and connections.

PS. I think my next idea should be to make ideas acceptable with 10 votes instead of 20 😄

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

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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

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

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