I am not sure if this is the correct forum for this question....so moderator please feel free to move this to the appropriate forum..thank you
Now coming to my issue...I have an application from which I pull data and then upload the data into the database.. This is very huge data and I do it almost 8 to 10times a day..the data I download from the application when uploaded into the database gives an extra character which is a square box at the end of data in few columns...curre ntly what I do is, download the data as a .txt file and open in it notepad and then save it and then upload it into database...by opening and saving in it notepad..it somehow gets rid of the that extra square box.....
please find the attached file..you can open in it in word pad to view the square box..
can somebody please tell me how can I get rid of the square box or is there a way to automate the process of opening and saving the file in notepad...thank you
5 6148
The square box usually has to do with line returns in windows /r/n. What application are you using to open the file initially? Is this your code? Do you have access to the source files and can you modify them? When you parse your text file search for the /r from the string and remove it or try the same with /n. I have hit this all the time while working with files, just mess around with your carriage returns and that box will be gone.
thank you for the reply.....I can not modify the source code as the application is a third party application. i will try to see if I can do any thing else to remove the /r or /n from the data..thank you
Perhaps you could expand more the entire process and applications involved in this process and perhaps we can help you find an acceptable solution. Perhaps contacting the creators of the program and see if 1 there is an update for the software or two see if there is something you can do to fix the problem. From a programmers standpoint it is easy to fix this problem.
Plater 7,872
Recognized Expert Expert
I see nothing wrong with the line terminators in that file, they are correct for windows (\r\n and not just \n) and they are in the correct order.
There *IS* however a null byte in between the two tab characters.
0x09 0x00 0x09 (tab, null byte, tab) which is causing the box.
Probably used as a split point in the application that created it, or something strange in the way you retrieve the data
thank you both for the responses...I will try to see how my data is being extracted.. i mean look into the code..if possible...or ask the provider to help me ..thanks for shedding light on what to look for...
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: J. C. O'Connell |
last post by:
hi,
I HAVE A TEXT BOX THAT I WANT THE USER TO ENTER A NUMBER IN.
HOW DO I PREVENT RUN TIME ERROR IF THEY ENTER A STRING INSTEAD?
I GUESS I NEED SOME TYPE OF DATA TYPE SENSING COMMAND BUT I
DONT KNOW WHAT IT IS.
jco
|
by: Norman Uhlenkott |
last post by:
I would like to be able to put in special character inside
an xml data string (#, <, >, &).
when it trys to parses out the XML String it errors out
strXML = "<?xml version='1.0'?>" & vbCRLF
strXML = strXML + "<WO_Step>" & vbCRLF
strXML = strXML + "<Test>Test Special Characters #, %, &,
<, > </Test>
strXML = strXML + "</WO_Step>"
|
by: Robert Nurse |
last post by:
Hi All,
I've got a form which I'm trying to submit automatically when the user
has entered 2 or more characters in a text imput box. Here's my set
up:
<SCRIPT language="JavaScript1.2">
function submitLetters(form, control)
{
var returnValue = true;
|
by: voidfill3d |
last post by:
I have a problem with ASP.NET and entering data into a MS SQL database.
I have the following
code and what happens is the data gets into the database, but with one
extra space at the end of
the entry. Is this preventable with something other than a trim in my
stored procedure? I know this is not necessarily in ASP.NET because I
returned the value with quotes around it and it shows up right, but
when I look in the database, it is...
|
by: Kay |
last post by:
Hi All,
I'm trying to write a small sub/function to replace some (invalid) character
in a combo box, or may be even text box. For example, I have several combo
boxes that allows user to select a time value, i.e. 21:30, however I also
want to allow them to enter a time, as a result I want to replace comma,
fullstop etc with a colon ":". I've done this in VB6 keypress event,
however with the "sender", "e" in .net I'm a bit lost... I...
| |
by: libadmin |
last post by:
I have a large database (for me) containing about 23,000 records and I
need to add a single digit (the number 8) to all data currently in a
specific field.. This field contains numbers already that are 8
characters and I need to change them to nine by adding a #8 to the
beginning of each entry... Any easy way of doing that??
\Bob
|
by: subrahmanyaam |
last post by:
Guys,
I have a textbox1.text on my form. If any person enters the name as D'Souza, i want to eliminate that " ' " from the text box before i could save it. How do i do this...
please comment
I am able to detect that extra character but dont know how to replace the text box without string (OR) removing the string from that name. The code to trace the string is as below:
dim str as string
str=textbox1.text
if str.contains( " ' " ) then...
|
by: buckkitty |
last post by:
Hello,
Does anyone understand why Data2 would not equal Data? I print, and can see, that they LOOK the same, i.e. have the same number of rows and columns with the same values in each element. But when I pass the matrices to a calc function, they give different results. I am guessing that there is a missing (or extra) character, space, line somewhere that I can't "see".
The only difference is the way that I fill Data1 and Data2....
|
by: agarwalsunitadhn |
last post by:
I am developing a web application using PHP and Mysql. whenever i insert the data in database every string containg an extra character  at start. like if i have to insert 'ABC' then it will insert ' ABC'.
I donot understand why this problem occurs. IF you have any solution then please suggest.
Thanks
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
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...
| |