edits

[Nancy Palmquist]

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

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com

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