search() or find() for a "("

[lukerlGHE]

Hi,

how can i find or search a "(" in a column - to know how many charakters I have to take from the left.

It always sees it just as a second openind bracket but not as the value that I am actually looking for

Thanks in advance

[harshnathani]

Hi @lukerlGHE ,

Try something like this.

LEFT(Table[Value],SEARCH ("(", 'Table'[Value],, LEN('Table'[Value])))

If this does not work share sample data and expected output.

Regards,

Harsh Nathani

[amitchandak]

@lukerlGHE ,

check if this can help

https://jlsql.blog/2018/04/04/power-query-finding-the-nth-instance-of-a-letter-in-a-string-for-manip...

https://stackoverflow.com/questions/59684172/dax-power-bi-occurrences-of-character-in-string