Way to Inject Another Field into String inside delimiters without messing with the spaces

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 XML Editing ex.png

Workflow

Regex

Parse

Dynamic Processing

Accepted answers

CarliE

@Carlos_Tovar

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!

All comments

CarliE

@Carlos_Tovar

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!

braveraj

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.

Carlos_Tovar

Awesome this worked thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703