I have this google sheets table with input in column A I need this output on the right.
But when trying this formula:
=ArrayFormula(REGEXEXTRACT(A2:A4, "(.+)[\""|\/]"))
This is what I came up with.
How to extract everything between "(*)", or "(*)/".
In other word if ended with " or /"
Thanks in advance.
>Solution :
try:
=INDEX(REGEXEXTRACT(A1:A3, """(.+?)(?:\/)?"""))
