I have a variable length field of data that needs to be validated.
Is there any way to iterate over data? For example, is there some sort of for loop, do…until, etc? If no, as I suspect, how could you handle scenario below?
Example Psuedo Code, step 3 is either a or b, not both:
- Data entered by user, triggers workflow action
- Workflow action copies Data to a hidden or virtual column so it can be worked upon
3a) Action iterates through each character, word, whatever and checks on each individually, updating the hidden column as necessary if data needed to be changed
3b) Action iterates through data and finds non conformant data, rejects the update
- Action copies modified data from hidden column back to original cell, or rejects update as determined in step3.
TIA for any assistance you may be able to provide.