Multiline strings in Jupyter notebook

python-3.x jupyter

Use Python's triple quote notation to define a multi-line string:

x = """\Select * FROM OURDBNAME.dbo.vw_DimFoo"""print(x)

results in

Select * FROM OURDBNAME.dbo.vw_DimFoo

(The backslash "\" at the beginning suppresses a line break. To define a single-line string using several lines, add backslashes after each line.)

python-3.x jupyter

Using round brackets will allow you to split your string over multiple lines. If you do not use an operator, python will simply concate.

So quick example:

x = (  'Select * '  'FROM OURDBNAME.dbo.vw_DimFoo '  'WHERE <foo> ')print(x)

prints

Select * FROM OURDBNAME.dbo.vw_DimFoo WHERE <foo>

CodeHunter