Modify ODBC output for use in another program

[techmon98]

Howdy folks,

My accounting system has an ODBC Driver.

I'm trying to integrate with UPS Worldship via ODBC.

However, my accounting system includes city, state, and zip in one field instead of separate data fields (the way Worldship wants it).

What's the best way to split the fields automatically so Worldship can access and have this automatically happen?

 

[SkipVought]

Hi,

Need more info. What database will determine the function/syntax for parsing your string.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}