Combining two strings
Hi, I have 2 columns that contain strings in the following format: string1 = 1;0;2;0;0;8;0 string2 = 0;1;0;3;5;0;13 Note 1: Both strings contain the same number of ";" (but they are not necessarily the same length). Note 2: The two strings have 0's in alternating positions. Note 3: A string can contain two 0's in a row (separated by ";") as long as the other string have two non-zero terms in a...