Forum Discussion

Henchway's avatar
Henchway
Contributor
4 years ago

Elegant way for String interpolation

Hello, I’m wondering if there is any elegant way in the Snaplogic Expression Language to achieve String interpolation? E.g. similar to f-strings in Python? f"This is a test string including a {v...
expression_language
j_angelevski's avatar
j_angelevski
Contributor III
4 years ago

Hi @Henchway,

You can also use the built-in function .sprintf().
For example, you could use the following expression:

"SELECT %s,%s,Id FROM Opportunity WHERE %s =\'%s\'".sprintf("one", "two", "someId", "123")

Which translates to:

SELECT one,two,Id FROM Opportunity WHERE someId ='123'