Hello,
I am wondering how to remove additional characters in a workflow to prevent the following output below after the workflow runs???
I tried using the small round Fx button and selected string as default but no luck...
Hello,
I am wondering how to remove additional characters in a workflow to prevent the following output below after the workflow runs???
I tried using the small round Fx button and selected string as default but no luck...
Hi
That is a Dictionary value. Use the Get Item from Dictionary to extract the value of the key “results”.
Get Item from Dictionary
Dict: <state the Dictionary source variable>
Item name: results
Output: CompanyName which should be h“COMPANY NAME”]
Then use Regular Expression or replace string to cleanup and get → COMPANY NAME
or use Get Item from Collection at index position 0 on the CompanyName
Actually, it can be done with a single Regular Expression action when the start and end anchor (the text structure) is consistent.
The start anchor is → “result”: l“
and the end anchor is → “]}
String: <Your source value>
REPLACE Operation
Pattern: (.+)(\"results\":\"\+\")(.+)(\"]})
Replacement String: $3
Output: <Your output variable>
Hi
Did these solve your question?
Hello. I’m still looking into the response and trying to get the expected result.
ISSUE: REMOVE all characters and grab “Trade Show” (below)
{"__metadata":{"type":"Collection(Edm.String)"},"results":u"TRADE SHOW"]}
I do apologize for the time it took in getting back to this but the only success I got in this was:
1.) Creating a variable within my workflow
2.) Use Regular expression
My final result is:
Not sure how to remove :r“”]}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.