+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to eliminate unwanted data (/Thread-How-to-eliminate-unwanted-data)
How to eliminate unwanted data - automation2012 - 08-31-2012
I have to capture only the value but i can see some unwanted data .. please help me on this..
val = $13.97N/A
i want output to be displayed as $13.97
for eg: if $133.96N/A even in this case it should hold gud...someone please help me in this regard.
RE: How to eliminate unwanted data - basanth27 - 09-01-2012
Is it N/A which occurs everywhere? or you are suggesting that there could be anything after the number?
If it is N/A then you can do a mere split by using the delimiter as N. Also if it is due to extra space or unwanted charachters then use the Trim.