Field Value Manipulation
Field Value Manipulation
Sometimes, we need to make use of only certain parts of a field
For example I have a serial number with the first 4 character always changing.
field1=substr('{field2}',i,n)
By making use of the above in Set Current Event Values Action, it will become
field1=substr(‘{field2}’,0,4)
- field1 — the field where we want to store the new value.
- field2 — the field where we want to retrieve part of the value from.
- i — the position from where we want to retrieve the value
- n — the number of characters we want to retrieve.
