Ignis2000
asked on
SQL 2005 String Functions
Hi there,
I need to detect the presence of linefeed/new line characters in a string I'm parsing in SQL 2005.
The string is of the format ~1000~3483923~893493~...~A
The elements are split by the delimiter and inserted in a table. Sometimes, the string contains newline characters in the middle of numbers which SQL parses and returns as 599.3 233 with a space in between
trying REPLACE(Element,' ','') does not work because SQL still recognises it as a newline and not a space. Does anyone know what is to be specified in the REPLACE function?
Thanks,
I need to detect the presence of linefeed/new line characters in a string I'm parsing in SQL 2005.
The string is of the format ~1000~3483923~893493~...~A
The elements are split by the delimiter and inserted in a table. Sometimes, the string contains newline characters in the middle of numbers which SQL parses and returns as 599.3 233 with a space in between
trying REPLACE(Element,' ','') does not work because SQL still recognises it as a newline and not a space. Does anyone know what is to be specified in the REPLACE function?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER