substring in big query

Question

the following substring doesnt work in big query:

substring(note.summary, charindex('[', note.summary)+1, charindex(']', note.summary) - charindex('[', note.summary) -1) as alpha ,

with the error function not found: charindex Would you be able to help me out? I'm so confused

Francisco Guiroy · Answer

you could try ->

select (split(note.summary, '['))[safe_ordinal(1)]

Let me know if this works, also you could check regexp_extract here ->