Newbie Questions

Re: Removing the first character of a text string if it exists.

fuzzbear — Mon, 06 Jan 2014 18:47:45 GMT

Thank you so much, I didn't know that I could set a rule to just run like that! Thank you!

Re: Removing the first character of a text string if it exists.

Jimmy — Mon, 06 Jan 2014 17:36:11 GMT

How about putting the following rule on the field in question:

Condition: [field] starts with P
Action: Set [field] to substring([field], 2)

substring-after([field], "P") should be able to remove the P from the field, but without a condition to stop the rule's execution, it will run repeatedly until there's nothing left in the field.

Removing the first character of a text string if it exists.

fuzzbear — Mon, 06 Jan 2014 16:02:08 GMT

I have a form that users can fill out by either typing in by hand, or by using a barcode scanner attached to a computer. Unfortunately the bar-code contains an extra character we do not want. If a user scans our part number field, the scanner inputs "PXXXXXXXXX" If the user types in the number by hand they simply omit that P. SAP uses that first letter for something so I cannot have it removed from the label. The big problem is that our part numbers are alpanumeric and the Letter "P" could exist somewhere else in the field, so translate to a space wont work. I have tried substring-after, but it is blanking out the field no matter what I type. Anyone have any other suggestions? Ray