My input is Excel file --
CPT ICDCOVERED
87088 003.1 -- some cells have only single values
038.0,038.10-038.11,038.19,038.2,038.3,038.40-038.44,038.49,038.8,038.9 -- some cells have both comma ',' seperated as well as ranges ' - '
276.2, 278.1 -- some values are comma seperated
276.4 - 276.9 --some values are ranges separeted by ' - ' ranges
286.6
88037 034.02, 103.04 -- when there is comma beween the values it should load the values in seperate cells.
023.01, 123.03
201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell with its corresponding values of CPT (fisrt column)
Excepted Output Excel file---
CPT ICDCOVERED
87088 003.1
87088 038.0
87088 38.10-038.110 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
87088 038.19
87088 038.2
87088 038.3
87088 038.40-038.44 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
87088 038.49
87088 038.8
87088 038.9
87088 276.2
87088 278.1
87088 276.4
87088 286.6
88037 034.02
88037 103.04
88037 023.01
88037 123.03
88037 201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
I need to organize the Excel before I am using a ELT tool to load the values from Excel to SQL SERVER, but first I need to organize the Excel values so that it can be loaded properly.
I am also attaching the Excel sample file.
Thanks , I would really appreciate your help.
Ali
CPT ICDCOVERED
87088 003.1 -- some cells have only single values
038.0,038.10-038.11,038.19,038.2,038.3,038.40-038.44,038.49,038.8,038.9 -- some cells have both comma ',' seperated as well as ranges ' - '
276.2, 278.1 -- some values are comma seperated
276.4 - 276.9 --some values are ranges separeted by ' - ' ranges
286.6
88037 034.02, 103.04 -- when there is comma beween the values it should load the values in seperate cells.
023.01, 123.03
201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell with its corresponding values of CPT (fisrt column)
Excepted Output Excel file---
CPT ICDCOVERED
87088 003.1
87088 038.0
87088 38.10-038.110 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
87088 038.19
87088 038.2
87088 038.3
87088 038.40-038.44 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
87088 038.49
87088 038.8
87088 038.9
87088 276.2
87088 278.1
87088 276.4
87088 286.6
88037 034.02
88037 103.04
88037 023.01
88037 123.03
88037 201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
I need to organize the Excel before I am using a ELT tool to load the values from Excel to SQL SERVER, but first I need to organize the Excel values so that it can be loaded properly.
I am also attaching the Excel sample file.
Thanks , I would really appreciate your help.
Ali