You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to exclude line break, carriage return and tab in a property in EDM & send to EPBCS in extract

in Enterprise Data Management 4 comments

Summary:

EPBCS has a requirement wherein they want all the line breaks, carriage return and tabs in a property to be replaced with a space. They are using the extract out of EDM to consume the value as data as opposed to metadata since line breaks are causing issues.

EDM admin guide has an example of deriving the MEMO property type but then again, we are not able to derive it. Admin guide also mentions how we cannot derive a MEMO property type which I believe is a discrepancy.

We are getting the property from PPM to EDM as a free text STRING property and we are successfully able to consume it, we are also sending the value to EPBCS and are quoting all the columns with double quotes but since Planning is treating this as data and not metadata, line breaks are causing their rules to fail. How can we achieve it in EDMCS?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!