Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to extract numeric values
#1
Solved: 11 Years, 4 Months, 3 Weeks ago
Hi All,

I am working on an issue, I have a string value

str="123 344 123"

now i want to extract these values into 3 different variables
like

a=123
b=344
c=123

Any suggestion how can i do it?

Reply
#2
Solved: 11 Years, 4 Months, 3 Weeks ago
Hi,

Use split function for this.

Regards,
Sankalp
Reply
#3
Solved: 11 Years, 4 Months, 3 Weeks ago
If the values are seperated by space use delimiter as space and split the string.
E.g. str = "123 456 789"
strArr = Split(str," ")


Reply
#4
Solved: 11 Years, 4 Months, 3 Weeks ago
Try this :-

Code:
str = "123 456 786"

a = split(str," ")

For i = Lbound(a) to Ubound(a)
  Print a(i)
Next
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to extract particular digit from a string amit25007 3 3,504 10-05-2016, 10:49 AM
Last Post: Ankur
  Unable to read numeric values from WebTable into Datatable Akhila 2 4,762 11-26-2013, 03:43 PM
Last Post: Akhila
  How to extract part of a string between two particular characters. ACCBAJPA 7 5,938 08-22-2013, 02:39 PM
Last Post: ACCBAJPA
  XML Data read and extract output in an array SweetyChowdhury 9 7,862 05-10-2013, 03:05 PM
Last Post: SweetyChowdhury
Exclamation how to check if the string's format is alphabetical or numeric lotos 6 15,503 10-07-2010, 08:54 PM
Last Post: lotos

Forum Jump:


Users browsing this thread: 3 Guest(s)