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 |
Explain the difference between check point and output value?
what is frame work of qtp?
what is the frame work in J-meter?
My project title is "DRUG Audition and research management" it comes which domain?
How do you data drive an external spreadsheet?
How many types of parameters are available in quicktest professional (qtp)?
Does the Existing reusable action can be modified at the time of calling the action?? Please help me..
how to write the descriptive programming in QTP for loginwindow.without using Step generator,object repository for referecnes
What are the drawbacks of QTP?
why use Description programming? what is advantages and disadvantage of this methods?
What is difference between Class and MicClass
how to connect qtp to sqlserver?(if any body know about this please send mail to me:sheik_feroz5@yahoo.com)thank u