Parse text

[simma]

Hello,
we have a field in table which needs to be parsed.
These are basically comments which need to be parsed to separate table

ln comments
2003 12/03/04 user called
01/04/04 fax was recieved
01/05/04 we responded

2004 01/01/04 case was registered
03/04/04 bk filed

the data needs to be parsed like this

ln date comments
2003 12/03/04 user called
2003 01/01/04 fax was recieved
2003 01/05/04 we responded
2004 01/01/04 case was registered
2004 03/04/04 bk filed

Please advice
Thanks

 

[dbomrrsm]

after amending the table to include a field called comm_date do:

Update yourtable
set comm_date = left(comments,8)

Update yourtable
set comments = substring(comments,patindex('% %',comments)+1,4000)

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[simma]

Thanks dbomrrsm , I will give it a shot...