Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to eliminate unwanted data
#1
Solved: 11 Years, 3 Months ago
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.
Reply
#2
Solved: 11 Years, 3 Months ago
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.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Unwanted iterations When I am running Excel Sheet Uma 1 2,876 08-17-2011, 05:24 AM
Last Post: Uma

Forum Jump:


Users browsing this thread: 1 Guest(s)