Crystal Reports Joining tables from one column to discrete columns

Message

   I have a report with a Main report and a Subreport. I am able to join those two without any issues.
The subreport contains two tables: A and B. 
     Table A has Column A1 and A2.
         Column A2 is what I am using to join to the Main Report.
         Column A1 is a string separated by ~
               A~B~C~D~E

     Table B has Columns W,X,Y and Z
               Column W (String)
               Column X (String)
               Column Y (Number)
               Column Z (Number)

I was able to split Column A into separate fields.
       B (output is string) is equivalent to Column W in Table B
       D (output is string) is equivalent to Column Y in Table B
       E (output is string) is quivalent to Column Z in Table B

I am interested in Column X from table B.

Aside from trying to link two tables together based on a string in a column to discrete columns on a another table, I am also having problems using variables that come out as a string from the split column and trying to join them to table B where the column is stored as a number.

Any help is greatly appreciated. 

I tried using shared variables and taking them from the subreport to the main report. Then adding a second subreport to get the data from Table B. I did not have any luck because of the different data types.