Text substitution problem
I need to synchronize data from two sources. Each contains a
concatenated field comprised of LastName_FirstName_Birthdate, which I
plan to use as a match field. Unfortunately, the sources format dates
differently. Thus:
Source A: Doe_John_03/09/2007
Source B: Doe_John_3/9/2007
I need either to remove initial zeros from the month and day of Source
A, or add them to Source B, all without disturbing non-initial zeros,
such as those in the year, or in months or days like 10/10/2007. Can
someone help?
Thanks,
dp
--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/