I have been trying to get the following done and need help on the logic, since I can’t find one. Here comes the issue described:
I have a request from many users who provide me a fixed location and a folder path within a ticket, my project gets this info from the ticket and saves it to a variable. The location is pretty standard and with some trimming I was able to get always the proper city name out of it, but the folder path is a bit of an issue, since the user can user the input and put whatever they want ( Not possible to standardize ), as of an example, it can be looking like any of this:
This information can be anything similar to what I have provided before as example, but the issue is that I was provided with an excel file where I have to first look within the location column ( that is easy ) and then based on the matching location by applying a filter which only lefts the rows for this location visible, there could be in between 1-30 possible folder existing from which I have the exact folder path as of example here:
The issue here is the folder path is almost never the same as in the provided excel file or contains more/less info as IP Address, DEPTOS$, Path letter or simbols /,:.
Is there a way to indicate the robot to filter/strip/etc the folder path in a way so it can counter check with the excel and find proper path if correct keyword by user was provided?
Ideas so far:
- Create a list/excel where I add specific strings which should be stripped from the folder path before checking with excel file to see if path can be found ( would not always be correct since I will not be able to anticipate each of the not needed characters a user can type into )
- strip always all the values and only leave the last 2 to check against the Excel, but this would also get sometimes errors on how to find the proper path if the user enters it incorrectly, example:
So not sure if there is any other better solution I am not seeing on how to solve this, the best would be to obligate the user to only be able to select the path from a drop down list, based on their available option on their location, but since this is not possible ( already asked ). Hope someone can help me with an idea or even provide a workflow I could try and see if that works!?
Thank you for the help in advance!