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
how to check if the string's format is alphabetical or numeric

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
how to check if the string's format is alphabetical or numeric
cdesserich Offline
Member
***
Posts: 57
Threads: 0
Joined: Jan 2010
Reputation: 0
#4
Solved: 11 Years, 3 Months, 4 Weeks ago 09-28-2010, 08:18 PM
IsNumeric() still works with "123,231". To use the FormatNumber() function, just explicitly convert it to a number with CLng() before formatting it back to a string:

Quote:str_Value = "123,231"

If IsNumeric(str_Value) Then
___str_Value = FormatNumber(CLng(str_Value), 2)
End If
MsgBox str_Value
Find
Reply


Messages In This Thread
RE: how to check if the string's format is alphabetical or numeric - by cdesserich - 09-28-2010, 08:18 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to change 24 hrs time format to 12 hrs time format Varsha Gupta 1 2,830 04-21-2018, 11:06 AM
Last Post: Ankur
  How to validate a format of an alphanumeric string PrateepKaraval 2 5,995 11-08-2014, 10:26 AM
Last Post: vinod123
  Unable to read numeric values from WebTable into Datatable Akhila 2 4,715 11-26-2013, 03:43 PM
Last Post: Akhila
  Pdf to Excel or any other Format Conversion branjitk 1 2,474 06-14-2012, 08:14 AM
Last Post: basanth27
  How to extract numeric values hamzaz 3 3,868 04-26-2012, 03:15 PM
Last Post: ssvali

Forum Jump:


Users browsing this thread: 1 Guest(s)