doedit

[Bruce Easton]

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

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Bruce Easton via
> Filepro-list
> Sent: Tuesday, July 16, 2019 4:12 PM
> To:filepro-list at lists.celestial.com
> 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:
>> In a date field (8,mdy/) a few entries use a - rather than a slash i.e. 04-18-18
> rather then 04/18/18.  As filePro excepts the dash- in the date field, will doedit
> change the - to a slash /?
>> If so, how would one write the program line?  The date field is field 8 in the
> 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.
>> 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:
>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20190
>> 716/fc227612/attachment.bin>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list