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!!
13  1303 
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
"scorpion53 061" <Its the end of the world as we know it@here.com> wrote in
message news:u%******** ********@TK2MSF TNGP09.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
"scorpion53 061" <Its the end of the world as we know it@here.com> wrote in
message news:%2******** ********@TK2MSF TNGP10.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'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.
Bernie,
Thanks for trying. I am hoping someone else has ideas.
Hi Scorp,
I looked at the page you refer to. It's odd but when I try to create
characters with the codes represented there, I get different characters.
In any case, here's an example of parsing a string to remove certain
characters. This example removes Z (chr(90)) from anywhere in the string in
a textbox and places the result into another textbox. I used the first
string's leave event for this, but any event will do.
glf_parsedstrin g = rawstring.Text
Dim i As Integer
For i = 1 To glf_parsedstrin g.length
If InStr(Mid(glf_p arsedstring, 1, i), Chr(90)) Then
glf_parsedstrin g = Mid(glf_parseds tring, 1, i - 1) & Mid(glf_parseds tring, i
+ 1)
End If
i += 1
Next
parsedstring.Te xt = glf_parsedstrin g
HTH,
Bernie
"scorpion53 061" <Its the end of the world as we know it@here.com> wrote in
message news:Os******** ******@TK2MSFTN GP09.phx.gbl... see this link
http://personalwebs.oakland.edu/~gro...cii.codes.html
it seems to post ASCII codes for characters that look like mine.
How would I code tell it to remove all ASCII codes that I choose from this
page
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.
I have solved this issue. There is no need to respond to this thread.
Hi Scorp,
Just curious - how'd you solve it?
Bernie
"scorpion53 061" <Its the end of the world as we know it@here.com> wrote in
message news:%2******** *******@TK2MSFT NGP12.phx.gbl.. . 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.
I have solved this issue. There is no need to respond to this thread.
> Just curious - how'd you solve it?
You are not going to believe this........
TextBox4.Text = Replace(RichTex tBox1.Text, Chr(10), "")
I cannot believe I struggled so hard with this.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: bjwang |
last post by:
Hello wisers,
We are testing a system which is developed on top of Oracle 9iAS. The
client PCs are using Internet Explorer to access the system. We are
sure that the Oracle 9i database server is set to use Unicode. The
Oracle 9i database server and Oracle 9iAS server are now running on
English Windows 2000 server. With client PCs running on traditional
Chinese Windows 2000 or traditional Chinese Windows XP, via Internet
Explorer we put...
|
by: vbAlex |
last post by:
I've tried everything, looked through all the faqs and everything,
looking for a way to remove the 1px dotted border from around active
links... tried
a:active { border: 0px solid black; }
but, to no avail...
does anyone know how to get rid of the borders?
|
by: Robert J. O'Hara |
last post by:
For some time I've struggled with the problem of displaying simple
captioned figures on webpages in a way that is robust and scalable. I
tend to make "boring" (um, I mean "conservatively elegant") pages that
are text-heavy and that resemble academic publications. Despite the
origin of HTML in the world of scientific communication, the absence
of a FIGURE element to serve as a counterpart to the TABLE element is
surprising. This topic has...
|
by: rajarao |
last post by:
hi
I want to remove the content embedded in <script> and </script> tags
submitted via text box.
My java script should remove the content embedded between <script> and
</script> tag.
my current code is
function RemoveHTMLScript(strText)
{
var regEx = /<script\w*<\/script>/g
|
by: Raja Kannan |
last post by:
Is there a way to remove text portion from the HTML keeping the HTML
Tags using the browser, say javascript RegEx or something ?
I have seen lot of examples removing HTML tags to get the text but how
the reverse of it ?
any sample code or any suggestion would be appreciated.
| | |
by: Rubinho |
last post by:
I've a list with duplicate members and I need to make each entry
unique.
I've come up with two ways of doing it and I'd like some input on what
would be considered more pythonic (or at least best practice).
Method 1 (the traditional approach)
for x in mylist:
if mylist.count(x) > 1:
|
by: sameer mowade via .NET 247 |
last post by:
Hello All,
I have problem while dynamically removing row from the Datagrid which i have added dynamically as shown in the following code snippet. The problem is that while removing dynamically added row it also removes the row at the end along with the added row.
Plz tell me if, I am missing any thing.
Code
</asp:datagrid>
|
by: Chris Murphy via DotNetMonster.com |
last post by:
I'm curious to know if C++.NET produced a smaller & faster (performance
wise) executeable. I don't know too much about C++ and I'm only starting to
pick it up now, but given that I'm doing a lot of development with VB.NET &
C# I was going to migrate to C++.NET. As I understand it, traditional C++
compiles to a more effient binary which seem to out-perform most if not all
binaries produced by C# or VB.NET.
1. If .NET is an intermediate...
|
by: bruce |
last post by:
hi...
i'm running into a problem where i'm seeing non-ascii chars in the parsing
i'm doing. in looking through various docs, i can't find functions to
remove/restrict strings to valid ascii chars.
i'm assuming python has something like
valid_str = strip(invalid_str)
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
