|
If you import the column into a text column as I suggested, then I think you should be able to use Bulk Search and Replace to populate the Y/N #status column based on the values in the #status_from_text column.
To my mind the values in column 6 look richer in terms of information content than a simple Y/N, so I would probably want to keep them, at least until the last minute. If I didn't want to keep them then I clear the column, then I'll have the column for next time I run a similar Import List.
If you massage the original sql database or the csv file how would you save the process - sql procedures and excel macros come to mind. But with Bulk S&R you can save the S&R for reuse which is something you already know about. I'm not even sure SQLite has stored procedures or an equivalent - David will know.
BR
|