New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
Removing commas from a string and changing it to number

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Removing commas from a string and changing it to number
BVVPrasad Offline
Junior Member
**
Posts: 21
Threads: 7
Joined: Jul 2010
Reputation: 0
#2
Not Solved 12-29-2010, 02:32 PM (This post was last modified: 12-29-2010, 02:32 PM by BVVPrasad.)
Hi Indranil,

Try this:

Code:
strData="1,99,98,774"
RetVal=ConvertStringToNumber(strData)
msgbox RetVal

Function ConvertStringToNumber(ByVal Str)
    Str=Cdbl(Replace(Str,",",""))
    ConvertStringToNumber=Str
End Function

Thanks,
Prasad
Find
Reply


Messages In This Thread
RE: Removing commas from a string and changing it to number - by BVVPrasad - 12-29-2010, 02:32 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Changing Data in the application newbieny 0 872 07-17-2019, 07:19 PM
Last Post: newbieny
  Removing ASCII Control Characters from a file Nithin 0 5,517 09-30-2013, 11:45 PM
Last Post: Nithin
  VB Script:number of times a character appears in a string with position Jyobtech 1 11,814 08-07-2013, 01:03 PM
Last Post: anil2u
  How to have a variable that has a string comma string .. shareq1310 5 4,818 11-09-2011, 03:33 PM
Last Post: parminderdhiman84
  Changing default browser cowboy49 5 9,401 09-08-2011, 04:02 PM
Last Post: souvikghosh_diatm

Forum Jump:


Users browsing this thread: 1 Guest(s)