Hello, I have two data sources that I want to join. One of the sources comes from a oracle database and has a column named GAGE which contains Gage numbers that are of various lengths. The second data source is an excel file that has a column named GAUGE PREFIX which contains the prefix (first 4-5 letters of a Gage number).
For example from data source 1 I have:
And from data source 2 I have:
GAUGE PREFIX TYPE
I want to combine the sources to get a result like:
That helped a lot but some of the gauges don't have a "-" as a delimiter but a '/' or another character. Could I write the code with multiple delimiters or would I have to write another SubField() statement. If so could I call it the same name?