edits

[Richard D. Williams]

Nancy,

I have been trying to work this out.

I have to edits that need to wokr together and I just can not determine 
how to do  it.

Here are the edits;

CHR:"!"-"~"
UPL:~CHR _ [{CHR}]
UPLOW:[{" "}] [{ UPL {" "} }] [UPL]
NOPUNC1:!"~"!<" "> | !"~"!<" "> | !"!"!<" "> | !"@"!<" "> | !"#"!<" "> | 
!"$"!<" "> | !"%"!<" "> | NOPUNC2
NOPUNC2:!"^"!<" "> | !"&"!<" "> | !"*"!<" "> | !"("!<" "> | !")"!<" "> | 
!"_"!<" "> | NOPUNC3
NOPUNC3:!"+"!<" "> | !"-"!<" "> | !"="!<" "> | !"`"!<" "> | !"|"!<" "> | 
!"."!<" "> | NOPUNC4
NOPUNC4:!"/"!<" "> | !";"!<" "> | !"'"!<" "> | !"["!<" "> | !"]"!<" "> | 
!"\"!<" "> | NOPUNC5
NOPUNC5:!"<"!<" "> | !">"!<" "> | !"?"!<" "> | !"{"!<" "> | !"}"!<" "> | 
!"|"!<" "> | NOPUNC6
NOPUNC6:!"1"!<" "> | !"2"!<" "> | !"3"!<" "> | !"4"!<" "> | !"5"!<" "> | 
!"6"!<" "> | !"7"!<" "> | !"8"!<" "> | !"9"!<" ">

Here are my tests.

TEST1   : { NOPUNC1  | * }
this is @ test 1 3
Results: this is  test

TEST2   : UPLOW & TEST1
this is @ test 1 3
Results: THIS IS  TEST

Why am I getting all caps on TEST2?

Richard

On 9/12/2019 10:21 AM, Nancy Palmquist via Filepro-list wrote:
> Richard,
>
> Looks like he replaced _ with space - Just reverse that to replace 
> spaces with _
>
> You might have to add some punctuation to the list also.
>
> I use this edit to dump punctuation.  It might help to build a more 
> complete list
>
> wipeout◄{!/!|!,!|!.!|!:!|!$!|!"'"!|!#!|!&!|!-!|!"("!|!")"!|!"\"!|!"_"!}
>
> Obviously remove the _ from the list since you want an underscore for 
> the spaces.
>
> Changing Spaces to underscores might be an issue if your data is 
> shorter than your field, since it will fill to the end with underscore.
>
> I fussed around and got stuck with the uppercase first letter.  I 
> found the uplow edit which I don't think is standard in filePro. But I 
> could not get it to work in conjunction with the other requirements.  
> My edit skills are not as good as some others might offer.
>
> upl    ◄~CHR _ [{CHR}]
> UPLOW  ◄[{" "}] [{ UPL {" "} }] [UPL]
>
> I know it is not a full solution but it might help.
>
> Nancy
>
> On 9/11/2019 4:19 PM, Richard D. Williams via Filepro-list wrote:
>> DAVE  UPLOW | {!"_"!<" "> | !"<"! | !","! | !">"! | !"\"! | !"."! | 
>> !";"! | * }
>>
>> I created this in a test edit table.
>>
>> Tested fine.
>>
>> Richard
>>
>> On 9/11/2019 1:49 PM, davidrottkamp via Filepro-list wrote:
>>> Hi
>>>
>>> does anyone have an edit that will
>>>
>>> 1) eliminate punctuation marks and symbols   <,>/.; ect from entry
>>> 2) uppercase first letter of each word
>>> 3) and replace spaces with an _
>>>
>>>
>>
>>
>> ---
>> This email has been checked for viruses by AVG.
>> https://www.avg.com
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20190921/a6af343f/attachment.html>