December 24, 200421 yr I am importing data into a new database from an old database. The text in some of the fields doesn't match the new database. I know I can do a Case script, and that works to a point. The problem I'm running into is sometimes the data in the specific field is not wrong, but the case script still changes it. Am I missing something. Here is what I have Case ( Data Files::Mov3 = "Old" ; "
December 25, 200421 yr I think you will need to include (something along the lines of) PatternCount(Data Files::Mov3,"Old") in the Case statement to check for the string "Old" in the field. Otherwise unless the field contained ONLY "Old" it would fail. I think.
Create an account or sign in to comment