<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Mike, <div><br></div><div>Try searching for values either “less than” 0 or “greater than” 9 (or how many ever 9’s complete the edit type). I cannot recall if it is considered greater or less than, but I have run into this in the past. Good luck. <br><div>
<div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);"><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">James Flanagan</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="text-decoration: underline;"><a href="http://Flantec.com/">Flantec.com</a></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="color: rgb(121, 121, 121);">email:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:James@Flantec.com"><span style="color: rgb(0, 106, 227);">James@Flantec.com</span></a></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">mobile:<span class="Apple-tab-span" style="white-space: pre;"> </span>760-458-8498</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">home: <span class="Apple-tab-span" style="white-space: pre;"> </span>219-221-6219</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="color: rgb(121, 121, 121);">text:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:7604588498@txt.att.net"><span style="color: rgb(0, 106, 227);">7604588498@txt.att.net</span></a></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">Skype:<span class="Apple-tab-span" style="white-space: pre;"> </span>Flantec</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="color: rgb(121, 121, 121);">ichat:<span class="Apple-tab-span" style="white-space: pre;"> </span><span style="color: rgb(0, 106, 227);"><a href="mailto:James@Flantec.com">James@Flantec.com</a><span class="Apple-tab-span" style="white-space: pre;"> </span></span></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">home:<span class="Apple-tab-span" style="white-space: pre;"> </span>1901 Cidermill Road</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);"><span class="Apple-tab-span" style="white-space: pre;"> </span>Michigan City, IN 46360</div><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class="Apple-interchange-newline"></span><span><img alt="PastedGraphic-1.tiff" src="cid:E6A45117-C06D-4883-A671-77F5B7D04E70"></span>
</div>
<div><br><blockquote type="cite"><div>On Apr 5, 2023, at 11:14 PM, Mike Schwartz via Filepro-list <filepro-list@lists.celestial.com> wrote:</div><br class="Apple-interchange-newline"><div><div> One of my customers entered some bad data into their databases that<br>caused /D0 (divide by zero) and /OV errors in a lot of records. All of the<br>fields involved have numeric edits such as (6,#), (10,.2), etc.<br><br><br><br> Other than manually eyeballing several thousand records for fields that<br>show either /D0 or /OV, I was trying to use "Scan for Records" to search for<br>all the damaged records; something like:<br><br><br><br> Field Number: 3 │ Allocated Quantity <br><br>Enter Relationship: co │ contains<br><br> Enter value: /D0│ <br><br><br><br> However, that doesn't work because I can't put /D0 or /OV in as a<br>field value. <br><br><br><br> I tried to write a sort/selection processing that puts the numeric<br>value into a non-numeric dummy field, then search that for /D0 or /OV, but<br>that didn't work:<br><br><br><br> If:<br><br>Then: ZZ(10,*)=3<br><br> If: ZZ co "D0" or ZZ co "OV"<br><br>Then: SELECT; msgbox "Found record" <@RN<br><br><br><br> Any suggestions?<br><br><br><br>Thanks!<br><br><br><br>Mike Schwartz<br><br><br><br><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20230405/6c078b91/attachment.htm><br>_______________________________________________<br>Filepro-list mailing list<br>Filepro-list@lists.celestial.com<br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br></div></div></blockquote></div><br></div></body></html>