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: 12 Years, 10 Months, 2 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 3,593 04-21-2018, 11:06 AM
Last Post: Ankur
  How to validate a format of an alphanumeric string PrateepKaraval 2 6,744 11-08-2014, 10:26 AM
Last Post: vinod123
  Unable to read numeric values from WebTable into Datatable Akhila 2 5,254 11-26-2013, 03:43 PM
Last Post: Akhila
  Pdf to Excel or any other Format Conversion branjitk 1 2,859 06-14-2012, 08:14 AM
Last Post: basanth27
  How to extract numeric values hamzaz 3 4,572 04-26-2012, 03:15 PM
Last Post: ssvali

Forum Jump:


Users browsing this thread: 4 Guest(s)