Forum Discussion
Well - using the Video I mentioned, I'm able to get the full object text and write it out to the Log (i.e. ORDER # 52846772), but for the life of me when I try to do the 'aqString.Remove' option you suggest - I can't find it.
Guessing it is buried somewhere in all of the options - or I'm just blind.
Where is it located? Could you provide a screenshot, please?
Here you go - you'll need a Code Expression to do it from a keyword test
- RichBopp4 years agoContributor
Excellent!! That worked.
Now - The million dollar question - How do I take that Order #, and plug it into a Data Base Query?
We have many test cases that would find value in such a thing. Example, when a customer located in a specific ZIP code places an order, they should be serviced by the closest distribution center. So say customer in ZIP '60085' should be serviced by 'I6' -
So - How do we plug the Order Number into the Custom Query (where WBORDN = 52846802)?
Or is there another option available that will get us to the same place?
- RichBopp4 years agoContributor
Gang - Marsha_R was able to provide a solution to my original question about extracting specific text from a string. Thank you very much - this will be handy.
But my follow up 'million dollar' question - as to how to take that text (in my case an Order Number) and then insert that number into a Custom SQL query - can not be done with our current functionality.
So - I've put in a Feature Request. Maybe some day, my friends. Maybe some day.
- AlexKaras4 years agoChampion Level 3
Hi,
> can not be done with our current functionality.
Can you clarify what exactly cannot be done?
Obtained value can be stored to the variable. Later, when you compose query expression this value can be utilized either directly or as a parameter. So I am not sure what you have problem with. (Unless you are trying to do everything using only keyword operations and do not use code.)
Related Content
Recent Discussions
- 3 days agoMW_Didata