I see you're on *nix -- any chance the slash in the phone numb
Dwayne:
I see you're on *nix -- any chance the slash in the phone number is being
interpreted as an escape character?
Just a Thought,
--Phil
----- Original Message ----
From: Dwayne Martin <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Monday, March 31, 2008 2:29:43 PM
Subject: Data Import clipping phone numbers
Hello Everyone,
We are a university and import our entire staff/student base into a
“GN:CustomerInfo” form. On this form are three phone numbers: Local Phone,
Home Phone, and Cell Phone. The data format for all three phone numbers is
“123/456-7890.” All are on the form as Char fields, with Input Length of 255.
But the Local Phone is getting cut off just before the “-“, so instead of
“123/456-7890” we are only getting “-7890.” Local Phone and Home Phone are
adjacent in the import file. If we switch places, Local Phone still gets
clipped. This suggests that the problem is in the field definition, not the
import file.
There no problem entering the correct data manually.
We get the same results whether we import from the Import tool or the Linux
command line.
Any suggestions?
(ARS 7.1, RH Linux server, Oracle 9.2 db)
Dwayne Martin
James Madison University
____________________________________________________________________________________
Like movies? Here's a limited-time offer: Blockbuster Total Access for one
month at no cost.
http://tc.deals.yahoo.com/tc/blockbuster/text4.com
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
