Hi All,
I have a text array and I want to update a value in a given row from another text array based on a key that is stored on for each row of the two arrays. The second array really just gives an update, for a given record in array 1. Even though it is a text array and just one text field to bubble, each row has a set of delimiters that I use to calculate the different fields.
I tried to do a search replace on the first array and on the replace value, reference the second text array, where i would put a filter to get the key from the second array to match the first array. However, on search replace, it doesn’t give you the option to refer to ‘this text’ for the first array so I can’t use it to match keys.
Does anyone know how I could change a value within a specific row of a text array by looking at a second text array and matching based on an id field stored in both?
I know I can delete that row from the original, but then I would have to resend the full record each time for an update even if I just wanted to update one field.
Thank you!