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
Please submit for the CARDIO VASCULAR, CV-STRUCTURAL HEART org model
Please submit for CRDM, AFI, AFS CRDM, CRYOCATH org model(s)
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
Page 1 / 1
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.
@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.
I am capturing “Please submit for the CARDIO VASCULAR, CV-STRUCTURAL HEART org model” from SAP application as mentioned below
In this case, here’s an approach I would recommend
use a Recorder Package to capture the input field next to description
Then get the property that matches the entire string displayed in the window.
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!
This is happy path approch can we implement any AI actions?
@AjijMujawar In your three descriptions what should be extracted for each scenario? (just to think about the “unhappy” path)
1. CARDIO VASCULAR, CV-STRUCTURAL HEART
2.CRDM, AFI, AFS CRDM, CRYOCATH
3.MITG
These are orgs that we need to capture from desc.
@AjijMujawar What about that one:
@AjijMujawar with “If no match found, return:” set to “Source String” it should work I guess
@AjijMujawar This is better I guess: (forgot to add “Please submit for the” and “Please submit for” in my testing in above answer... Sorry)
@AjijMujawar let us know if this worked for you please…
Cheers
Marc
Hi @AjijMujawar
You can use Regex to extract the organization units from your sample descriptions.
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.
@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
@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?
)
