djbleaks
09-22-2010, 07:58 AM
Hello all,
I have four columns with different attributes I am trying to concatenate into one column. The problem is, one of these columns has fields with an "&" symbol and proceeding name that I would not like to include in the final merged field. For example, there is:
Joe & Joan | B. | Smith | Jr.
Tim | C. | Tiny | III.
and I would like:
Joe B. Smith, Jr.
Tim C. Tiny, III.
So the question is, how can you remove "& Joan" (or & ANYCHAR)? If it can be done in a separate step (aside from final concatenate) that would work too. Any help or feedback is appreciated!
Thank you
I have four columns with different attributes I am trying to concatenate into one column. The problem is, one of these columns has fields with an "&" symbol and proceeding name that I would not like to include in the final merged field. For example, there is:
Joe & Joan | B. | Smith | Jr.
Tim | C. | Tiny | III.
and I would like:
Joe B. Smith, Jr.
Tim C. Tiny, III.
So the question is, how can you remove "& Joan" (or & ANYCHAR)? If it can be done in a separate step (aside from final concatenate) that would work too. Any help or feedback is appreciated!
Thank you