Extracting from one cell in excel. and from

  • I have a excel file. in one cell, column A row2, there is a text.

    "This is effective as of February 5, 2014"

    I need to get the date from this text and load into a table in sql server using ssis. how do I do this?

  • I don't even know where to start. Do you know SSIS at all?

  • I solved this task. I used script component to write VB code. with VB I could extract the text from the cell in excel and put it in array.

    I put the text in array and put last three words together which have date information.

  • Will this work if the next time you get "This is effective as of May 5, 2014" ? - just giving a heads up in case you are using a string function like Right (..,..)

    ----------------------------------------------------

  • I did not use Right (..,..).

    I put each words into an array. and got the size of the array. if the size of the array is X, I got the last three words by words[x-2],words[x-1],words[x]

    each word occupies a space in array. not each character.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply