Replace
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=13441
Printed Date: 30 March 2026 at 10:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Replace
Posted By: zMaestro
Subject: Replace
Date Posted: 20 January 2005 at 10:41am
I have a file wrote in this format:
and so on, (>10000 records)..
now, i want to enter these 10000 record in database, each record in a row. how can this be done?
|
Replies:
Posted By: zMaestro
Date Posted: 20 January 2005 at 10:45am
|
I tried something like this with fron page:
i replaced the ] by <tr><td>
i replaced the [ by </td></tr>
and wrote at the begining <table> and at the end </table> and just deleted the [ and the last ]
it worked since i can see it as a table each record in a row in html, but still i can het red of the numbers before and after :
can this be done through the replace function?
i.e. take the whole page and do a function over it, so to detects the : and delete the numbers and brackets before and after it?
or there is a simpilar way?
|
Posted By: dj air
Date Posted: 20 January 2005 at 11:29am
|
im not sure what you mean by "but still i can het red of the numbers before and after :" |
Posted By: Gullanian
Date Posted: 20 January 2005 at 12:19pm
|
Yes, vbCrlf can be used. vbCrlf is a line break, so between two
records there seem to be two line breaks. So you would do: Split(file,vbCrlf & vbCrlf) |