This discussion is archived
1 Reply Latest reply: Jan 6, 2013 2:02 AM by Jim Smith RSS

how to append the string value to existing blob content

983124 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points