Hello,
I have searched the forum and the internet but have not found a simple solution to splitting a column with data type TEXT where there is a carriage return.
I'd like to use charindex, substring, len but don't know how to combine them to look for data in between the carriage returns (CR).
For example;
123 Kings Road (CR) Holborn (CR) London (CR) W1 1AA
split into columns;
Address1
I'm looking for the most simple solution compliant with SQL Server 2008.
Any one have any idea's?
Thanks,
Javedi
I have searched the forum and the internet but have not found a simple solution to splitting a column with data type TEXT where there is a carriage return.
I'd like to use charindex, substring, len but don't know how to combine them to look for data in between the carriage returns (CR).
For example;
123 Kings Road (CR) Holborn (CR) London (CR) W1 1AA
split into columns;
Address1
Address2
Address3
Postcode
123 Kings Road Holborn
W1 1AA
LondonI'm looking for the most simple solution compliant with SQL Server 2008.
Any one have any idea's?
Thanks,
Javedi