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
Did you try clean?
docs.appian.com/.../fnc_text_clean.html
i'd actually suggest trim()... it's specifically for this sort of thing TBH.
He already tried using trim() and it didn't work which is why I assumed there were non-printable spaces in there.
i.e. www.namecheap.com/.../
a!localVariables( local!nonPrintableSpaces: { " ", " ", " ", " ", " ", " ", " ", " ", " " }, local!characterString: concat(local!nonPrintableSpaces), local!trim: trim(local!characterString), local!stripPlusTrim: stripwith(local!trim," "), local!cleanPlusTrim: clean(local!trim), { characterCodes: code(local!nonPrintableSpaces), trim: local!trim, stripPlusTrim: local!stripPlusTrim, cleanPlusTrim: local!cleanPlusTrim } )
Mathieu Drouin said:He already tried using trim()
Oof, somehow I'd missed that.