Changing a fields edit type

scooter6 at gmail.com scooter6 at gmail.com
Fri Jun 24 18:26:20 PDT 2016


How do you make an edit that doesn't allow:
! @ # $ % ^ & * ( ) - _ \ { } [ ] ? . , -- any 'special' character??
Not sure how to accomplish that.....

Scott
PDM

On Fri, Jun 24, 2016 at 5:41 PM, scooter6 at gmail.com <scooter6 at gmail.com>
wrote:

> Is there a way to write the edit that it doesn't delete characters and
> move all other characters together?
> i.e.  If someone has   1234 Main St,Apt.123    I don't want the edit to
> make it  1234 Main StApt123
> Rather I'd like it to be  1234 Main St Apt 123
> My current edit    {!","! | !"."! | !"#"! | !"*"! | *}   would replace the
> special characters
> I know I won't be able to cure all input type mistakes but I'd rather have
> 2 spaces in some instances, rather than the words running together....
>
> thanks
>
>
> On Fri, Jun 24, 2016 at 12:14 PM, scooter6 at gmail.com <scooter6 at gmail.com>
> wrote:
>
>> Ken,
>>
>> Meaning if I go to Define Files and change it there, correct?
>> I forgot it will go through and restructure / modify the fields after
>> saving changes there...
>>
>> thanks
>> Scott
>>
>> On Fri, Jun 24, 2016 at 10:43 AM, Kenneth Brody <kenbrody at spamcop.net>
>> wrote:
>>
>>> On 6/24/2016 9:30 AM, scooter6--- via Filepro-list wrote:
>>> [...]
>>>
>>>> Obviously I can change the edit types without any pain.....but how can I
>>>> 'enforce' the edit change?
>>>> IIRC, just changing the edit type won't 'edit' the existing records,
>>>> right?
>>>>
>>> [...]
>>>
>>> Changing a field's edit in ddefine will go through every existing record
>>> and apply the new edit.
>>>
>>> I'd strongly recommend making a backup first, and double-checking the
>>> new edit.  Any existing records where the data fails the new edit will end
>>> up with a blank field.
>>>
>>> --
>>> Kenneth Brody
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160624/ef5812da/attachment.html>


More information about the Filepro-list mailing list