文本文件中的经典 Asp 提取日期

发布于 2024-12-08 18:52:53 字数 4956 浏览 3 评论 0原文

我想知道谁可以从文件中检索日期。

这就是我打开文件的方式：

    Set fs=Server.CreateObject("Scripting.FileSystemObject")

    Set f=fs.OpenTextFile(Server.MapPath("checkno_2211.html"), 1)
'Need something here to find the first date MM/DD/YYYY in the file
    f.Close

    Set f=Nothing
    Set fs=Nothing

上面的代码将打开 .html 文件，现在我想找到该文件中的第一个日期，但我不知道该怎么做。 :-(

.html 文件中将包含多个日期，但我只需要获取第一个日期。日期的html和格式是这样的：

<TD class="auto-style32" style="height: 31px">
Date:
 10/7/2011</TD>

.html文件的源代码一如既往

        <HTML>
        <HEAD>
        <script SRC="include/general.js" language="javascript" type="text/javascript"></script>
        <style type="text/css">
        textarea { 
font-size: 14px;
font-weight: bold;
font-family: Arial;
}

.style1 {
    text-align: center;
}
.style2 {
    border-style: solid;
    border-width: 1px;
}
.style3 {
    color: #FFFFFF;
    background-color: #000000;
}
.style4 {
    background-color: #000000;
}
.style5 {
    color: #FFFFFF;
}
.style7 {
    vertical-align: text-bottom;
}
.style8 {
    font-family: Arial, Helvetica, sans-serif;
}
.style9 {
    background-color: #C0C0C0;
}
.style10 {
    vertical-align: middle;
}

        .auto-style30 {
            text-align: center;
            margin-left: 0px;
        }

        .auto-style32 {
            text-align: left;
            border-bottom-style: solid;
            border-bottom-width: 1px;
        }

        .auto-style35 {
            background-color: #000000;
        }
        .auto-style36 {
            border-top-style: solid;
            border-top-width: 1px;
        }

        </style>

<script language="javascript" type="text/javascript">
function GetURL_Alpha(){
document.getElementById("currentURL").value= location.href;
}
</script>

        <script SRC="include/general.js" language="javascript" type="text/javascript"></script>
        </HEAD>
        <BODY onload="printIt();GetURL_Alpha();" style="margin: 0 5">



<input name="currentURL" ID="currentURL" type="hidden" style="width: 1528px">

<CENTER>


<head>
<style type="text/css">
.auto-style36 {
    text-align: center;
}
</style>
</head>

    <TABLE border=0 style="width: 100%">
    <TR>
        <TD class="auto-style36">
        <font face="Century Gothic">
        <img src="logopro2.jpg"><BR>
            </font>
            <strong>
            <font face="Century Gothic" size="1">111 Test Main St Los Angeles, 
        CA 12345 </font></strong><font face="Century Gothic" size="1">
        <strong><BR>
            </strong>
            </font> <STRONG><FONT face="Century Gothic" size=1>PHONE: (888) 111-2222&nbsp;&nbsp;&nbsp;&nbsp;FAX: (877) 
        111-2233</FONT></STRONG>
        <br><br>
            </TD>
    </TR>
    </TABLE>
    </CENTER>
<table style="width: 100%">
<tr>
<td style="width: 408px"><font face="Arial">
<strong>
<h3 class="auto-style30" style="width: 492px">
FULL NAME<BR>
123 Test Ave<BR>
MIAMI, FL<BR>
</h3>
</strong>
</font>
&nbsp;</td>
<td>
</td>
<td>
&nbsp;</td>
</tr>
</table>

            <P align = center>
            <FONT face="Comic Sans MS" size=5><span class="style8">
<HR>
            <P align=center>
            <TABLE border=0 style="width: 100%" cellspacing="0">
                <tr>
            <FONT face="Comic Sans MS" size=5><span class="style8">
                <TD class="auto-style32" style="height: 31px">
                    Date:
                     10/7/2011</TD>
                <td style="height: 31px">Name:&nbsp;Someone</td>
                    <td class="style1" colspan="2" style="height: 31px">
            <FONT face="Comic Sans MS" size=5><span class="style8">
                    <strong>STATEMENT</strong></td>
                <TD colspan=3 align=right style="height: 31px">
                    Check #: 11008 
                </TD>
                    </span></font>
                </tr>
            <TR>
                <TD colspan=7 align=center class="auto-style35">
                    <span class="style5"></span>
                    <STRONG><FONT face="Arial" size=2 color="white">
                    <img src="more_images/ContainerRed.png" class="style10"> 
                    MORE INFORMATION</FONT></STRONG>                
                </TD>
            </TR>

，感谢您的帮助...

原文

I would like to know who can I retrieve the date from a file.

This is how I open my file:

    Set fs=Server.CreateObject("Scripting.FileSystemObject")

    Set f=fs.OpenTextFile(Server.MapPath("checkno_2211.html"), 1)
'Need something here to find the first date MM/DD/YYYY in the file
    f.Close

    Set f=Nothing
    Set fs=Nothing

The code above will open the .html file now I would like to find the first date that is in that file but I don't know how to do it. :-(

The .html file will have multiple dates in it, but I only need to grab the first one.
The html and format of the date is like this:

<TD class="auto-style32" style="height: 31px">
Date:
 10/7/2011</TD>

The source code of the .html file is

        <HTML>
        <HEAD>
        <script SRC="include/general.js" language="javascript" type="text/javascript"></script>
        <style type="text/css">
        textarea { 
font-size: 14px;
font-weight: bold;
font-family: Arial;
}

.style1 {
    text-align: center;
}
.style2 {
    border-style: solid;
    border-width: 1px;
}
.style3 {
    color: #FFFFFF;
    background-color: #000000;
}
.style4 {
    background-color: #000000;
}
.style5 {
    color: #FFFFFF;
}
.style7 {
    vertical-align: text-bottom;
}
.style8 {
    font-family: Arial, Helvetica, sans-serif;
}
.style9 {
    background-color: #C0C0C0;
}
.style10 {
    vertical-align: middle;
}

        .auto-style30 {
            text-align: center;
            margin-left: 0px;
        }

        .auto-style32 {
            text-align: left;
            border-bottom-style: solid;
            border-bottom-width: 1px;
        }

        .auto-style35 {
            background-color: #000000;
        }
        .auto-style36 {
            border-top-style: solid;
            border-top-width: 1px;
        }

        </style>

<script language="javascript" type="text/javascript">
function GetURL_Alpha(){
document.getElementById("currentURL").value= location.href;
}
</script>

        <script SRC="include/general.js" language="javascript" type="text/javascript"></script>
        </HEAD>
        <BODY onload="printIt();GetURL_Alpha();" style="margin: 0 5">



<input name="currentURL" ID="currentURL" type="hidden" style="width: 1528px">

<CENTER>


<head>
<style type="text/css">
.auto-style36 {
    text-align: center;
}
</style>
</head>

    <TABLE border=0 style="width: 100%">
    <TR>
        <TD class="auto-style36">
        <font face="Century Gothic">
        <img src="logopro2.jpg"><BR>
            </font>
            <strong>
            <font face="Century Gothic" size="1">111 Test Main St Los Angeles, 
        CA 12345 </font></strong><font face="Century Gothic" size="1">
        <strong><BR>
            </strong>
            </font> <STRONG><FONT face="Century Gothic" size=1>PHONE: (888) 111-2222    FAX: (877) 
        111-2233</FONT></STRONG>
        <br><br>
            </TD>
    </TR>
    </TABLE>
    </CENTER>
<table style="width: 100%">
<tr>
<td style="width: 408px"><font face="Arial">
<strong>
<h3 class="auto-style30" style="width: 492px">
FULL NAME<BR>
123 Test Ave<BR>
MIAMI, FL<BR>
</h3>
</strong>
</font>
 </td>
<td>
</td>
<td>
 </td>
</tr>
</table>

            <P align = center>
            <FONT face="Comic Sans MS" size=5><span class="style8">
<HR>
            <P align=center>
            <TABLE border=0 style="width: 100%" cellspacing="0">
                <tr>
            <FONT face="Comic Sans MS" size=5><span class="style8">
                <TD class="auto-style32" style="height: 31px">
                    Date:
                     10/7/2011</TD>
                <td style="height: 31px">Name: Someone</td>
                    <td class="style1" colspan="2" style="height: 31px">
            <FONT face="Comic Sans MS" size=5><span class="style8">
                    <strong>STATEMENT</strong></td>
                <TD colspan=3 align=right style="height: 31px">
                    Check #: 11008 
                </TD>
                    </span></font>
                </tr>
            <TR>
                <TD colspan=7 align=center class="auto-style35">
                    <span class="style5"></span>
                    <STRONG><FONT face="Arial" size=2 color="white">
                    <img src="more_images/ContainerRed.png" class="style10"> 
                    MORE INFORMATION</FONT></STRONG>                
                </TD>
            </TR>

As always,
Thanks for any help...

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

浪漫人生路 2024-12-15 18:52:53

您可以尝试这样的操作 -

Dim ParseDate, NextLineIsDate 
NextLineIsDate = False
Set fso = Server.CreateObject("Scripting.FileSystemObject") 
set fs = fso.OpenTextFile(Server.MapPath("Saved\checkno_2211.html"), 1, true) 
Do Until fs.AtEndOfStream 
    If NextLineIsDate Then
       ParseDate = Replace(Replace(fs.ReadLine," ",""),"</TD>","")
       Exit Do
    End If
    If Instr(fs.ReadLine,"Date:") > 0 Then NextLineIsDate = True
Loop 
Response.Write ParseDate 
fs.close: set fs = nothing

上面的代码应该将您正在搜索的日期输出到屏幕上。

如果文本 Date: 仅出现在文本文件中日期的正上方，则此操作将有效。如果没有，您可能需要一些更复杂的东西，但在不查看文件的所有内容的情况下很难判断。

You could try something like this -

Dim ParseDate, NextLineIsDate 
NextLineIsDate = False
Set fso = Server.CreateObject("Scripting.FileSystemObject") 
set fs = fso.OpenTextFile(Server.MapPath("Saved\checkno_2211.html"), 1, true) 
Do Until fs.AtEndOfStream 
    If NextLineIsDate Then
       ParseDate = Replace(Replace(fs.ReadLine," ",""),"</TD>","")
       Exit Do
    End If
    If Instr(fs.ReadLine,"Date:") > 0 Then NextLineIsDate = True
Loop 
Response.Write ParseDate 
fs.close: set fs = nothing

The code above should output the date you're searching for to the screen.

This will work providing the text Date: only appears directly above dates in your text file. If it doesn't you might need some thing more complicated but it's hard to tell without seeing all the contents of your file.

回复收藏 0 原文

~没有更多了~