<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Nancy,<br>
<br>
I have been trying to work this out.<br>
<br>
I have to edits that need to wokr together and I just can not
determine how to do it.<br>
<br>
Here are the edits;<br>
<br>
<font face="Courier New, Courier, monospace">CHR:"!"-"~"<br>
UPL:~CHR _ [{CHR}]<br>
UPLOW:[{" "}] [{ UPL {" "} }] [UPL]<br>
NOPUNC1:!"~"!<" "> | !"~"!<" "> | !"!"!<" "> |
!"@"!<" "> | !"#"!<" "> | !"$"!<" "> |
!"%"!<" "> | NOPUNC2<br>
NOPUNC2:!"^"!<" "> | !"&"!<" "> | !"*"!<" ">
| !"("!<" "> | !")"!<" "> | !"_"!<" "> | NOPUNC3<br>
NOPUNC3:!"+"!<" "> | !"-"!<" "> | !"="!<" "> |
!"`"!<" "> | !"|"!<" "> | !"."!<" "> | NOPUNC4<br>
NOPUNC4:!"/"!<" "> | !";"!<" "> | !"'"!<" "> |
!"["!<" "> | !"]"!<" "> | !"\"!<" "> | NOPUNC5<br>
NOPUNC5:!"<"!<" "> | !">"!<" "> | !"?"!<"
"> | !"{"!<" "> | !"}"!<" "> | !"|"!<" "> |
NOPUNC6<br>
NOPUNC6:!"1"!<" "> | !"2"!<" "> | !"3"!<" "> |
!"4"!<" "> | !"5"!<" "> | !"6"!<" "> |
!"7"!<" "> | !"8"!<" "> | !"9"!<" "><br>
</font><br>
Here are my tests.<br>
<br>
<font face="Courier New, Courier, monospace">TEST1 : { NOPUNC1 |
* }<br>
this is @ test 1 3 <br>
Results: this is test</font><br>
<br>
<font face="Courier New, Courier, monospace">TEST2 : UPLOW &
TEST1</font><br>
<font face="Courier New, Courier, monospace">this is @ test 1 3<br>
Results: THIS IS TEST</font><br>
<div class="moz-cite-prefix"><br>
Why am I getting all caps on TEST2?<br>
<br>
Richard<br>
<br>
On 9/12/2019 10:21 AM, Nancy Palmquist via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:45452867-b735-1549-9543-8a167d49d823@vss3.com">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>
<br>
On 9/11/2019 4:19 PM, Richard D. Williams via Filepro-list wrote:
<br>
<blockquote type="cite">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>
</blockquote>
<br>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br />
<table style="border-top: 1px solid #D3D4DE;">
<tr>
<td style="width: 55px; padding-top: 13px;"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td>
<td style="width: 470px; padding-top: 12px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: #4453ea;">www.avg.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>