Hi I am trying to remove space Infront of 9 as shown in below image
I tried with trim but still the space is coming < can anyone help me with this?Attached my code in this message
a!localVariables( local!allocatedLoads: rule!PLSB_QR_queryAllocatedLoadsForDashboard(allocatedId: 2058), local!vin:trim(local!allocatedLoads['recordType!{e48e7749-5c4f-4ece-89a1-1f096042fbc5}PLSB Allocated Loads.fields.{e79eb6a6-7005-42cb-ae7e-72dcb80c9d34}vinNo'][1]), local!vin )
Discussion posts and replies are publicly visible
Depends on what is the value. It is going to be a sentence where you only want to remove extra spaces but would want keep the right number of space between every word, then like Mathieu said, you can go with clean.
But if you want to remove all the spaces, no matter what, then substitute can help you.