<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#330099" bgcolor="#FFFFFF">
<tt>Richard,<br>
<br>
Looks like he replaced _ with space - Just reverse that to replace
spaces with _<br>
<br>
You might have to add some punctuation to the list also.<br>
<br>
I use this edit to dump punctuation. It might help to build a
more complete list<br>
<br>
wipeout◄{!/!|!,!|!.!|!:!|!$!|!"'"!|!#!|!&!|!-!|!"("!|!")"!|!"\"!|!"_"!}<br>
<br>
Obviously remove the _ from the list since you want an underscore
for the spaces.<br>
<br>
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.<br>
<br>
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.<br>
<br>
upl ◄~CHR _ [{CHR}]<br>
UPLOW ◄[{" "}] [{ UPL {" "} }] [UPL]<br>
<br>
I know it is not a full solution but it might help.<br>
<br>
Nancy<br>
</tt><br>
<div class="moz-cite-prefix">On 9/11/2019 4:19 PM, Richard D.
Williams via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:ff84a665-be45-90b9-412e-c44d275926c0@appgrp.net">DAVE
UPLOW | {!"_"!<" "> | !"<"! | !","! | !">"! | !"\"! |
!"."! | !";"! | * }
<br>
<br>
I created this in a test edit table.
<br>
<br>
Tested fine.
<br>
<br>
Richard
<br>
<br>
On 9/11/2019 1:49 PM, davidrottkamp via Filepro-list wrote:
<br>
<blockquote type="cite">Hi
<br>
<br>
does anyone have an edit that will
<br>
<br>
1) eliminate punctuation marks and symbols <,>/.; ect
from entry
<br>
2) uppercase first letter of each word
<br>
3) and replace spaces with an _
<br>
<br>
<br>
</blockquote>
<br>
<br>
---
<br>
This email has been checked for viruses by AVG.
<br>
<a class="moz-txt-link-freetext" href="https://www.avg.com">https://www.avg.com</a>
<br>
<br>
_______________________________________________
<br>
Filepro-list mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
<br>
Subscribe/Unsubscribe/Subscription Changes
<br>
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>