Problem importing 1 field (phone)
Richard D. Williams
richard at appgrp.net
Thu Jul 26 12:26:11 PDT 2018
First try it without any cast on ph. That should work.
Then look at the data from the spreadsheet. Make sure there is no
carriage return embedded.
z=""{data(3)
You can check it like this;
z co chr("13")
msgbox "oops!"
You can correct it like this;
z co chr("13")
z=xlate(z,chr("13"),"")
Then do this;
ph(8,#)=""{z
Richard D. Williams
On 7/26/2018 10:55 AM, Mike Schwartz via Filepro-list wrote:
>> This is a phone number field cell in the form of nnn-nnnn. I wrote a
>> program to import just that field but it failed to import the data except
> in a
>> few cases. My phone number field is (8,#). The import field is ph and
> has
>> not been "cast".
>>
>> Richard Kreiss
> I would think you can use the built-in "phone" edit. Try casting the
> phone number field as PH(14,phone).
>
> Mike Schwartz
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
>
More information about the Filepro-list
mailing list