Regex or method to complete data in a field

[TimN]

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.

[gautiergodard · Accepted solution]

Hey @TimN 

Here is one way you could do this:

[WesCannon · Accepted solution]

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

[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.

[Felipe_Ribeir0]

Hi @TimN 

Not the prettiest solution, but it works and avoid regex, so it is probably more performatic.

[ShankerV · Accepted solution]

Hi @TimN 

Yes, its possible with Regex tool.

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

[TimN]

Thanks, all!  Appreciate the quick replies.

[TimN]

Hi,

All these approaches work.  Not sure if I can accept them all as solutions but they all do the job.

Thanks Again.