For safety sake, make a back up copy of your file first, then show all reocords or perform a find to pull up a found set of the records to update. Now you can use Replace field contents with the calculation option to copy the data from one field to the other.
Hi, thank you, but I forgot to specify that my data is text.
Again, what I want to do is:
in a subset of my data the column "stock number" is empty, while the information that would belong to that column (=the stock number "TEXT####") is in a column headed "comment". Of course I can easily isolate the subset by searching for "TEXT". However, using the "Records -> replace field contents -> replace with calculated result doesn't work, if thats what you meant.
Thank you, S.
@Stella - could you post your calculation, that might help. Are you getting an error? The Replace via Calculation method is the most logical and it would be good to figure out why it's not working.
If you are in a hurry there is another method that can be used (try it in a backup copy first to check results).
- Export three fields, Your Primary Unique Key Field, Stock Number Field, Comment field for the found set.
- Open the export file in Excel.
- Review the changes you want to make sure the result is the desired one.
- Delete the unused column so that only two remain, the key field and the field containing the data to be updated
- Change the name of the data field to be the field in the FM file where it belongs
- Do a file import from the file menu selecting the updated Excel file
- In the "Import Field Mapping" dialog box ensure you use "Update Matching Records in Found Set", that "Don't Import First Record (Contains Field Names)" is checked, the match the field names and set the Key field for "Matching Records based on this field".