Forum Discussion
1125NEWBIUSER
Helper I
Helper IRemove trailing zeros only when there are three in a row
Hi All, I am trying to add a column next to current column that will take our customer numbers and show them as is unless it ends in three 0's and if it does, I want to show without only the trai...
Thank you JorgePinho,
I just did this and and now getting another syntex error. My customer ID's are not only numberic but some have text. I am now getting error about issues converting field to value. Is this needed for what I am even trying to do? Any hints? Below is message now. Thanks! Chris
1125NEWBIUSERHelper I
Helper IThank you JorgePinho,
I just did this and and now getting another syntex error. My customer ID's are not only numberic but some have text. I am now getting error about issues converting field to value. Is this needed for what I am even trying to do? Any hints? Below is message now. Thanks! Chris
deevaker
Resolver I
Resolver Ias JorgePinho mentioned, please use -3 out of len function please
- 1125NEWBIUSER
Thank you, I missed that. By changing that did the trick!
- deevaker
Great