I am using bar tender hooked up to a MS Access DB to print labels. I
have a problem with the Access table. The problem is that the "Ship
to" field is written like this:
Warehouse "adidas, Ltd." /142181, MOSKOVSKAYA OBLAST,/KLIMOVSK,
BEREGKOVSKYI/PROEZD 17-A 38290
I need it formated like this:
Warehouse "adidas, Ltd."
142181, MOSKOVSKAYA OBLAST,
KLIMOVSK, BEREGKOVSKYI/PROEZD 17-A 38290
My question is, how can I break this up. I can add columns to my DB
as
address 1
address 2
address 3
and so on, but I need to be able to read between the "/". Also,
bartender as a spot for VB, so I may be able to break it up inside the
app. But I still don't know how to read only between the "/".