'substring' transform returns 'null' if 'end' index is less than attribute chars count

[colin_mckibben]

Apologies. I didn’t test the transform that I gave you, and they are tricky to get right. Here is the correct transform syntax, which I tested on my end and validated that it performs the logic you are trying to achieve.

"deptname": {
    "type": "trim",
    "attributes": {
        "input": {
            "attributes": {
                "begin": 0,
                "end": 64,
                "input": {
                    "attributes": {
                        "length": "64",
                        "input": {
                            "attributes": {
                                "attributeName": "DEPT_NAME",
                                "sourceName": "Oracle ERP"
                            },
                            "type": "accountAttribute"
                        }
                    },
                    "type": "rightPad"
                }
            },
            "type": "substring"
        }
    }
}