Address import help needed


#1

After further head scratching I finally figured out that where carriage returns were working in Pan 6, I had to substitute line feeds in PAN X. No idea why and no time to dwell on it, but the problem is resolved.

bk

I had a complex procedure in Pan 6 which used tagdata to find and format addresses copied from new customer order emails so they could be exported as a text file and then imported into our accounting software. Although the Pan 6 database appears error-free in Pan X, it doesn’t work. I’ve messed with it and can’t find the problem.

Rather than banging my head against the wall, I expect there may be a simpler way to get to the same result. Here is a sample of the text on the clipboard:

Ship Address:
Name: Jane Doe
Company: Beads by JD
Address Line 1: 14 Somewhere Rd. NE
City/State/Postal Code: Rio Rancho, NM 99999
Country: United States
Phone Number: 505-990-9539

Email: beader@yahoo.com

Bill Address:
Name: Jane Doe
Company: Beads by JD
Address Line 1: 14 Somewhere Rd. NE
City/State/Postal Code: Rio Rancho, NM 99999
Country: United States
Phone Number: 505-990-9539

Variations include international customers with province instead of state, and customers with multiple address lines.

The output needs to be tab delimited. I’ll try to attach a screen shot of the field names needed for the export format.

Any suggestions would be most welcome.

Thanks
Barry