Data trans for mation using Regex_Replace formula

[RajatRehria]

Hi all,

Please help me if there is a way to get the desired output using Regex_Replace formula

Input: Investments, at fair value (cost of $12,123) $ 25,01,345

Desired Output: (cost of $12,123)

[Rags1982 · Accepted solution]

Hi @RajatRehria ,

Try this

Regex_Replace([field], '.*(\(.*\)).*','$1')