This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C019D6.3AD9C07E
Content-Type: text/plain;
charset="iso-8859-1"
use single quotes.
#Replace('#f1_element#','"','','ALL')#>
HTH
Robert
-----Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 2:05 PM
To: [EMAIL PROTECTED]
Subject: Importing a text file
I have a file that I need to import that looks something like this.
"A3","BOOSTER_TANK_ASSY","1B89037","Serial
Number",#2000-09-09#,100,75,"Visual Good","No"
Now, I know how to import the, what I am having problems is that the data is
surrounded by "'s. This is my Replace statement
#Replace("#f1_element#"," "," ","ALL")#>
The question is, how do I stip out the "'s when "'s are part of the
statement?
Thank you for your help
Jim Ray
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_001_01C019D6.3AD9C07E
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Importing a text file</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>use single quotes.</FONT>
</P>
<P><FONT =
SIZE=3D2>#Replace('#f1_element#','"','','ALL')#></FONT>
</P>
<P><FONT SIZE=3D2>HTH</FONT>
</P>
<P><FONT SIZE=3D2>Robert</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Ray, James A [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, September 08, 2000 2:05 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: Importing a text file</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I have a file that I need to import that looks =
something like this.</FONT>
</P>
<P> <FONT =
SIZE=3D2>"A3","BOOSTER_TANK_ASSY","1B89037"=
;,"Serial</FONT>
<BR><FONT SIZE=3D2>Number",#2000-09-09#,100,75,"Visual =
Good","No" </FONT>
</P>
<P><FONT SIZE=3D2>Now, I know how to import the, what I am having =
problems is that the data is</FONT>
<BR><FONT SIZE=3D2>surrounded by "'s. This is my Replace =
statement</FONT>
</P>
<P><FONT SIZE=3D2>#Replace("#f1_element#"," =
"," ","ALL")#></FONT>
</P>
<P><FONT SIZE=3D2>The question is, how do I stip out the "'s when =
"'s are part of the</FONT>
<BR><FONT SIZE=3D2>statement?</FONT>
</P>
<P><FONT SIZE=3D2>Thank you for your help</FONT>
</P>
<P><FONT SIZE=3D2>Jim Ray</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C019D6.3AD9C07E--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
