Selection Techniques - Can parts of text be filter during extraction

Posted by Agung Pambudi in ,
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'.



I should mention I tried using the xpath replace function on the first entry by rewriting the xpath to:


that did not work so I must have something wrong with my syntax??


You need to set content transformation Regex script to remove $



Content Transformation

No comments:

Post a Comment