?
Solved

Read one value in file

Posted on 2000-05-03
9
Medium Priority
?
146 Views
Last Modified: 2010-03-05
Hello,

I have a file called test.html
I want to read the file and split it into three part and then split to get the variable $correction.

The following is in the file:

---more html---

      <p> <small> </small>
      <table cellpadding=0 cellspacing=0 height="99">
        <tr>
          <td nowrap valign=top height="48" width="300"> <br>
            Wednesday, May 3, 2000 <!-- conversion result starts  -->
            <p><b><font color="#153168"> <font color="#bc0a17">1</font>
              Dutch Guilder = <font color="#bc0a17"> 0.4125</font>
              US Dollar </font></b> <!-- conversion result ends  --> <br>
              1 US Dollar (USD) = 2.4242 Dutch Guilder
              (NLG)
            <p> <small>Median price was 0.4122 / 0.4125 (bid/ask).<BR>
    Minimum price was 0.4098 / 0.4099 <BR>
    Maximum price was 0.4163 / 0.4168 <BR>
</small>
          </td>
          <td colspan="2" height="48">&nbsp;</td>
        </tr>
        <tr>
--- more html------

I now want to split the file into three parts. Above <!-- conversion result starts  -->

Between <!-- conversion result starts  -->  and <!-- conversion result ends  -->

and down <!-- conversion result ends  -->

Now I want to split the middle part:

Here I have three variables:
$test1 = "Dutch Guilder";
$test2 = "US Dollar";

I want to split this part untill I have the value (0.4125) before $test2.
The value has to be called $test3.

Can someone help me??
0
Comment
Question by:mmcw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
9 Comments
 
LVL 16

Accepted Solution

by:
maneshr earned 400 total points
ID: 2773660
try this...

if the HTML tags in you file are more complicated, then use can use the foll piece of code.

REPLACE ...
$html_text =~ s/<[^>]*>//g; ##  Remove any HTML tags

WITH...

use HTML::Parse;
use HTML::FormatText;
$html_text = HTML::FormatText->new->format(parse_html($html_text));


=====================guilder.pl
#!/usr/local/bin/perl


##  Read the ENTIRE html file in a variable.
$/="";
open(HTM,"/tmp/more.html") || die $!;
$file=<HTM>;
close(HTM);
$/="\n";

##  Remove the \n chars from that variable.
$file=~ s/\n//g;
##  Extract the relevent part.
$file=~ /(.*)<\!-- conversion result starts  -->(.*)\!-- conversion result ends
  -->(.*)/;

##  Store the extracted part in a variable.
$html_text=$2;
$html_text =~ s/<[^>]*>//g; ##  Remove any HTML tags
$html_text=~ s/\s+/ /g;     ##  Squeeze multiple white spaces to a single space
..
$html_text=~ /$Dutch Guilder\s+=\s+(\d+\.?\d+)/;  ##  Get the currency value!!

$test3=$1;
print $test3;
0
 

Author Comment

by:mmcw
ID: 2776487
The part of extracting does not work!!

##  Extract the relevent part.
$file=~ /(.*)<\!-- conversion result starts  -->(.*)\!-- conversion result ends
  -->(.*)/;

The result of this is the same as when not extracting!!

Can you help me!!
0
 

Author Comment

by:mmcw
ID: 2776491
By the way: I had to change the starting code from: $/="";
to: undef $/; to get the whole html file!!

Otherwise you get only the part till </head>
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mmcw
ID: 2776593
The extrating works when you change the starting code. See my last comment.

Thank you.

Could you take a look to the question I asked:

http://www.experts-exchange.com/jsp/qShow.jsp?ta=perl&qid=10337436 

You told me you had the answer!!
0
 
LVL 16

Expert Comment

by:maneshr
ID: 2777024

glad to know that undef $/; worked for you.

i have a Q for you though.

what version of PERL are you using?. What platform are you running the script on?? what webserver areyou running???

the reason i want to know this is because $/=""; works fine on my solaris box.


"Could you take a look to the question I asked: "

pl. check my comments.
0
 

Author Comment

by:mmcw
ID: 2777046
After changing the first line thescript workes!!
0
 
LVL 84

Expert Comment

by:ozo
ID: 2779354
$/=""; #sets paragraph mode, so it will separate records at empty lines.
0
 

Author Comment

by:mmcw
ID: 2783410
Question: Sometimes the number looks like this: 0.4125

The script workes fine.

But somethimes the number looks like this: 1,926.22

The script will not work.

I have checked the script:

It will work till:
$html_text =~ /$$base_currency\s+=\s+(\d+\.?\d+)/;

The the sesult will be "";

Can zou fix it to make it work for both format of numbers?
0
 
LVL 84

Expert Comment

by:ozo
ID: 2783424
/([\d,]+\.?\d+)/
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many situations when we need to display the data in sorted order. For example: Student details by name or by rank or by total marks etc. If you are working on data driven based projects then you will use sorting techniques very frequently.…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Six Sigma Control Plans

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question