Material

Material = '{Material}'

Select the row having material equal to the material attribute of the current element.

Notice that value of the attribute Material is referenced using the composite format string and is enclosed in quotes, as it is a String.

Component = '{Material}'

As the string contains a single quote it is doubled: ending with a single quote " ' "

Note

To escape single quote in composite format string ALWAYS use the escape character \ (backslash)

The last example [Material = '{Material}' + 'ending with quote '''] can be written using a composite format string expression placeholder (reference the section ... composite format string)

Material = format('{0}ending with quote\'';Material)

Notice that as the string containing the single quote is inside the placeholder and therefore the SFHub syntax is applied and escaped, a single quote is used (backslash + ')

Always refer to SFHub syntax when using composite format string placeholders.