Skip to main content
A
AjijMujawar
Cadet | Tier 2
February 14, 2025
Solved

How to get the the specific string from Input.

  • February 14, 2025
  • 16 replies
  • 244 views

I want to automate one of process where the scenario is we have to capture the Organization Unit/Units from the description mentioned in the application and Match those values with mapping available as Org List. Below is the sample desc. fields

  1. Please submit for the CARDIO VASCULAR,  CV-STRUCTURAL HEART   org model 
  2. Please submit for CRDM, AFI, AFS  CRDM, CRYOCATH   org model(s)
  3. Please submit for MITG  
    so the above are mentioned sample desc from there i have to capture the org units only how can we achieve this.

    Thanks,
    Ajij
Best answer by Marc Mueller

​@AjijMujawar This is better I guess: (forgot to add “Please submit for the” and “Please submit for” in my testing in above answer... Sorry😆)

 

 

 

 

16 replies

Show previous replies
Marc Mueller
Most Valuable Pathfinder
Marc MuellerMost Valuable Pathfinder
Most Valuable Pathfinder
February 17, 2025

​@AjijMujawar let us know if this worked for you please… 😊

Cheers

Marc

🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
    Dineshkumar Muthu
    Flight Specialist | Tier 4
    Dineshkumar Muthu
    Flight Specialist | Tier 4
    February 18, 2025

    Hi ​@AjijMujawar 

    You can use Regex to extract the organization units from your sample descriptions.

    Please find the details below:

    submit for(?: the)? (.*?)(?: org model| org model\(s\))

    Additionally, you can get the regex from the config file to add new patterns as needed.

    If you have any questions or need further assistance, please feel free to reach out.

    "Everything fails all the time, so plan for failure and nothing fails" - Werner Vogels ========== Linkedin Profile : https://www.linkedin.com/in/dineshkumar-muthu/
      A
      AjijMujawarAuthor
      Cadet | Tier 2
      February 18, 2025

      ​@AjijMujawar This is better I guess: (forgot to add “Please submit for the” and “Please submit for” in my testing in above answer... Sorry😆)

       

       

       

      Hello Marc i tried this approach but when we get multiple Orgs in single desc i have to get each Orgs from desc. and sometimes we may not receive before and after string in that case what will be the alternative solution 

       

      Marc Mueller
      Most Valuable Pathfinder
      Marc MuellerMost Valuable Pathfinder
      Most Valuable Pathfinder
      February 18, 2025

      ​@AjijMujawar Hmm…🤔

      this depend on you source data.

      Do you have a report what was filled in all the “Descriptions” so far (or a period) to think of some patterns?

      How should the “output” look like when having two ones provided?

       

      Cheers

      Marc 

      🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
      Marc Mueller
      Most Valuable Pathfinder
      Marc MuellerMost Valuable Pathfinder
      Most Valuable Pathfinder
      February 18, 2025

      ​@AjijMujawar 

      Have you tried the Regex approach from ​@DK 964 ?

      submit for(?: the)? (.*?)(?: org model| org model\(s\))
      🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
      A
      AjijMujawarAuthor
      Cadet | Tier 2
      February 18, 2025

      Hi ​@AjijMujawar 

      You can use Regex to extract the organization units from your sample descriptions.

      Please find the details below:

      submit for(?: the)? (.*?)(?: org model| org model\(s\))

      Additionally, you can get the regex from the config file to add new patterns as needed.

      If you have any questions or need further assistance, please feel free to reach out.

      Thanks DK will try this...

        Terms & ConditionsAccessibility statement