Jump to content

PatrickMc

Members
  • Posts

    1
  • Joined

  • Last visited

Reputation

0 Neutral
  1. To extract prices and other numeric or non-numeric values from html tables, there is a very good script posted at http://www.biterscripting.com/install.html . Now, to take care of the k (1000) and m (1000000) notations, I would add the following at the end of that script. while ( { sen r -c "^;k^" $csv } > 0 ) sal -r -c "^;k^" ",000" $csv > null while ( { sen -r -c "^;m^" $csv } > 0 ) sal -r -c "^;m^" ",000,000" $csv > null Add the above before the echo $csv line in the script. I am using -c (case insensitive option) and -r (regular expression), because k and m may also appear as "K or "M" or " K" or " M", etc. Patrick
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.