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