Need ms access query created
$2-10 USD / hour
Below you see the contents of an msaccess 2010 field named path on different records.
1121212\qsdqsdqs\blabbla\[url removed, login to view]\qsdqsdqsdqsdqs
1121212\qsdqsdqs\blabbla\test_1.2\qsdqsdqsdqsdqs
1121212\qsdqsdqs\blabbla\test_3.4\qsdqsdqsdqsdqs
From the path I need to extract the strings [url removed, login to view], test_1.2, test_3.4, etc.
I want to do this with a query using string operations but I don't achieve doing it.
As you can see the following criteria can be used to find the string.
It should contain an underscore (it's the only string that contains an underscore), before the strings there is an "\" character and after the string there is an "\" character as well.
I need for the query to be created.
Project ID: #4129248
About the project
Awarded to:
Hi, I have created the query to get this output. I can give you the solution in few minutes.
8 freelancers are bidding on average $11/hour for this job
This would be better done in a small function that could be called from within a SQL statement.
Hi, Ms Access expert having 8+ years of experience. Please see your PM for more details and know more about us..
