Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clifr
Starting Member
3 Posts |
 Posted - 2011-06-25 : 09:02:45
|
Hi, can you helpI need to export data from mssql to excel, it includes a memo field which has Font Control Characters included in it.Is there any way I can just get the value of the memo field without the rest of the Chars ? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-25 : 09:23:03
|
| Can you post an example containing control characters? Usually you can remove anything with the T-SQL REPLACE() function. |
 |
|
|
clifr
Starting Member
3 Posts |
Posted - 2011-06-26 : 07:05:53
|
| (it could be any font control characters) An Example would be like {\rtf1\ansi\deff0{\fonttbl{\f0\fnil MS Sans Serif;}{\f1\fnil\fcharset0 MS Sans Serif;}} \viewkind4\uc1\pard\lang2057\b\f0\fs24 Lift yearly sample and send to Brussels\f1 via quality {\rtf1\ansi\deff0{\fonttbl{\f0\fnil MS Sans Serif;}} \viewkind4\uc1\pard\lang2057\b\f0\fs24 Annual insurance inspection of generator.\b0\fs16\par } |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-26 : 07:14:30
|
| See if this helps:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90034 |
|
|
|
clifr
Starting Member
3 Posts |
Posted - 2011-06-26 : 07:18:18
|
| Thanks for that mate....... |
|
|
|
|
|
|
Remove Font Control Chars in Memo fields