Skip to main content
Solved

How to get the the specific string from Input.

  • February 14, 2025
  • 16 replies
  • 162 views

Forum|alt.badge.img+3

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

  • Cadet | Tier 2
  • February 14, 2025

Hi As per my understanding your are trying to find the “Value” which has “org”.

if you are trying to find then then you can use

Conditional Statement:   IF condition string Includes;

String operation:             EXTRACT TEXT before after and Store in a variable

Note : if this is not actual Solution you are looking for Could you please elaborate the Scenario.

Thanks,

Divya Mulakala.


Shreya.Kumar
Pathfinder Community Team
Forum|alt.badge.img+14
  • Pathfinder Community Team
  • February 14, 2025

@AjijMujawar could you elaborate on where you’re trying to get these details from? Is it a PDF? A DOCX file? A Website? The source material would help us advise the next steps.


Forum|alt.badge.img+3
  • Author
  • Cadet | Tier 2
  • February 14, 2025

I am capturing “Please submit for the CARDIO VASCULAR,  CV-STRUCTURAL HEART   org model”  from SAP application as mentioned below 

 


Shreya.Kumar
Pathfinder Community Team
Forum|alt.badge.img+14
  • Pathfinder Community Team
  • February 14, 2025

In this case, here’s an approach I would recommend

  1. use a Recorder Package to capture the input field next to description
  2. Then get the property that matches the entire string displayed in the window.
  3. I would then use string extract to extract the text after “Please submit for” and before “org model” as ​@Divya 5247 recommended, and store that in a variable

Hope this helps!


Forum|alt.badge.img+3
  • Author
  • Cadet | Tier 2
  • February 16, 2025

This is happy path approch can we implement any AI actions?


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • February 17, 2025

@AjijMujawar In your three descriptions what should be extracted for each scenario? (just to think about the “unhappy” path)


Forum|alt.badge.img+3
  • Author
  • Cadet | Tier 2
  • February 17, 2025

1. CARDIO VASCULAR, CV-STRUCTURAL HEART 

2.CRDM, AFI, AFS CRDM, CRYOCATH

3.MITG

These are orgs that we need to capture from desc.


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • February 17, 2025

@AjijMujawar What about that one:

 

 

 

 

 


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • February 17, 2025

@AjijMujawar with “If no match found, return:” set to “Source String” it should work I guess


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • Answer
  • February 17, 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😆)

 

 

 

 


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • February 17, 2025

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

Cheers

Marc


Dineshkumar Muthu
Flight Specialist | Tier 4
Forum|alt.badge.img+9
  • 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.


Forum|alt.badge.img+3
  • Author
  • 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
Forum|alt.badge.img+17
  • 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 


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • February 18, 2025

@AjijMujawar 

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

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

Forum|alt.badge.img+3
  • Author
  • 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...