Remove line breaks from data for Replication Set

We are building replication sets to pull Supply Chain data out of FSM and send to a warehouse. We've noticed some fields such as ContractLine.ItemDescription3 allow the users to put line breaks in. Does anyone know a way to strip these out either as part of the replication or via derived field?

Find more posts tagged with

Accepted answers

All comments

ryan-schumacher

My recommendation would be to correct the source data within the Item business class for Description3 to remove the line breaks.

I come across this from time to time, as well. I do not think you can query for line breaks specifically, but I've handled this in the past with an ISD query on the Item business class, use Excel/Power Query to identify records with line breaks, remove them, then update those specific records with an upload.

cleverly

ContractLine is a BusinessClass
    owned by po

    Derived Fields

        SingleLineItemDescription3 is a DerivedField
            type is Text
            if (ItemDescription3 matches "^[^

	]*$")
                return ItemDescription3
            else
                SingleLineItemDescription3 = ""
                for each ItemDescription3 split on "<blank>"
                    if (each matches "^s*$")
                        if (SingleLineItemDescription3 size > 0)
                            SingleLineItemDescription3 += "u0020"
                    else
                        SingleLineItemDescription3 += each
                return SingleLineItemDescription3

robert-canham

Thanks, that should work. Just got asked to add a check for double-quotes in the data as well since that could mess with the text qualifiers. Appreciate the leg up on this.

robert-canham

I got it to remove double-quotes as well using another split and a temp field. It works, but if anyone wants to improve my LPL, I won't be hurt.

Item is a BusinessClass

owned by ic

Derived Fields

SingleLineItemDescription3 is a DerivedField

type is Text

if (Description3 matches "^[^

"]*$")

return Description3

else

SingleLineItemDescription3 = ""

for each Description3 split on "<blank>"

if (each matches "^s*$")

if (SingleLineItemDescription3 size > 0)

SingleLineItemDescription3 += "u0020"

else

if (each matches "^["]*$")

initialize TempDescription

TempDescription = each

for each TempDescription split on """

if (each not matches """)

SingleLineItemDescription3 += each

else

SingleLineItemDescription3 += each

return SingleLineItemDescription3

Copyright © 2025 Infor. All rights reserved.