Hey there!
I found another thread 701-797928 that talks about parsing data and how to get the information before a character, and a seperate one for how to get the data after a certain character, but would I would like to do is do both from the same field.
I have a field in a table where there is always a * vendor name - I would like to be able to pull the vendor name out of each column and put it into a new column in a query. The vendor name varies from row to row.
I tried putting both of these pieces of code together but all I ended up with was a zero in the new column.
Both bits of code I am using from that thread are:
Before the -
=Left([Vendor],InStr([Vendor],"-")-1)
After the *
=Mid([Vendor],InStr([Vendor],",")+1)
I found another thread 701-797928 that talks about parsing data and how to get the information before a character, and a seperate one for how to get the data after a certain character, but would I would like to do is do both from the same field.
I have a field in a table where there is always a * vendor name - I would like to be able to pull the vendor name out of each column and put it into a new column in a query. The vendor name varies from row to row.
I tried putting both of these pieces of code together but all I ended up with was a zero in the new column.
Both bits of code I am using from that thread are:
Before the -
=Left([Vendor],InStr([Vendor],"-")-1)
After the *
=Mid([Vendor],InStr([Vendor],",")+1)