Alteryx String Conversion

Question

Hi All,

Could some one let me know how to convert below string?

Input String:

(((Type1 = "TEST") AND (Code1 in "X, Y, Z")) OR ((Type1 = "TEST") AND (Code2 in "A, B, C")))

Output String:

(((Type1 = "TEST") AND (Code1 in ("X", "Y", "Z"))) OR ((Type1 = "TEST") AND (Code2 in ("A", "B", "C"))))

Thanks,

Mark

ArtApa · Answer

Hi @mark_paul - You can simply use a Replace functions:

* REGEX_Replace([Input String], '("\w, \w, \w")', '$'+'$1'+'$')
* Replace([Output String], ',', '","')

StringAA.yxmd

DataNath · Answer

Not sure if it's totally ridiculous or if something like this may work:

At the minute, the capture groups are all just set to \w{1} i.e. single letters, as they appear in your example. Can be changed easily if real inputs will be different. Workbook attached.

Regex replace dynamic letters.yxmd

mark_paul · Answer

@DataNath , Need to be dynamic

Thanks

Marks