Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB
#1
Solved: 10 Years, 8 Months, 1 Week ago
Hi Ankur,

I have used SQL query to fetch an order number from database and i have stored it in datatable. I have used that value in datatable as a variable and passed in my script.
The value stored in the datatable is as below
order.453452
I want to pass the number "453452" as a variable. Can you help me with that?
Thanks in advance
Reply
#2
Solved: 10 Years, 8 Months, 1 Week ago
Hi,
You can use Split function to get the no from order.453452. Use (.) as your dleimiter.
You can get more help on split in qtp help.
Reply
#3
Solved: 10 Years, 8 Months, 1 Week ago
Code:
ReqNum=Split(order.453452,".")(1)
msgbox ReqNum
Does this help ?
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Reply
#4
Solved: 10 Years, 8 Months, 1 Week ago
I tried Split() and it works.
Thank you so much
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)