Regex or method to complete data in a field

Hi,

I'm pulling data from a file where there is a field with server names. In some cases, the value input represents more than one server. It's input like this - XXXAP1(T, R, AND Q). I want to turn this into XXXAP1T, XXXAP1R, XXXAP1Q. Is there a simple way to do with Regex?

Thanks.

Regex

Accepted answers

gautiergodard

Hey @TimN

Here is one way you could do this:

parse.yxmd

WesCannon

Hi @TimN

It will take more than one Regex tool but it's definitely possible with a few tools. I've attached an example workflow that may be helpful.

Thanks,

Wes

Server Name Parse.yxmd

ShankerV

Hi @TimN

Yes, its possible with Regex tool.

Please let me know if you have more questions related to the same,

Regex or method.yxmd

All comments

gautiergodard

Hey @TimN

Here is one way you could do this:

parse.yxmd

WesCannon

Hi @TimN

It will take more than one Regex tool but it's definitely possible with a few tools. I've attached an example workflow that may be helpful.

Thanks,

Wes

Server Name Parse.yxmd

braveraj

Hey @TimN

It might need more testing but I've got a solution. Parse out the variables in parentheses, then split to rows the single variables. Append and then bam you're done.