Robotic Process Automation (RPA)

Robotic Process Automation (RPA)

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
  • 1.  regex with right to left option

    Posted Mon June 21, 2021 12:24 AM
    Edited by Sonny Siah Mon June 21, 2021 12:25 AM
    Hi,

    I notice there is option "Right to Left" at studio regex builder, I try to capture the word from right to left is it possible. My example string as below. I want capture whole name but end with "Bhd" only. I try to use Right to Left but seem not work. Is there any similar example I can follow to get the result .

    ABC furniture Sdn Bhd
    XYZ Cycle Word Sdn Bhd (X-65640)





    Thanks.

    ------------------------------
    Sonny Siah
    Infra365 Sdn Bhd
    ------------------------------


  • 2.  RE: regex with right to left option

    Posted Mon June 21, 2021 11:43 AM
    Hi Sonny, 

    I consulted with some of our team, and another way to do this would be without right to left -just using a regex. Could you use something like this to match an expression ending with Bhd<newline>?

    Here is an example:  

    You might need to adjust to capture all etc, and can use regexr.com to test. 

    Let us know if you were intending to do something different.



    ------------------------------
    Stephanie Wilkerson
    IBM
    ------------------------------



  • 3.  RE: regex with right to left option

    Posted Mon June 21, 2021 10:42 PM
    Hi Stephanie,

    Great this tool quite good to start creating regex, I manage to get it work now

    If just exactly grab the name ending with "Bhd" then use your provided string will do


    if want to grab whatever name which got "Bhd" but extraction without text after the Bhd then I use below get the result I want.


    At the IBM RPA studio, I found out it doesn't matter I use Right to Left or not the result still work.


    without Right to Left

    Thanks.

    ------------------------------
    Sonny Siah
    Infra365 Sdn Bhd
    ------------------------------



  • 4.  RE: regex with right to left option

    Posted Tue June 22, 2021 11:02 AM
    Great! Glad to hear it is working.

    ------------------------------
    Stephanie Wilkerson
    IBM
    ------------------------------