Is it possible to extract the first paragraph in a mysql text field? my code line to display all text:
<%=replace(Recordset.Fields.Item("article").Value, vbcrlf, "<p>")%>
I want to separate the 1st paragraph (article lead) from the others (article), without having one table for 1st paragraph and a second one for the rest of the text.
I don't know Regular Expressions At All And I Could Really Use Your Help.
Is there a way to extract the paragraphs out of a string?
I've had some excellent help before on this forum and hoping for some more.
This is probably very basicbut I'm kind of muddling along a bit and it's a miracle I got so far.I have a memo text field in a table form and I'm wanting to enter text into it but all a small amount of formatting. Just basic paragraph breaks would be a start. This is kind of following on from a previous post of mine where I was trying to include line breaks. This was the solution.
Code:
<textarea name=whatever WRAP="HARD">
I am trying to send an email with the values from a form. I want to send the text field values as paragraphs on the email. It comes as one paragraph and there is no break.
View Replies View RelatedI am using TEXTAREA as input. While entering texts sometimes I am creating paragraph and save them .But when I retrieve from database it comes without paragraph.
Is there any way we can create paragraph in TEXTAREA?
I have a query about ASP with Javascript, I am trying to automate a form whereby when you type in some text in a form and hit the return key on your keyboard the asp/javascript places a <p> html marker in that paragraph space so when you hit the submit button the text is display correctly, i.e. the paragraphs are displayed and the text does not come out in one block. I have created a very simple form and button using ASP/VbScript and it works. For some reason I cannot work out how to do this with ASP/Javascript. This is so when in future all text is sent to a database we do not have to input the <p> markers manually. Obviously there is more to this, like connecting to a database to drag the text off first, but the code I have created is merely for testing purposes first.
here is my ASP/VBScript code below: ...
I am building a small CMS for my son's school. Ideally I want to build the system for them and hand it over so that all updates can be done through web-based forms.
So far so good. However I'm having a problem with fields designed to take multi-paragraph stories or articles. I'm using a text area field on the form which saves the data in a memo field in the database. Teachers would typically cut and paste stories from word documents into the text area field.
However when the data is loaded back into the website from the database all the carriage returns have been removed and the story consists of one long paragraph.
I have a form with a textarea input. The form then stores the text in a database. I want that text to be written to a web page (not a textarea).
Well if I don't put a <p> in between paragraphs, of course the paragraph breaks don't show up on the web page. How can I make it, so when I hit return in the text area, a paragraph break shows up in the asp page?
I ve a text paragraph something like
sample sample sample sample Join Bytes! <ee@ss.comsample sample
sample sample sample sample sample sample sample sample
Join Bytes! sample sample sample <ww@example.comsample sample
sample sample sampl Join Bytes!
i want to extract email ids from the above text paragraph.. using
Active server pages or php can u give me some clue to find a
solution.
i ve tried some regular expression technique to sort out this problem
but.i cant get the proper output
I have an asp page that reads the contents of a database and creates an xml news feed. I have code that strips out the <BR> and <P></P> tags, but it looks one of the databases I'm trying to read from uses only <P> without the closing tag.
So the make a long story short, I can't figure out what to add to my code to strip out these tags (or if that isn't the problem at all!) Code:
I have a scrolling text box where people input a list of information, using the <ENTER> key between lines.
The submit button transfers this information into the Access DB into a memo field.
When I try and pull up the information using Response.Write, all of the line breaks are gone, its just moshed together.
What better way is there to do this so my line breaks are intact?
I have a string of HTML (used for a specific purpose) that I'd like to
use somewhere else but as plain text. Rather than introduce a
specifically created plain text version I'd like to strip the tags code
from the HTML version. This in itself is easy, using a function such
as:
Function HTMLDecode(Expression)
Dim sTemp
sTemp = Expression
sTemp = Replace(sTemp, ">", ">", , , 1)
sTemp = Replace(sTemp, "<", "<", , , 1)
'Repeat for each defined entity
HTMLDecode = sTemp
End Function
However, the difficulty comes when trying keep each paragraph seperate.
For example, the string "this is<p>my name" shows on screen as:
this is
my name
if I use the above function, it strips out the <p> tag and shows the
result on one line:
this is my name
I thought I could use something like:
str = replace(str, "<p>", chr(10))
but that doesn't seem to work. Can anyone help me replace <br> and <p>
tags with something that's recognised as "plain" text but will keep the
paragraphs and new lines formatted correctly??
I have an XML file that contains nodes and I'm having no problem extracting the information using ASP. However I can't seem to get the ID number from the deliverrequest node from the example below.
<!DOCTYPE xiamSMS SYSTEM "Message.dtd">
<xiam>
<deliverRequest id="10234690"> ''' Need to retrieve this number using
ASP
<to>test</to>
<from>number</from>
<content type="text">Test 2</content>
</deliverRequest>
</xiam>
Is there an ASP way of extracting the height and width of a swf file so that
I can specify these dims when adding the whole OBJECT code to the web page?
What string function(s) would I use to extract just the filename from an URL?
For example, if I have http://www.yourdomain.com/some_directory/some_file.asp, how do I extract just the "some_file.asp"?
I need a help in extracting files, thru ASP. Is that possible to extract files from .tar, .gzip and zip files thru ASP.
View Replies View Relatedi want to extract the number 38 from the URL below, using ASP what is the solution?
then store it as a variable.
http://pcol-webtest/default.asp?nc=4098&id=38
is asp code able to do the extraction of text from PDF File without using a third party software?
View Replies View Relatedwe have a site, that has a link to a online PC cart that we are registered with. Trouble is, when the user goes to the other site, we obviously no longer have our interface wrapped around the page.
We can do this with an iframe, but it wont vertically stretch the content (a scroll bar appears). Is there any way in ASP, to call a url, and say, insert that url into a <td></td> on our page?
Not a problem with my code, but something I would like to add, (ASP
VBScript) at the moment I have a form where a user uploads their details
including a document (Doc, PDF, TXT, Docx) The document is uploaded to a
folder on the server with the address being stored in the database and I'm
tracking the user id through sessions.
What I would like to do after the upload is redirect to a blank page, where
some script extracts the data from the document and inserts it into another
field on the database associated with the user id, I think this may be called
parsing, but I'm at a complete loss, I don't suppose you guys have any ideas
on this do you.
we have a database with a lot of products in it. and for some reason one fo the feilds is set up like "<img src="images/something/image.jpg" />". they should be set up without the html but because of the way they are set up theres no way i can use them outside of the root directory.
I need a way to just pull the first 10 characters off the string. which would be the <img src=" part, and then pull off the last 4 characters " />. so that i am just left with images/something/image.jpg.
I can sort of get the first part to work by using Mid(string,10)
but how can i remove the last 4 characters?
in php the function would do the ending characters if you made it a negative number. but Mid(Mid(string,10),-4) doesnt seem to work.
Is there a way of processing an ASP page and placing the resulting HTML
source code into a TEXTAREA on another page?
I have a page that will be generated dynamically from database content.
However, I want a form on another page to have access to the compiled source
code for use in an electronic newsletter.
Manually I would load the dynamic page, view the source and copy it out. I
would then paste it into my form field on the relevant page.
Is there a way of extracting only part of an entry retrieved from a SQL database. For instance, if I have an article of 4000 characters can I extract only the first line of the article and them put a link to the full article after the extracted text.
It is something I have been trying to master and will help me display my retrieved recordset data better.
in my project, i want a label which shows the current value of all shares in the market whenever the user login to the application.how can i do that.how could i dynamically extract data from the shares website.
View Replies View RelatedBasically I want to be able to take the tempreature, pressure and wind and be able to use them as variables in calculating performance automatically for an aircraft. I've tried using the pull string method but can't work out how to seperate the variables.
View Replies View RelatedI have a website where people can add job vacancies to our database. In the admin section I can delete these vacancies but have trouble with selecting certain dates from the database.
For example if I wanted to delete all the jobs from the database for the 18/12/2003 I would select the date then all the jobs will appear on the screen and I can delete them. But if I select a date such as 06/12/2003 or 11/12/2003 it doesnt display anything from the database when I know there are a couple of hundred in there for those dates.
I'd like to do the above, ideally in javascript but i'm aware of the security restrictions with accessing the DOM of a file not hosted on the same server - however i'm not looking to manipluate anything on the remote site, or handle any events (such as keylogging!). All i want is to have a piece of text on the remote site dupicated on my own site.
I'm happy to receive the html as a whole and split it up to get what i want, but i'm beginning to think the way forward is doing it server-side with asp.
Anyone know the best way to do this?
OR am i just being silly and there is a way to copy the contents of a remote page into my own page in javascript, split it up and only display what i need.
(btw im quite happy with the splitting up bit, no help needed there - i just need the blasted text in the first place!)
Is it possible to extract data from SQL server to MS Excel ? Say if I have 2 tables (Membership and Profile) and extract some certain datas from those 2 tables; MemberID, Member Name, Birthday, Interest; could it be possible to extract them automatically everyday at 1 AM without me doing it manually?
Perhaps its possible to do it with Stored Procedure? or some other means?
I am trying to add a feature to our inventory that will pass the current URL to a second site so that I can return to the original site later through a redirect. Basically, it is intended to work like this - you do a search, and are taken to a page where you can view the records.
You click on a record to view it and/or update it, and then you are returned to the original search results. I am having some trouble, and am hoping that someone can help me out.
I am placing the values that I want to keep (original URL, search terms, sort order, page number) into a string, and then using Server.URLEncode to encode it: Code:
I have a bunch of html stored in a session variable. It's just a long string of html. I want to parse it to extract certain things out of it. I'm assuming I would use the Left, Mid and Right functions. But don't know exactly how to do it. Plus I need to find the information in the session variable too.
View Replies View RelatedI have an access database and am currenlty using classic asp for most of my coding and am trying to extract sentences from the memo field that contain specific strings, in this case "<b>"
The memo fields contain a lot of data so filtering becomes an issue, so i just want to be able to only display the sentences within the memo field i.e. between "." and "." OR beginning of record and "." OR "." and end of record that contain the string "<b>"
I have the below mentioned code that I am using to send a simple html email via ASP. Please do let me know how I could modify the code so that the carriage returns are captured and the paragraphs that are entered within the text area are preserved. I do not need any fancy hmtl formatting - just the paragraphs. Code:
View Replies View RelatedSince most todays' applications are Online (ASP using COM apps/server back-end), sometimes client-browsers need to download data into their PC.
Scenario: A client-browser (IE, ONLINE.ASP) is doing transaction online.... say Invoicing via an ASP page, then it disconnected (DSL connection failure). At this stage, the user will have to do "manual" writing of item sold and when the connection returns... the user will use the browser again.
Question: Can I download data from the Server to the client-browser using a simple click of "Submit" button? Say I would like to download only itemBarcode, itemDesc and itemPrice from the client.... so that anytime the DSL connection fails, the user will execute instead OFFINE.ASP that uses client side programs.
Option: Is there any other option that I could do to have an "offline" transaction processing?