Locate position of 8th ":" in text field and report on text

[DrSmyth]

Hi,

I'm reporting on a notes field that has 10 ":", the text after each ":" relates to a different aspect of the notes field. I need to report on the text after the 8th ":". I've got it to work by building about 16 UDO's and using them in unison e.g
first udo finds first ":" and then reports on string after that, second UDO finds first ":" in first UDO and reports on the string after that.

Although this works it takes an incredibly long amount of time to run. Can anybody think of an alternative solution?

I'm running 6.5 on a db2 database...

Thanks Dr

 

[Jembo]

I have just done a similar exercise and had to create a separate variable in the universe for each word in my string. The process I used sounds similar to what you are doing, but if you are only after the text after the 8th ':' then why 16 UDO's?
Not sure if this helps but the syntax I used (using space char as the delimiter) is;

Substr(Field, Instr(Field, ' ', 1, 8)+1,
Instr(Field, ' ', 1, 8) - Instr(Field, ' ', 1, 7)))

So for you query substitute 'Field' for your field name and ' ' (space) for ':'.

 

[DrSmyth]

Sounds like a good idea, think i was seperating the elimants of the query too musch (eg, UDO was using provious UDO to locate start of string...

I'll give this a go..

Thanks