eDBtC TIPS and Tricks
Split Excel Code/Value Columns from decoded data download spreadsheets
The new Data Download (decoded) tab of enhanced Data back to Center (eDBtC) now gives you columns that contain both the encoded data and the value string of the same data. Here are some examples of code/value columns:
You can use the Data feature in Excel to parse these data types into separate columns. Once you have downloaded the data into an Excel spreadsheet, follow the steps below using Transplant Type as an example to separate its code value (1) from its string description value ("ALLO - Allogeneic"):
- Select the column that contains the text you want to split.
- Insert an empty column to the right of the column that contains the values you want to split or identify two empty columns where you'd like the split values to go.
- Click the Data menu item followed by Text to Columns.
- The 'Convert Text to Columns Wizard' will appear. Select the Delimited radio button and click the Next button.
- Click the Semicolon option under the Delimiters checkbox selection area. Click the Next button.
- In the following step, select either General or Text in the Column data format selection area. If you leave the default value in the Destination: text box the code value will remain in the current column and the Description or Value will be copied into the adjacent empty column to the right. Otherwise, modify the cell reference to suit your preference for placement of the Value column contents. If you have two empty columns where you'd like the split columns to be placed for example at the end of the spreadsheet, type that reference into the Destination: text box. If your spreadsheet goes from column "A" through column "F" and you want the split values to go into columns "G" and "H", type $G$1 into the Destination: text box.
- Click the Finish button to complete the split.
- The results should look like the following:
You can modify the column headings to suit requirements for definition of the column values: