As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
I am using dialogue manager to replace a "^" character with a "&" character, but the variable that is being used is over 5000 characters in length and it's failing:
May be a pain, but what if you split your variable into two (or more) of 4000 char (or less) each, then perform the STRREP to each and merge them back into one var ?
The CTRAN function translates a character within a character string to another character based on its decimal value. This function is especially
useful for changing replacement characters to unavailable characters, or to characters that are difficult to input or unavailable on your keyboard. It can also be used for inputting
characters that are difficult to enter when responding to a Dialogue Manager -PROMPT command, such as a comma or apostrophe. It eliminates the need to enclose entries in single
quotation marks (').
To use CTRAN, you must know the decimal equivalent of the characters in internal machine representation. Note that the coding chart for conversion is platform dependent, hence your
platform and configuration option determines whether ASCII, EBCDIC, or Unicode coding is used. Printable EBCDIC or ASCII characters and their decimal equivalents are listed in
Character Chart for ASCII and EBCDIC.
In Unicode configurations, this function uses values in the range:
♦ 0 to 255 for 1-byte characters.
♦ 256 to 65535 for 2-byte characters.
♦ 65,536 to 16,777,215 for 3-byte characters.
♦ 16,777,216 to 4,294,967,295 for 4-byte characters (primarily for EBCDIC).
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
Originally posted by Troy_proffitt: I assume, you'd have to change : -SET &SPLIT1 = SUBSTR(&LONGSTR.LENGTH, &LONGSTR, 1, 4000, 4000, 'A4000'); -SET &SPLIT2 = SUBSTR(&LONGSTR.LENGTH, &LONGSTR, 4001, &LONGSTR.LENGTH, 4000, 'A4000');
correct?
Yes, but the way I wrote the code I made it more flexible using parameters &MAXLEN, &POS2. So, you don't need to change numbers at several places I also insure that the string have no spaces at the end. What you are doing when you are keeping all the variables with a fix length of 4000
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013
*** parm_list In : I need to replace all "^" character with a "&" character, in a 5000+ character variable. "^" ***
*** parm_list Out: I need to replace all "&" character with a "&" character, in a 5000+ character variable. "&" ***
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005