get the order no from the following orderdetails
orderstring="ORD13456PNR"
eg:13456
Answers were Sorted based on User's Feedback
Answer / mdbasha7862@gmail.com
orderstring="ORD13456PNR"
'we can use mid function
string1=mid(orderstring,3,5)
msgbox (string1)
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / phani
Dim text,num,only_text
text=inputbox("enter text")
n=len(text)
For i=1 to n
a=mid(text,i,1)
if isnumeric(a)=true then
num=num&a 'numbers are store in this
else
only_text=only_text&a 'text is stored
end if
Next
msgbox num
msgbox only_text
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / babu
The answers mentioned above will work only when we know the
format of the data entered.
But if you want to generalize the function.
We have to select each and every character from the string
and check when the character is a numberic of alphabet.
If it is numeric, then you can add it to a temporary
variable. So, we will get the value of the order number.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / giriyappa badagar
ordStr="ORD13456PNR"
'we can use mid function
string=mid(ordStr,4,5)
msgbox (string)
OR
ordStr="ORD13456PNR"
msgbox right((left(ordStr,8)),5)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / friend
i think we ll get order no exactly by using regular expression
concept......
orderstring="ORD13456PNR"
set r = new regexp
r.pattern="[0-9]+"
set n=r.execute(orderstring)
for each num in n
prrint n.value
next
am i correct.....
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / friend
no one is not given correct answer for dynamicaly how to write..plz give the answer for dynamicly hw to write.. we cant expect the number where its come next time right ..so at that time also we want to get correct output
thank u
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srikanth
Dim mystring, myLength
mystring = "ORD13456PNR"
myLength = Len(mystring)
For i = 1 To myLength
If Asc(Mid(mystring, i, 1)) <> 32 Then
If Asc(Mid(mystring, i, 1)) >= 48 And Asc(Mid(mystring, i, 1)) <= 57 Then
myNumber = myNumber & Mid(mystring, i, 1)
End If
Else
msgbox("no numeric")
End If
Next
msgbox(myNumber)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nihar ranjan
orderstring="ORD13456PNR"
'we can use mid function
string1=mid(orderstring,4,5)
msgbox (string1)
'It will work definitely.......
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raghu
ordStr="ORD13456PNR"
msgbox right((left(ordStr,9)),5)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / qtp
use instrrev or InStr and get the index position using the
search string as PNR
after that bye using the mid function we can get the order
number
var pos=instr(order string,"PNR")
string1=mid(orderstring,3,pos)
msgbox (string1)
Is This Answer Correct ? | 0 Yes | 2 No |
Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.
what is supply chain management?
Discuss quicktest professional environment?
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
What are the different types of recording modes?
When should I use smart identification?
what is use of the object repository?
What the differences are and best practical application of Object Repository?
I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?
how can i pass parameters into function?
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
tell me abt a time when u had to go above &beyind the call of duty to get the job done