Thanks for taking the time to read this note.
I have a Access inventory collection tool that I have automated to
build and Export to a CSV file. In the database I have several fields
that are large text fields for comments. When I'm collecting data I
have set the <Enter> button to move to next line instead of the
default.
We are trying to import this CSV data file in to a Remedy SQL server
using the Remedy Import tool. This import fails if the user in the
Collection tool uses the <enter> button to format the data. It looks
like it is adding a <cr><lf> to the row of data and then moves to the
next line of information.
Is there an easy solution to the issue? .. other than not letting the
user format the data?
N. Graves 4 5262
If your Remedy Import chokes up on Cr-Lf, then you will need to prevent it
being there or remove the ones that are there. Because, if you configure for
Enter to go to the next line within the Text Box, you will be entering the
"NewLine" which is a combination of "Carriage Return" and "Line Feed".
The Replace function may be a handy one for this circumstance; if you are
using an earlier version of Access than 2000, you can likely find a
user-coded Replace function with a search of the archives at http://groups.google.com.
Larry Linson
Microsoft Access MVP
"N. Graves" <ng*****@REMOVE yahoo.com> wrote in message
news:3l******** *************** *********@4ax.c om... Thanks for taking the time to read this note.
I have a Access inventory collection tool that I have automated to build and Export to a CSV file. In the database I have several fields that are large text fields for comments. When I'm collecting data I have set the <Enter> button to move to next line instead of the default.
We are trying to import this CSV data file in to a Remedy SQL server using the Remedy Import tool. This import fails if the user in the Collection tool uses the <enter> button to format the data. It looks like it is adding a <cr><lf> to the row of data and then moves to the next line of information.
Is there an easy solution to the issue? .. other than not letting the user format the data?
N. Graves
On Aug 04 2004, 07:58 pm, N. Graves <ng*****@REMOVE yahoo.com> wrote in
news:3l******** *************** *********@4ax.c om: I have a Access inventory collection tool that I have automated to build and Export to a CSV file. In the database I have several fields that are large text fields for comments. When I'm collecting data I have set the <Enter> button to move to next line instead of the default.
We are trying to import this CSV data file in to a Remedy SQL server using the Remedy Import tool. This import fails if the user in the Collection tool uses the <enter> button to format the data. It looks like it is adding a <cr><lf> to the row of data and then moves to the next line of information.
Is there an easy solution to the issue? .. other than not letting the user format the data?
TextExport class from http://www.users.cloud9.net/~dfurman/code.htm will
export your text to a delimited file, optionally replacing CRLFs with some
other string (let's say a space, or possibly standalone LF or CR). This
will avoid the import problems, but of course may reformat the text in an
undesired way.
You may replace CRLFs with some token string during export, then once the
data is imported, replace the token string with CRLFs.
--
remove a 9 to reply by email
In my situation this may be overkill... but thank you very much for
your input and I will keep this note for future reference!!!
Thanks
N. Graves
On Thu, 05 Aug 2004 11:48:46 -0000, Dimitri Furman
<df*****@cloud9 9.net> wrote: On Aug 04 2004, 07:58 pm, N. Graves <ng*****@REMOVE yahoo.com> wrote in news:3l******* *************** **********@4ax. com:
I have a Access inventory collection tool that I have automated to build and Export to a CSV file. In the database I have several fields that are large text fields for comments. When I'm collecting data I have set the <Enter> button to move to next line instead of the default.
We are trying to import this CSV data file in to a Remedy SQL server using the Remedy Import tool. This import fails if the user in the Collection tool uses the <enter> button to format the data. It looks like it is adding a <cr><lf> to the row of data and then moves to the next line of information.
Is there an easy solution to the issue? .. other than not letting the user format the data?
TextExport class from http://www.users.cloud9.net/~dfurman/code.htm will export your text to a delimited file, optionally replacing CRLFs with some other string (let's say a space, or possibly standalone LF or CR). This will avoid the import problems, but of course may reformat the text in an undesired way.
You may replace CRLFs with some token string during export, then once the data is imported, replace the token string with CRLFs.
With the help of the iif Perfect was reached... thanks for your input.
N. Graves
On Thu, 05 Aug 2004 02:32:33 GMT, "Larry Linson"
<bo*****@localh ost.not> wrote: If your Remedy Import chokes up on Cr-Lf, then you will need to prevent it being there or remove the ones that are there. Because, if you configure for Enter to go to the next line within the Text Box, you will be entering the "NewLine" which is a combination of "Carriage Return" and "Line Feed".
The Replace function may be a handy one for this circumstance; if you are using an earlier version of Access than 2000, you can likely find a user-coded Replace function with a search of the archives at http://groups.google.com.
Larry Linson Microsoft Access MVP
"N. Graves" <ng*****@REMOVE yahoo.com> wrote in message news:3l******* *************** **********@4ax. com... Thanks for taking the time to read this note.
I have a Access inventory collection tool that I have automated to build and Export to a CSV file. In the database I have several fields that are large text fields for comments. When I'm collecting data I have set the <Enter> button to move to next line instead of the default.
We are trying to import this CSV data file in to a Remedy SQL server using the Remedy Import tool. This import fails if the user in the Collection tool uses the <enter> button to format the data. It looks like it is adding a <cr><lf> to the row of data and then moves to the next line of information.
Is there an easy solution to the issue? .. other than not letting the user format the data?
N. Graves This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JShurmatz |
last post by:
If anyone can shed some light on this problem I would greatly
appreciate it.
I am unsuccessfully trying to use a database connnection retrieved
from a pool configured using Java System Web Server 6.1 with the SQL
Server 2000 JDBC Driver.
The background:
1. I have downloaded the SQL Server 2000 JDBC Driver and installed it
on the web server.
|
by: Fritz Bosch |
last post by:
Hi experts
Is is possible to import/manipulate a module such that
I can supply its __dict__?
I want to supply my own dict subclass object to be filled
by the import, e.g. a class like:
>>> class MyModuleDict(dict):
.... def __setitem__(self,name,val):
|
by: WangKhar |
last post by:
just curious as to quite what This means:
(taken from the Server License Eula at
http://www.microsoft.com/sql/howtobuy/servercal.asp)
14 LIMITED WARRANTY.
Microsoft warrants that the Product will perform substantially in
accordance with the accompanying materials for a period of ninety days
from the date of receipt.
If an implied warranty or condition is created by your
state/jurisdiction and federal or state/provincial law prohibits
|
by: MD |
last post by:
I am trying to create a dynamic SQL statement to create a view.
I have a stored procedure, which based on the parameters passed calls
different stored procedures. Each of this sub stored procedure creates
a string of custom SQL statement and returns this string back to the
main stored procedure.
This SQL statements work fine on there own. The SQL returned from the
sub stored procedure are returned fine. The datatype of the variable
that...
|
by: Tim Jones |
last post by:
Hey all,
I am trying to try get a crytal report running properly. A "Hello World"
report that does not add criteria to the record selection formula of the
report (either in the development tool, or in the code) works fine.
However, when I try to add any parameter through the record selection
formula and/or the report parameters method, the report crashes.
I have tried each of the methods:
| |
by: Jim |
last post by:
Group,
I have a Web application sitting on a staging server that is using SQL
Server 2000 as its data store, and I can run the application flawlessly.
Now, when I copy the project to my localhost and run the application, using
the same SQL Server, I keep on receiving a SQLException Timeout expired. Any
ideas how I can remedy this?
|
by: Takeadoe |
last post by:
Dear NG - I've got a bunch of SQL statements (Insert Into "Access Table
Name") generated from another software program. They look like this:
Pasting these lines into the SQL view as they are generates a couple of
different errors (missing semicolon being one of them). They work fine
if I paste 1 line at a time. Can someone tell me what I need to do to
remedy the situation? I can't hardly paste 1 at a time! Your help is
very much...
|
by: Pool |
last post by:
Team: One of project uses IBM REMEDY database. It has a field "Closure time". we were told that the time in this field is in "EPOCH" format. I have the following issues with this field.
1) But if we execute a SQL query ((ASP. NET) and display the time in console, I am getting in mm/dd/yyyy hh:mm:ss (PM/AM) format.? Why
2) I cannot do a relation operaqtion perator in the SQl qeury Like "Select * from Table if Closure time '<' or' >' .....
|
by: Pool |
last post by:
My project uses REMEDY Database (idbm db2). We were able to connect to the database using the driver provided to us. But if we try to execute a SQL with relational operators the .NET code fails, i was told that this culd be an issue with the driverr provided to us. Any help
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |