While pulling data on dollar amounts owed I noticed that the data pulled is text, is there a way to specify this as a number so that the Dollar sign does not get pulled with it. So fo example right now I am pulling '$100' but I just want it to be '100'.
Solution:
Hi,
I should mention I tried using the xpath replace function on the first entry by rewriting the xpath to:
//TBODY/TR[4]/TD[2][replace(.,"$","")]
that did not work so I must have something wrong with my syntax??
Thanks
You need to set content transformation Regex script to remove $
\$(.*)
$1
F.Y.I:
Content Transformation
http://manual.visualwebripper.com/default.aspx?manual_id=73860
Solution:
Hi,
I should mention I tried using the xpath replace function on the first entry by rewriting the xpath to:
//TBODY/TR[4]/TD[2][replace(.,"$","")]
that did not work so I must have something wrong with my syntax??
Thanks
You need to set content transformation Regex script to remove $
\$(.*)
$1
F.Y.I:
Content Transformation
http://manual.visualwebripper.com/default.aspx?manual_id=73860
No comments:
Post a Comment