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