Changing a fields edit type
scooter6 at gmail.com
scooter6 at gmail.com
Fri Jun 24 14:41:53 PDT 2016
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/58b1dc55/attachment.html>
More information about the Filepro-list
mailing list