Looking for a function that compares 2 strings

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, 2004

Ignored post by Leah posted

Darin Lee

Virtuoso

posted

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, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted

GinnyJakes

Expert

posted

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, 2006

Ignored post by GinnyJakes posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted

GinnyJakes

Expert

posted

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, 2006

Ignored post by GinnyJakes posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted

Darin Lee

Virtuoso

posted

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

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted

PBrightwell

Master

posted

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, 2007

Ignored post by PBrightwell posted

Platinum Member

posted

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, 2006

Ignored post by tlbrydie2 posted