Esteemed wizards,

for an internal report shedding light on which MRE domains are linked to what application directories, I use the MREXTRACT.BAT and read the information from IBIMRDOM, FIELD=DOMAIN_DESC.
Unfortunately, the information is one single string (A256), where the application directories are seperated by "%20".

Example:

TABLE FILE IBIMRDOM
BY HIGHEST 1 DOMAIN_HTM
BY HIGHEST DOMAIN_PROP
END

yields the output:

[securiti/securiti.htm][node=EDASERVE,appname=seccrm%20bankview%20baseapp]

where "securiti/securiti.htm" is the domain_htm and seccrm, bankview, baseapp are the application directories.

How can I split up the string into several records? The obvious way for me was to subsequently look for occurences of %20 with POSIT and get the substrings with SUBSTR; alas, given the length of the string there could potentially be about 20 application paths connected (we do have that many) and my cumbersome, but working, routine of POSIT-SUBSTR
has proven to be too cumbersome (and not working anymore) since our upgrade form 7.610 to 7.703.

Any sensible suggestion would be appreciated, my colleague and I tried OCCURS and DELIMITER but were too inexperienced to get any results.

If someone knows a more elegant way, by the way, to produce a report showing the connection of MRE-fexes to application directories, please feel free to show me the light (unless it would be "resource analyzer"- we have literally like a thousand reports and about 50 application directories and resource analyzer does not really perform).

Thanks,

Tom

This message has been edited. Last edited by: Tom1311,

Tom,

Think about using GETTOK with the -1 parm to get last occurence delimited by '='. Take the resultant string and, again, use GETTOK to get the three items.

You might need to use STRREP to change '%20' to something more useful (like '~'?).

T

Tony,

Thanks a lot for the suggestion, works like charm! Shame on me, I did not know the GETTOK function (looked through the functions for something like it but to no avail...)

Thx, Cheers!

Glad to hear it helped Tom. Sometimes all it needs is that thought seed

T