Hello, i have two fields linked together: A ""Parser" field and a "output" field. What I am doing is scanning in a barcode with text data attached to it. I want to populated the "output" field with part of the text data, so I created a "parser" field and told the "output" field to perform this calculation:
Left ( Parser ; Position ( Parser ; "-" ; 1 ; 1 ) -1 )
Which parses the text in the "parser" field by the "-", and returns the first part of the field. The problem with this is I have multiple barcodes I need to scan, so I want to delete the data in the "parser" field. This deletes the data in the "output" field.
What calculations step can I add to the "output" field's calculation to prevent the field from being deleted?