How to restrict the length of string in DRM during export?

Remember it has impact on all the versions in the application

Step 1: Navigate to Administer -> System Preferences

Step 2: Double click “MaxDescr” and enter the required length and then save, this restricts the length of Core.Description property.

Creating one Derived property:

Create one derived property by keeping default settings as it is, in the parameter tab keep the below formula

If(Equals(String,SubString(PropValue(Custom.Description-Input),80,1),SubString(PropValue(Custom.Blank),2,1)),SubString(PropValue(Custom.Description-Input),0,79),SubString(PropValue(Custom.Description-Input),0,80))

Note: This property fetches first 80 characters from Description-Input; you must have Blank and Description-Input properties before writing this property. Blank and Description-Input both are defined properties.

Customizing the export:

Step 1: Navigate to the “Target” tab in the exports.

Step 2: Check “Fixed Width” option available in Format group 

                                    

Step 3: Specify the required length for each column and save the changes in “Fixed with Options”, the downstream system has to trim the extra spaces besides node name.




Happy learning :)