Power Query Editor - occurs in the text character write yes

[skopcak]

It is there in the text to find out when it occurs, for example, a character "[" , so that the new row was yes?

Column 1	Column 2 - result
dsagasgasgas]	yes
asfasfgasgas yx	no
fasfasfas	no
asfas]]]]	yes

Thank you answer

[Sean · Accepted solution]

Hi @skopcak

You can do this very easily using the Query Editor to add a Conditional Column

Just go to the Add Column tab and click the Condtional Column button...

Hope this helps!

[Sean · Accepted solution]

Hi @skopcak

You can do this very easily using the Query Editor to add a Conditional Column

Just go to the Add Column tab and click the Condtional Column button...

Hope this helps!

[skopcak]

 Thank you

[MarcelBeug · Accepted solution]

Similar, with background music.