 | |
Texttodate, yyyymmdd -> mm/dd/yyyy
comp.databases.filemaker comp.databases.filemaker
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Texttodate, yyyymmdd -> mm/dd/yyyy -
10-20-2005
, 10:51 AM
|
In article <5JmdnXW0zqjsPsreRVn-sg (AT) comcast (DOT) com>, Bill Marriott wrote: And you can avoid the need for an additional field by using the Replace command. Start out with date_old as a text field. Specify a calculated result in the replace. Then change date_old to a date field. Bill How do I access that? I tried using replace as part of a calculation, but it fails with a circularity error. Replace( Date_sold,0,8, Date( Middle(Date_sold, 5, 2), Middle(Date_sold, 7, 2), Left(Date_sold, 4) )) Understandable. I would think that there would be some sort of replace command in the edit menu, but there is only find/replace, which seems to deal with literals, not the command set. Is this new functionality since FM6.0? |
#12
| |||
| |||
|
|
I would think that there would be some sort of replace command in the edit menu, but there is only find/replace, which seems to deal with literals, not the command set. Is this new functionality since FM6.0? |
either repeat the literal text in the cur5rent field across all records,
fill the current field with serial numbers across all records, or
specify a calc whose results are to be populated across all records.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance
#13
| |||
| |||
|
|
In article <5JmdnXW0zqjsPsreRVn-sg (AT) comcast (DOT) com>, Bill Marriott wrote: And you can avoid the need for an additional field by using the Replace command. Start out with date_old as a text field. Specify a calculated result in the replace. Then change date_old to a date field. Bill How do I access that? I tried using replace as part of a calculation, but it fails with a circularity error. Replace( Date_sold,0,8, Date( Middle(Date_sold, 5, 2), Middle(Date_sold, 7, 2), Left(Date_sold, 4) )) Understandable. I would think that there would be some sort of replace command in the edit menu, but there is only find/replace, which seems to deal with literals, not the command set. Is this new functionality since FM6.0? |
But
*** BE VERY CAREFUL **
There's no Undo, so it's very easy to destroy data using the Replace
command and you should always MAKE A BACKUP FIRST (or at least test on
a very small Found Set that you can manually repair).
The process is:
- click in the field you want to use Replace on
- if you want to Replace the field's data in all found
records with the same static data, type the new static
data into the field
- choose Replace from the Records menu
- in the window that appears you will see that it has
defaulted to "replace contents of FieldX with {typed data}"
- if that is correct you can click Replace and FileMaker will
enter the typed data into that field for EVERY record in the
Found Set
- other options in the window allow you to replace the data
with either a Serial number (which increments with each
record) or using a calculation.
** ALWAYS DOUBLE-CHECK ***
Make sure the Replace is doing EXACTLY what you want.
In your case you can click in the existing Date_sold field and use the
calculation option with
Date( Middle(Date_sold, 5, 2),
Middle(Date_sold, 7, 2),
Left(Date_sold, 4)
)
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
#14
| |||
| |||
|
|
In article <pXN5f.121$uo3.40133 (AT) newshog (DOT) newsread.com>, Adam Price Adam-price (AT) rcn (DOT) com> wrote: In article <5JmdnXW0zqjsPsreRVn-sg (AT) comcast (DOT) com>, Bill Marriott wrote: And you can avoid the need for an additional field by using the Replace command. Start out with date_old as a text field. Specify a calculated result in the replace. Then change date_old to a date field. Bill How do I access that? I tried using replace as part of a calculation, but it fails with a circularity error. Replace( Date_sold,0,8, Date( Middle(Date_sold, 5, 2), Middle(Date_sold, 7, 2), Left(Date_sold, 4) )) Understandable. I would think that there would be some sort of replace command in the edit menu, but there is only find/replace, which seems to deal with literals, not the command set. Is this new functionality since FM6.0? The Replace command can be found in the Records menu. But *** BE VERY CAREFUL ** |
Crap. Don't I know it. I messed this up this morning, because it
actually wasn't my database, it was my mother's, and we made some little
mistake somewhere doing this over the phone. She isn't that computer
savvy, and we spent three hours trying to find a backup - in fact we
can't even find the one we are working on on the hard drive - I think my
dad had opened it directly out of mail and never re-saved it.
We looked for four hours over the phone, then gave up.
We are having to go back to a version from a few days ago - not the end
of the world, but very frustrating.
I am not used to the FM system where changes are saved instantly - I was
expecting that if we made a mistake, we would close without saving.
oops.
Not your (collective) faults, though - I do appreciate your help.
-Adam
#15
| |||
| |||
|
|
Crap. Don't I know it. I messed this up this morning, because it actually wasn't my database, it was my mother's, and we made some little mistake somewhere doing this over the phone. |
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.