Skip to Content
0
Feb 05, 2016 at 04:03 PM

how to make regex_replace work in Data Services 4.2

2004 Views

I am trying to figure out the right syntax for using regex_replace in a mapping in SAP Data Services 4.2

I need to clean the Description field from the Ledger for reporting purposes.

Example: I need to standardize certain keywords, one of which is INVENTORY.

The data includes:

INVY

INVTY

INVENTY

INVTRY

I want to change INV[A-Z]* (regexp for INV and 0 or more letters after it) into INVENTORY

SAPDS keeps telling me that {A} is not a valid parameter.

I tried other regex variations, including :alpha:, and it tells me {:} is not a valid parameter.

so what is the right way to make this work without any errors?

regex_replace(QRY_Clean.ACCT_DESC, 'INVEN[A-Z]*$','INVY')

gives me the error above

Message was edited by: Bruce Robert