searching text for " symbol

[Anonymous]

I'm trying to write a dax formula that searches a product description text for the " symbol which indicates inches. My formula below doesn't work because powerbi is confused because " is used to call out text. Any ideas? Thanks!

Has " in text = if(find(""",<within_text>,1,0)>0,TRUE,FALSE)

[cheekysveta]

Just use """"

[Anonymous]

@Anonymous 

Agree with @Ajinkya369 , the easiest way is just replace " with other symbols. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous

Chekc this below link

https://www.youtube.com/watch?v=9sKeZbfzBTk

[Ajinkya369]

Hi @Anonymous ,

Please provide sample data.

Thank you

[Anonymous]

Here is a table to show for example. I want a formula to calculate the colum "Has " Symbol" ... Thanks!

Part Description	Has " Symbol
Part A 3"	TRUE
Part B	FALSE
Part C	FALSE
Part D 2.5"	TRUE

[FrankAT]

Hi @Anonymous 

you can do it with Power Query like this:

// Table
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkgsKlFwVDCOUVLSUQoJCnVVitWBijoBRdwcfYKRhJwVMMVcFIz0TJG0xwIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Part Description" = _t, #"Has "" Symbol" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Part Description", type text}, {"Has "" Symbol", type logical}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Has "" Symbol"}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Removed Columns", "Part Description", "Part Description - Copy"),
    #"Replaced Value" = Table.ReplaceValue(#"Duplicated Column","""","",Replacer.ReplaceText,{"Part Description - Copy"}),
    #"Added Custom" = Table.AddColumn(#"Replaced Value", "Has # Symbol", each if Text.Length([Part Description]) <> Text.Length([#"Part Description - Copy"]) then true else false),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Has # Symbol", type logical}})
in
    #"Changed Type1"

Regards FrankAT

[Ajinkya369 · Accepted solution]

Hey @Anonymous ,

Any of the Dax function for string matching wont work for this special character " ,you have two options either do it in the query editor by adding a conditional column or replace the special character " with ' 

If your problem is solved then please accept this as a solution

Thank you

[PaulDBrown]

@JHouse123

You can do this in Power Query by adding a conditional column (Conditional Column😞

to get:

[PaulDBrown]

@Anonymous 

You can try using the CONTAINSTRING function to identify the " 

[Anonymous]

Sorry, that gives the same issue