Replacing Columns within a Table

[BobRoberts]

I have 4 rows below in file tblTEST, and I want to be able to transfer the CODE from the MAIN location to the INT location (replacing all existing "A" codes), preceeded by an "I".

ID LOC CODE
-- ----- ------
11 MAIN B
11 INT A
22 MAIN C
22 INT A

I want the result to be:

ID LOC CODE
-- ----- ------
11 MAIN B
11 INT IB
22 MAIN C
22 INT IC

I am stumped as to how to do this - any help or advice would be appreciated. Also, is there any way to post in a non-proportional font such as Courier New on the forum so the above example is more readable?

[ck9663]

I have 4 rows below in file tblTEST, and I want to be able to transfer the CODE from the MAIN location to the INT location (replacing all existing "A" codes), preceeded by an "I".

ID LOC CODE
-- ----- ------
11 MAIN B
11 INT A
22 MAIN C
22 INT A

I want the result to be:

ID LOC CODE
-- ----- ------
11 MAIN B
11 INT IB
22 MAIN C
22 INT IC

I am stumped as to how to do this - any help or advice would be appreciated. Also, is there any way to post in a non-proportional font such as Courier New on the forum so the above example is more readable?

I would assume you're paring each MAIN with INT based on ID. Is there any MAIN record with no INT record per ID?

Yes, you can. Use the TAG/WRAP on the edit window. It's one of those "sharp not equal" signs on the edit window.

-- CK