1 Reply Latest reply: Jan 6, 2013 4:02 AM by Jim Smith RSS

    how to append the string value to existing blob content

    983124
      the blob column will have a string with comma separated values which needs to be changed to column wise data and update it back with the existing BLOB content.

      string like:-'V,CTMF,1.0,M,ICD-9 to 10 CM,CODE_COMMENTS_UPLOAD,0,A,bsns,2012-04-01,Author,pa admin,Comment,50 Record Map,F,Vascular,C,M'

      after i got splitting the values to column wise:
      V
      CTMF
      1.0
      M
      ICD-9 to 10 CM
      CODE_COMMENTS_UPLOAD
      0
      A
      bsns
      2012-04-01
      Author
      pa admin
      Comment
      50 Record Map
      F
      Vascular
      C
      M

      finally i need the blob append data output look like below,please do the needful................

      blob_value
      ----------------
      V,CTMF,1.0,M,ICD-9 to 10 CM,CODE_COMMENTS_UPLOAD,0,A,bsns,2012-04-01,Author,pa admin,Comment,50 Record Map,F,Vascular,C,M
      V
      CTMF
      1.0
      M
      ICD-9 to 10 CM
      CODE_COMMENTS_UPLOAD
      0
      A
      bsns
      2012-04-01
      Author
      pa admin
      Comment
      50 Record Map
      F
      Vascular
      C
      M