Recent content by TMurdach

Using taupirho's query, I modified it to return the originally desired results. How would this need to be formatted to run as an Oracle stored procedure with the string of data to sort being passed in as a variable? select rtrim (xmlagg (xmlelement (e, x || '|')).extract ('//text()'), '|')...

CORRECTION! So with that in mind, the return result should be: 0-50020:FLATWARE_10PC|1-6055154:STORAGE_BOXES_RED|1-6055159:STORAGE_BOXES_BLUE|2-6055159:STORAGE_CUBE_BLUE

taupirho. Thank you! Here is the result of the query: 01-6055159:STORAGE_BOXES_BLUE|0-50020:FLATWARE_10PC|001-6055154:STORAGE_BOXES_RED|2-6055159:STORAGE_CUBE_BLUE Very close! I see it is placing the 01-6055159 before 0-50020. Let me make an update to the desired output that might help...

I've used this forum for many years, asked a few questions, gave a few answers. I've seen the rants people go on when someone doesn't search for an answer that is already out there... I get that. But hey, I'm just looking for help with an Oracle data parsing scenario. The data I have to work...

Thank you both for the feedback! taupirho - the core application is an older GUI interface similar to Eclipse but far less powerful. It is capable or running an Oracle stored procedure so I'm disecting your suggestion to perhahps make it fit my needs. SantaMufasa - thank you for the...

Correction: Max value for DESC is 4000 characters, not 64000

I've been looking for bits and pieces of code to help solve this problem - as I will continue to do but have had success getting and providing answers on this forum. I have a home grown application which has very poor/limited functionality outside of what it was made to do - but it can execute...

If you explain what you are trying to achieve perhaps somebody has a viable solution. If you want to give the agent more time to prepare, you could introduce a whisper that lasts for 6 seconds (one ring cycle, increase the duration to your liking). The caller will still hear whatever treatment...

Thank you! I should probably mention that nearly every bit of code I used in this script was learned on this forum.

I've used a lot of information from this site to help in my daily activities, so hopefully this post will be useful to somebody here. It is very nice to have when you can't remember what you changed in a crisis, and need to set things back. It is also nice to find certain keywords or numbers in...

I don't think this will work because the single line of text is greater than 255 characters. If you have any suggestions to work around that limitation I would be glad to hear them. Thanks!

kodr - if you can give me a hint of the code I would be most gracious!!! Thank you!

Hi all, I was wondering if somebody already had code that would read a single line of text from FILE-A, and add a line break after every 10th item (each separated by comma) and write this to FILE-B? I have an application that writes its output to a single line of text and need to format this...

Thanks for the example scripts. From your scripts here is what I came up with... and it works beautifully This script is a useful way for anybody with an Avaya S8700 to gracefully busy sequential members of a trunk group. proc main string trunk1 string member1 string member2 integer number1...

My user input boxes will not work for integers... Ouch!