Thursday, November 22, 2012 2:28 PM
In a table I have been asked to present in a web form there is a text column that looks like below;
Date of MDT: 23/04/2012
Plan: MDT suggests that the AVM is embolisable fully. Mr ffff to speak to the referring surgeon.
Present: hfghfhghhg tyeryeryeryteryeyyryer
Date of MDT: 09/07/2012
Plan: 2cm right parietal nidus, sheffield opinion SRS was not thought to be appropriate due to the high flow and venous hypertension. Patient is on the list to be embolised.
Present: ththhth tytyyytytytyyt
Date of MDT: 29/10/12
Plan: Patient is to have another discussionin MDT after post op protocol 6 month CTA.
Present: jgghghghh ytytyytyyty
I basically need a new column every time ‘Date of MDT’ is entered, in excel I’d just use the text to columns feature but as I need this as an automated process could do with doing it in sql. Have you any idea? I am quite new to t-sql so havent really followed several walkthroughs on how to split these columns, the Date of MDT can appear anywhere in the column and a new column needs to start each time, some times it appears several times other none;
Thanks to anyone who can help;
Friday, November 23, 2012 5:33 AM
Microsoft® SQL Server™ Analysis Services supplies a number of functions which retrieve and manipulate statistical information from a data mining model.
Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, December 03, 2012 6:35 AM