Introducing PTWin

Introducing
PTWin32

Support Services
Support
Services

Downloads
Downloads

User Tips
User Tips

Contact Us
Contact Us

Introducing PTWin
Home

  PTWin User Tips / MANAGE DATA 

Pushing the Post Button

A Delimiter In The Works
A stray character can mess it up
Quotes & commas can't be exported with those delimeters

Tip #: 5.1.111
Ver(s):PTWin32, V2, V1

We help a lot of users import data into PTWin32 from all kinds of sources. Usually it’s some form of parcel, owner, contractor, license, or permit data that comes from a legacy system or another department like the Tax Assessor.

There are many formats used to exchange data between systems. One of the more popular is a form of ASCII delimited text file that uses quotes and commas to indicate values and fields. For example, a name and phone number might look like this: “ABC Company”,”(123) 456-7890”.

When we open this file we use the quotes and commas to determine the structure of the data. If the data itself contains any of the delimiting characters then this process is thrown off. For example, a record like: “ABC, Inc.”,”(123) 456-7890” might indicate that the comma between [ABC] and [Inc.] is the beginning of a new field.

This can also be a problem with proper name fields that use nicknames like: “Charlie “Yardbird” Parker”,”(123) 456-7890”.

If it is your plan to have us review your source data and you want to send it to us in an ASCII quote-comma-quote format you must first ensure that there are no quotes or commas in any of the field values you plan to send.

Many times we can work around these problems but there is no guarantee of that. If you want to make sure of your data’s integrity sweep it for delimiting characters before you export it from the source system. This will save time and effort, and speed your import process.

 

 

Return to Managing Data menu