Search results

OK so I have two different data sets. Set one the largest string count is three. Using the union function I used this VBA I found: Public Function ParseText(TextIn As String, X) As Variant On Error Resume Next Dim var As Variant var = Split(TextIn, ";", -1) ParseText = var(X) End Function I...

The data is what it is. It is back end data for a program we use. I need to figure out a way to work with it. I do not want to export and re-import data to and from Excel if I do not have to. I thought of using unions but again, I would have to do a union for as many strings there are and that...

I am sorry for not stating this originally, the data is in Access. I updated my original post.

"Unconcatenating" Data In A Field - Access Good morning. I have an Access table with data in two fields - __F1__|______F2______ Name1 | 47;1295; Name2 | Name3 | 1412;1893;1912 Name4 | 14;1492;1812 Name5 | 1247;1298 The names in F1 will always be unique There might be some overlap in F2. If...

Hello all. I have lurked around for a while using Google searches. I figured I would finally set up an account. I currently work in the automotive industry. Aftermarket auto parts to be exact. I work with data files. I build data files that tell you what applications part X fits. I am...