trim a field in LPL

Legacy Contributor

Please help to trim a field in LPL

For example: if Code="Test Mfr1", How to get the output as "TestMfr1"?

Thanks,

Thiru

Legacy Contributor

You can create one transient field to store size of Code and one transient field as subscript on newfield and then loop to check spaces, something like as shown below

CodeSubscript = Code size

NewCodeSubscript = 1

while (CodeSubscript > 0)
    if (Code[CodeSubscript] entered)
        NewCode[NewCodeSubscript] = Code[CodeSubscript]
        NewCodeSubscript +=1
    XYZSubscript -= 1

You can also use regex if you don't want non-printable characters to be removed.