<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-text-plain" wrap="true" style="font-family:
-moz-fixed; font-size: 15px;" lang="x-western">
<pre class="moz-quote-pre" wrap="">Richard - please look again at the sample code I supplied. Look at the assignment and the length and edit of "da". What happens to the hyphens when filepro automatically converts it to a 6,mdy date field?
Bruce
--- Richard replied with ---
Bruce,
The field is already a date field. filePro except the hyphen (dash) with the date edit.
I may have to use either xlate() or replace() to fix these field values. I may need to insure that no hyphens are used in date fields even though the edit(from filePro) allow it.
I may have to write my own date edit to correct this issue but that seems to be a waste of time. Just be simpler to manually correct the few records that have hyphens.
Thanks for responding.
It looks like version 1 of FP web is not where it should be.
Richard
</pre>
<blockquote type="cite" style="color: #000000;">
<pre class="moz-quote-pre" wrap="">-----Original Message-----
From: Filepro-list [<a class="moz-txt-link-freetext" href="mailto:filepro-list">mailto:filepro-list</a>-
<a class="moz-txt-link-abbreviated" href="mailto:bounces+rkreiss=verizon.net@lists.celestial.com">bounces+rkreiss=verizon.net@lists.celestial.com</a>] On Behalf Of Bruce Easton via
Filepro-list
Sent: Tuesday, July 16, 2019 4:12 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>
Subject: Re: doedit
It probably could be done with edits, but why not just use date fields to make the
data uniform:
Then: da(6,mdy)=8; 8=da
(assuming that field 8 is declared as 8,mdy/)
On 7/16/19 2:58 PM, Richard Kreiss via Filepro-list wrote:
</pre>
<blockquote type="cite" style="color: #000000;">
<pre class="moz-quote-pre" wrap="">In a date field (8,mdy/) a few entries use a - rather than a slash i.e. 04-18-18
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">rather then 04/18/18. As filePro excepts the dash- in the date field, will doedit
change the - to a slash /?
</pre>
<blockquote type="cite" style="color: #000000;">
<pre class="moz-quote-pre" wrap="">If so, how would one write the program line? The date field is field 8 in the
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">file. As there are only a few (14) out of 839 records, I could either write a
process to update just those records or add the doedit to a lookup which uses
this field.
</pre>
<blockquote type="cite" style="color: #000000;">
<pre class="moz-quote-pre" wrap="">Lookup filed is kah(8) which sets dummy field ds. Ds=kah(8).
-------------- next part -------------- A non-text attachment was
scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 11891 bytes
Desc: not available
URL:
<<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190</a>
716/fc227612/attachment.bin>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
---
This email has been checked for viruses by Avast antivirus software.
<a class="moz-txt-link-freetext" href="https://www.avast.com/antivirus">https://www.avast.com/antivirus</a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
</div>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
<tr>
<td style='border:none;padding:0px 15px 0px 8px'>
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">
<img border=0 src="https://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo" />
</a>
</td>
<td>
<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
This email has been checked for viruses by Avast antivirus software.
<br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a>
</p>
</td>
</tr>
</table>
<br />
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>