CODEWITHSUNDEEP
regexgoogle-sheetsgoogle-sheets-formularegexp-replace
user15169505
user15169505

Reputation:

Using REGEXREPLACE to Populate the Data from Cell

I have been using below formula which is working fine but i want to add one condition that is if data cell and the formula output result is same then it should add some comments with brackets as i did in Col"C".

Any help towards the problem will be appreciated.

=ArrayFormula(TRIM(REGEXREPLACE(A2:A,"(\*{3}.*?)(?:\s*?\.{3}DONE=>.*)?(\*{3})$","$1 $2")))

enter image description here

Link to Sheet

Upvotes: 2

Views: 78

Answers (1)

Wiktor Stribiżew
Wiktor Stribiżew

Reputation: 627419

You can add the following formula to Column C:

=ARRAYFORMULA(IF(A2:A9=B2:B9, REGEXREPLACE(A2:A9, "(\*+)$", "(No Measure Applicable) $1"), B2:B9))

This replaces the trailing one or more asterisks with (No Measure Applicable) + space + the asterisks captured into Group 1.

Upvotes: 1

Related Questions