Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to check if the string's format is alphabetical or numeric
#1
Solved: 10 Years, 9 Months, 1 Week ago Exclamation 
hi all,
I have an issue with string formats.
As a result of some queries within DB I am getting or text values or numeric values assigned to my string, for e.g:
str_Value = Y
or
str_Value = 123

how can I check if "str_Value" is numeric or text format?!

The idea is that if it is a numeric format, I should change it's format:
Code:
str_Value = FormatNumber(str_Value, 2)
if not It will remain as it is within DB (text)
Reply


Messages In This Thread
how to check if the string's format is alphabetical or numeric - by lotos - 09-28-2010, 01:20 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,659 04-21-2018, 11:06 AM
Last Post: Ankur
  How to validate a format of an alphanumeric string PrateepKaraval 2 5,818 11-08-2014, 10:26 AM
Last Post: vinod123
  Unable to read numeric values from WebTable into Datatable Akhila 2 4,484 11-26-2013, 03:43 PM
Last Post: Akhila
  Pdf to Excel or any other Format Conversion branjitk 1 2,348 06-14-2012, 08:14 AM
Last Post: basanth27
  How to extract numeric values hamzaz 3 3,596 04-26-2012, 03:15 PM
Last Post: ssvali

Forum Jump:


Users browsing this thread: 2 Guest(s)