I don’t know if this is possible, but I’ve hit a wall and can’t figure something out.
I have an split text column that is made up of a unique value and then two pieces of text (3 columns that are combined using a template column, with items separated by “|”). The result is something like “Unique|abc|def , Unique|ghi|xyz”. This array can have multiple elements, each one beginning with “Unique”.
I’m looking to remove my “unique” text from each of the elements in the array so that my new array is just “abc|def, ghi|xyz”
I tried that, but I think my issue is that I need to modify the individual items that make up the elements of the array, not the actual elements themselves. Apologies, I’m probably not using correct terminology.
I think I need to use a text plugin to remove the first section of my text column — the first “element” of each 1|2|3 item to get a result of 2|3 to be used in my array.
Here are some screenshots:
Split Text Array (created from a choice component with multiple selection):
The new array should remove the “100409…” unique value and only contain the "January|2022, April|2022, etc).
Alternatively, I may have just discovered why @Robert_Petitto wants to have the left side of the template column configurable… If I could configure the “Unique value” to be replaced with nothing/blank, I think that would easily remove it from my array in a really simple process.
I don’t know much about Regular Expressions… but in my mind this should work (but results in absolutely nothing!).
I have my unique value as a column… I add a template column that adds ^ to the beginning and “$” to the end of it. I use that as my Regular Expression in the “Extract Multiple Matching Texts” column… I would think that this should remove the Unique value from the text column… but it doesn’t.
Oh wow good timing haha… I’ll try that expression.
Edit… not giving me any result. I tried with both the Extract Text and Extract Multiple Text columns. My “Text” is the comma-separated list of items (each comprised of two “|” ) and then I pasted in your expression as the regular expression.
Haha sorry! This got me somewhere… but it only results in the last item in the array being displayed (as opposed to each element that used to contain the unique string).
Screenshot shows it “found” September 2022 as two separate elements, but didn’t find “February 2022”, which was another item in my comma-separated list.
No, I was hoping for “February|2022,June|2022,September|2022” … basically just removing “698ff6f8-1970-47a9-b2f6-05b606f2c372” from the entire line of text each time it appears.
I have that “698ff6f8-1970-47a9-b2f6-05b606f2c372” as a separate column too… so I thought I could use it as my text to extract… something like
where I replace UNIQUE with my “698ff6f8-1970-47a9-b2f6-05b606f2c372”.
If it’s too wild, I think I can restructure so that my initial data is captured differently and then my unique value gets added to it afterwards…
I think I’ve created a work-around where I first pull in my Month|Year and then I use a template to add the Unique value… then create the joined/split lists from there. It’s working backwards, but I end up with the data I need… I think! Haha
