Split yearQuarter

• susmitha117

  SSC Eights!

  Points: 890

  More actions

  September 8, 2014 at 8:15 am

  #310706

  Hi,

  I have 2 columns

  yearquarter|year|quarter

  2014q3 | |

  i want to get data for year column as 2014 and quarter q3 using yearquarter column using ssis.

  if i am not clear let me know

• rxm119528

  SSCrazy

  Points: 2960

  More actions

  September 8, 2014 at 9:10 am

  #1743891

  Add 2 derived columns and use the expressions

  RIGHT([yearquarter],2 )

  LEFT([yearquarter],4 )

  Just realized there is not left function is SSIS

  better use the substring

  SUBSTRING("2014Q3",5,2)

  SUBSTRING("2014Q3",1,4)