Regex (replace)

Question

I would like to use regex to identify all rows that contain BRA (including the registers w/ numbers) - I used the expression: ^BRA*

I would like to replace all BRA derivations (including the registers w/ numbers) w/ only BRA. However it is not working.

Could you help me?

FilipR · Accepted Answer

Maybe I misunderstand your intent, but if you already identify the rows with BRA something, and want just to leave the "BRA" letters instead of the whole string, then why not do it through an easy formula:

IF Contains([Name], "BRA") THEN 'BRA' ELSE Null() ENDIF

OR:

IF REGEX_CountMatches([Name], 'BRA') THEN 'BRA' ELSE Null() ENDIF

MarqueeCrew · Accepted Answer

@vcorrei5 ,

i like your first function (contains) ,   But if BRA is always at the beginning @FilipR , you can use:

left([field],3) = "BRA"

or

startswith([field],"BRA")

as part of an IIF EXPRESSION

IIF(left([field],3) = "BRA","BRA",[field])

cheers,

mark