I'm using a regex in a workflow to extract some text from a string, save it to a variable and then update a column with that variable (if it doesn't already match).
However when the column is updated, the value entered has [" "] around it - does anyone know why?
RANDOMSTRING1 - RANDOMSTRING2 - RANDOMSTRING3
[" RANDOMSTRING2 "]
Any help greatly appreciated, example here: regex101
Solved! Go to Solution.
Your first reply did remove the whitespaces which is great, however the result when written to my sharepoint column still contains the additional [" "]
Please could you give a little more detail about the requirement for a collection operation? I've never used this before and am fairly new to nintex...
Are you saying we need to save this variable to a collection and then select the item from the collection rather than from the variable?
Exactly. Save this to a collection variable. Then create a integer or number variable and set this to a default value of 0. Then use a collection operation of get and use the number variable for the index and save this to a text variable and you should get the desired result.
Any more problems let me know
Get Outlook for iOS<https://aka.ms/o0ukef>
Sorry for slow reply - only just got around to testing this out. Even when I add the trimmed values to a collection ID, when I retrieve the collection ID it still has the extra [" "] around it...
My steps are:
I'd be grateful if you could cast your eyes over it and tell me if I've got a step wrong or out of order please! Of course let me know if I can provide more info
Hi Kevyn Williams
I think you have to many steps. the output variable from the Regular Expression should be a collection variable.
Then just use the Get item from collection.
I have just tested this and have completed what you want in 2 steps. You can add the input text of the regular expression to be the Current Item: Project value. Although there is absolutely nothing wrong with storing it in a variable first.