Syntax For Parse Rule Sets To Mirror The Equivalent Of A LIKE Command In SQL
(Doc ID 2519441.1)
Last updated on DECEMBER 09, 2019
Applies to:Oracle Fusion Cash Management Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.
On : 11.13.19.01.0 version, Set Up CTM-Define Bank Statement Processing and Reconciliation
Syntax for parse rule sets to mirror the equivalent of a LIKE command in SQL
How to create Parse Rules for BAI2 format that returns REHAB, regardless of where it may lie within the same bank transaction code
XX,XXX,+XXXXX,S,XXXXX,+0,+0,XXXXXXXXXXXXXX,,ACH CREDIT SETTLEMENT - /88,Comp Name: REHAB HOSPITAL
XX,XXX,+XXXXX,S,XXXXX,+0,+0,XXXXXXXXXXXXXX,,ACH CREDIT SETTLEMENT - / 88,Name - RE: REHAB HOSPITAL
In both cases, I want the target to be REHAB HOSPITAL
How to structure the syntax to do that? In the first example, it might say Name:(2-14), but in the second example, it would need to be Name - RE:(2,14). These may be in the same bank account so unable to create separate parse rule sets. Is there a way to create the syntax to find REHAB HOSPITAL and place that in the target?
Is there syntax available that states:
if the addedum contains XXXXXXXXXXXX anywhere use it. It could be preceded by different text so you cannot search for text and then return the characters after. It needs to search for text and if it is found use it.
How to write that syntax?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document