Ah the joys of concatenation (real word)...
You can do this in MS Access, but it takes a fairly good knowledge of queries. In addition to fields from tables, queries can include "expressions" which can be derived from the information in fields (using functions), and other characters mixed together. You can also use these functions to split an item into its component parts, and then use the "Make Table Query" function to create a new table. Then make a new query to put them back together into your new format.
For example, you could use the use "Left" function to get the leftmost 3 characters, then insert a ".", then skip a few spaces and get the next couple of characters, etc.
It takes some playing around to get the formats right, and the format has to be exactly the same for each item in the source file. I'd consult the Access guru at your office...
I hope that answer made some kind of sense to someone out there... You kind of have to wade right into Access - make a copy of your data and you can't hurt anything.
GeogPlanner said:
Oh Throbbing Brain®...
Does anyone know a way to convert 20 character SBLs into a tax map number?
(16801300020090000000 --> 168.13-2-9) I once knew someone who could do it through MS Access, but I'm not too up on how she did it.
