Regex Parse on multiple columns

[archanacg1]

In the attached i would like to parse/search for the strings 'APPLE|DELL|HP' on multiple columns like Summary, Description, technical summary and final attribute Computer should be populated with the values.

Currently i can only parse only on one column.

[ChrisTX]

Use the Transpose tool to convert the column values to Name and Value  (convert from columns to rows)

Then a Filter tool to select only the records you want

Then a Crosstab tool to convert from rows back into columns

Chris

[archanacg1]

ANy sample job please

[Robin_McIntosh]

Here's an example.  This is using REGEX_Match within a formula.  I added some non-match examples to the input so you can see it only results in those that match HP, DELL, or Apple.

[archanacg1]

Thank you. I dont want to filter the records. I just want to extract the keywords and populate in a new column like this.

[Robin_McIntosh · Accepted solution]

Updated.

[flying008]

Hi, @archanacg1 

Maybe you like this way: (If you only need parse 3 columns, you can use formula to manual CONCATENATE string then parse it.)

1- Manual method:

2- Dynamic method: