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:

Goal

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?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.