I am trying to create an access query that will break a text string into sections based on a character within that string to isolate parts of the data within the text string.
Two types of strings that I need parsed out:
535SHANK-15CC broken out to “535SHANK” and “-“ and “15CC”
844BAR-14-M10B broken out to “844 BAR” and “-“ and “14” and “M10B”
In other words, the strings I need parsed are either *-*-* or *-* in format
Hello dear sir!
I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f
From the Microsoft Access, of course, familiar.