删除非传统文本 [英] removing non traditional text

问题描述

这真的很奇怪。


我已经向客户提供了一种方法，可以将文本存储在

数据库中并插入一个单词文件。


最初他们将文本输入文本框。然而，当他们复制

并粘贴文本时，显然格式符号也出现了，但是

它们不可见。因此，当他们在插入文件后在文档中搜索此文本

时，查找按钮功能没有用。


所以我提出了把它放在富文本框中的想法。对于

，这最能保留可见形式的格式。他们进入了

数据库。然后他们会在常规文本框中打开它并删除所有我可以看到的某种类型的样式标记（方形的形状）。


我想知道是否有办法自动删除这个非正统的

文本。


谢谢大家的帮助!!

解决方案

你好Scorp，


它始终是那个符号并且它总是作为第一个角色出现吗？

如果其中一个是真的，你可以在sql中对行的更新中找到它并且

将它除去，寻找特定的ascii等价物（听起来像ascii

254？）。


HTH，


Bernie Yaeger


" scorpion53061" ; <它的世界尽头我们知道 [e-mail] >写在

消息新闻：u％**************** @ TK2MSFTNGP09.phx.gbl ...

这是真的很奇怪。

我已经向客户提供了一种方法，他们可以将文本存储在数据库中并插入到word文档中。

最初他们输入了将文本放入文本框中。然而，当他们复制
和粘贴文本时，显然格式符号也出现了
但是它们不可见。因此，当他们在插入文件后搜索文本
时，查找功能没有用。

所以我提出了把它放在富文本框中的想法。这对于
大多数保留了可见形式的格式。他们进入了
数据库。然后他们会在普通的文本框中打开它并删除所有的I
可以调用看起来像某种形状的样式标记（形状正方形）。

我想知道是否有办法自动删除这个
非正统文本。

谢谢大家的帮助!!

< BLOCKQUOTE>>它总是那个符号并且它总是作为第一个角色出现吗？


你好Berine


这是我附上的一个synbol文本文件。出于某种原因，我无法将b $ b粘贴在这里。


无论何时在文本中发生格式更改或中断，都会发生这种情况。

文本出现。


当我点击粘贴时尝试在visual studio中执行Trim语句时，

看不见并打破下一个行。


是否能够处理这个角色？

Hi Scorp，


这很奇怪。我记得 - 很久以前 - 将数据从

Borland Paradox系统（我告诉过你很久以前！）转换为foxpro系统和

我遇到了相同的性格。它就像一个行尾

字符，因为你不能支持它，除了它本身之一，我

能够撕掉它它出来了，但我不记得我是怎么做到的。我可能已经解析了

这行并且不允许任何不是字母数字或chr（10）和

chr（13）和破折号等等，但我老实说不记得。


抱歉，我无法提供更多帮助。


伯尼


scorpion53061 <它的世界尽头我们知道 [e-mail] >写在

消息新闻：％2 **************** @ TK2MSFTNGP10.phx.gbl ...

它总是那个符号并且它总是显示为第一个

字符吗？
你好Berine

这是我附上的这个synbol在文本文件中。出于某种原因，我无法将其粘贴到此处。

只要文本中出现格式更改或文本中出现
，就会出现这种情况。
<当我点击粘贴时我试图在visual studio中做一个Trim语句时，
是不可见的并且会中断到下一行。

是否能够处理这个角色？

This is really weird.

I have provided to a client a means for which they can store text in a
database and insert into a word document.

Originally they entered the text into a textbox. However when they copied
and pasted text in there apparently formatting symbols came over as well but
they were not visible. So when they searched for this text in the document
after inserting it the "find" function didnt work.

So I came up with the idea of putting it in a rich textbox. This for the
most preserved the formatting in a visible form. They entered it into the
database. Then they would open it in a regular textbox and remove all I can
call appear to be style markings of some kind (a square in shape).

I am wondering if there is a way to automate the removal of this unorthodox
text.

Thank you all for your help!!

解决方案

Hi Scorp,

Is it always that symbol and does it always appear as the first character?
If either is true, you could look for it on the update to the row in sql and
weed it out, looking for that particular ascii equivalent (sounds like ascii
254 ?).

HTH,

Bernie Yaeger

"scorpion53061" <Its the end of the world as we know [e-mail]> wrote in
message news:u%****************@TK2MSFTNGP09.phx.gbl...

This is really weird.

I have provided to a client a means for which they can store text in a
database and insert into a word document.

Originally they entered the text into a textbox. However when they copied
and pasted text in there apparently formatting symbols came over as well but they were not visible. So when they searched for this text in the document
after inserting it the "find" function didnt work.

So I came up with the idea of putting it in a rich textbox. This for the
most preserved the formatting in a visible form. They entered it into the
database. Then they would open it in a regular textbox and remove all I can call appear to be style markings of some kind (a square in shape).

I am wondering if there is a way to automate the removal of this unorthodox text.

Thank you all for your help!!

> Is it always that symbol and does it always appear as the first character?

Hi Berine

It is this synbol I have attached in a text file. For some reason I cannot
paste it here.

It seems to occur whenever a format change occurs in the text or a break in
the text occurs.

When I try to do a Trim statement in visual studio when I click paste it is
invisible and breaks to the next line.

Is anything able to handle this character?

Hi Scorp,

It''s weird all right. I remember - a long time ago - converting data from a
Borland Paradox system (I told you it was long ago!) to a foxpro system and
I ran into the same character. It''s something like an end of line
character, because you can''t get behind it, except with one of itself, and I
was able to rip it out, but I don''t recall how I did it. I may have parsed
the line and disallowed anything that wasn''t alphanumeric or chr(10) and
chr(13) and dashes, etc, but I honestly do not recall.

Sorry I couldn''t be of more help.

Bernie

"scorpion53061" <Its the end of the world as we know [e-mail]> wrote in
message news:%2****************@TK2MSFTNGP10.phx.gbl...

Is it always that symbol and does it always appear as the first

character?
Hi Berine

It is this synbol I have attached in a text file. For some reason I cannot
paste it here.

It seems to occur whenever a format change occurs in the text or a break in the text occurs.

When I try to do a Trim statement in visual studio when I click paste it is invisible and breaks to the next line.

Is anything able to handle this character?

这篇关于删除非传统文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！