Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Looking for a function that compares 2 strings

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Looking for a function that compares 2 strings
 Login/Join
 
Platinum Member
posted
Hello,

I am looking for a function that compares two strings. I looked at STRCMP, STRICMP, & STRNCMP functions. They all seem to the length of the string. My report will need to compare the actual data in the string. For example I may need to compare 'focus/webfocus' to focus/webfocos'...my report list both srtings where differences are present. Any help with this will be greatly appreciated.

Thanks




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Virtuoso
posted Hide Post
If you are looking for equality of values just do 'if stringa eq stringb' in a define or 'where stringa eq stringb' in a select. WebFOCUS does a character compare and ignores trailing blanks has been my experience.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Virtuoso
posted Hide Post
or in his case where they are not eq.

Should just be able to
TABLE FILE FILENAM
PRINT
WEBFOCUS
WEBFOCOS
WHERE WEBFOCUS NE WEBFOCOS;
END

no functions necessary!


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Platinum Member
posted Hide Post
Thanks Darin....




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
Ok Here's my problem...I need to produce a report simular to this
  
merch          merchdata1    merchdata2   
      
label1:
label2:
label3:


1.heading always print
2.if a difference exist between merch1&merch2 print the two differences under the correct merch.
3. if the difference occurs for row labled lable3...still print label1 & label2 (with spaces)..only lable 3 should show the differences (under merch1 & Merch2)

synopsis: print all labels if a difference exist anywhere, however only print the differences and still print all other lables.

If anyone might offer some assistance I'd truly be greatful.

Thanks




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Expert
posted Hide Post
Maybe an example with data would be in order. For differences, what is the base? merchdata1 or the label field? What do you want to see for differences, the character where they start to differ?

I think we need more info.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
The image that I have is too large to place here ...any suggestions?




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Expert
posted Hide Post
Just add to the example in your previous post showing sample input records and the output you expect in each of the columns. Show each condition you want to evaluate.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
This is what it is to look like


 
                                         Daily Discover Data Exception rpt
                                                 report date: 01/01/2008
bank:2000

Merchant Data          Discover Registration Record        Tsys Merchant record
-------------          ----------------------------        --------------------
Acurier ID:123456      Disc Acct Nbr:67891

DBA NAME:              Pencil Smart                        Pencil Think
DBA Addr 1:
DBA City:
DBA Zip:               30390                               30309
DBA State:
DBA Phone:

 


So as you can see I am to only ptint the differences that are occur + all the other lables that exist on the report. by differences I need to compare the two fields if a difference is present then print it esle do not print. If no differences exist then that merchant




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
The DB is Informax...however we are utilizing SQL passthru...pulling the data bake into a hold file. Then filedef'ing that hold file to the program




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Virtuoso
posted Hide Post
First issue is that you're wanting to display multiple lines for each record. Option 1 is to use the MacGuyver technique (you can find it multiple times on this forum via the search facility. Option 2 is to manually create headings using SUBHEAD (or just put them in the page heading) and then use the OVER command to simulate multiple records.

Then your question - you will probably need to define two new fields for each label to use in your comparison.

Something like

DEFINE FILE FILENAME
LABEL1/A9='DBA Name:";
DBANAME_DR/format=IF discoverfield EQ merchantfield THEN '' ELSE discoverfield;
DBANAME_TM/format=IF discoverfield EQ merchantfield THEN '' ELSE merchantfield;
...repeat for each label
END
TABLE FILE FILENAME
HEADING
"DAILY DISCOVER DATA EXCEPTION REPORT"
" "
PRINT
LABEL1 AS '' DBANAME_DR AS '' DBANAME_TM AS '' OVER
LABEL2 AS '' field2_dr AS '' field2_tm AS '' OVER
etc.
BY ACURIER_ID NOPRINT
ON ACURRIER_ID SUBHEAD
"Merchant Data <+5>Discover Registration Record<+5>Tsys Merchant Record"
" "
"Acurier ID: Disc Acct Nbr:"
ON ACURIER_ID SKIP-LINE
WHERE (DBANAME_DR NE DBANAME_TM) OR
(field2_dr NE field2_tm ) OR
etc.;
END

This message has been edited. Last edited by: Darin Lee,


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Platinum Member
posted Hide Post
Thanks for your time & the information you provided Darin...I'll look for the MacGuyver technique. Thanks again




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Master
posted Hide Post
Try MATCH logic, something like:
<
TABLE FILE FILE1
SUM FIELD1
BY MERCHANT_DATA
BY FIELD1
RUN
FILE FILE2
SUM FIELD2
BY MERCHANT_DATA
BY FIELD2 AS 'FIELD1'
AFTER MATCH HOLD OLD-NOR-NEW
END
>
This will give you a file of only the items that did not match. You will have to play with the output to make it exactly what you want.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Platinum Member
posted Hide Post
Thanks alot for the suggestion PBrightwell....




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Looking for a function that compares 2 strings

Copyright © 1996-2020 Information Builders