Way to Inject Another Field into String inside delimiters without messing with the spaces
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am currently working on editing a workflow in xml format within another workflow and I need to Inject a string value within another string value in a certain spot...In this case from [target value] between >< in [Field_1].
I did it successfully with text to columns by splitting it then using a formula to combine everything but that did not keep my Field_1 integrity and took away my whitespaces.
I need to keep the trailing spaces and everything exactly the same but just changing the value between ><... is there a regex formula of some sort I can use or another formula that wont mess with the spaces and just inject it directly ?
Thanks
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Parse
- Regex
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use a formula tool to replace the digit or digit dash digit -- REGEX_Replace([Field1], "\d+\-\d+|\d+", [target])
The regex statement is saying find digits-digits OR Digits
Into the formula
Output of the formula
If this solved your issue, please be sure to mark it as a solution so other users can benefit! :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I may not exactly understand your question but you can use a regex parse tool to parse out the target value, then use the find and replace to replace value with your desired insert.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome this worked thanks