To image (image)
Description
Converts a Base64 string into an image.
How does it work in the search window?
Select Create column in the search window toolbar, then select the To image operation. You need to specify one argument:
| Argument | Data type | More Info |
|---|---|---|
| String to convert (mandatory) | string | The string values specified must always be preceded by the pattern → extension;base64;string (where extension is a file format such png or jpg, base64 is a fixed expression and string is the code of the image). An example would be → png;base64;4AAQskZg... If you have a picture and want to know the code, you can use an encoder such as the one you can find in the following link. Be aware that in some encoders the pattern preceding the code might not be exactly the same as the required by Devo so you need to make sure it coincides. Be aware that there is a limited size for the picture, ideally designed for company logos. |
The data type of the values in the new column is image.
Example
We have this base64 string and we want to display the corresponding image in our data table. To do it, click Create column and select the To Image operation. The arguments needed are:
- String to convert - png;base64;code_of_the_image
Click Create column and you will see the following result:
How does it work in LINQ?
Use the operator select... as... and add the operation syntax to create the new column. This is the syntax of the To image operation:
image(base64_string)
Example
You can copy the following LINQ script and try the above example on the demo.ecommerce.data table.
from demo.ecommerce.data
select image("png;base64;iVBORw0KGgoAAAANSUhEUgAAAMgAAABWCAIAAAAFVk76AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAArQSURBVHhe7dsPTJNnHgfwdzKHivjv2E6z15rA9KjDWcYCjRMImd1UOg6K5pCxYLPcwH8lXoRpgLuchYtp5Vy5nKJTKwmC8Wx3B2VBamKsmSlEdnVy1gsHuWHNoXaA16l7p+i95X2079u+bd/aPgi53yck/J7XtuTl/fL8e19fevLkCQFApE1D3wGIKAgWwAKCBbCAYAEsIFgACwgWwAKCBbCAYAEsIFgACwgWwAKCBbAQeq9QLBajCvx/s9vtqAoIeiyABQQLYAHBAlhAsAAWECyABQQLYAHBAlhAsAAWECyABQQLYAHBAlhAsAAWECyABQQLYAHBAlhAsAAWECyAxWR5gjQxMXHPnj1RUVH79u3r7e1FRwli48fO7LzhGTMfP/zpJXTIx/RXnly2zj72p4Ujwy+jQyApQ74qMzNhDtOihv5+4ZLF3OVgmuEQ+ATpZAlWe3t7fHw8XTgcDplMxhxc+8uRzaW3mDqoXltMzZ7FqBFUkb67UhqLGvwol9Nx7YLhUIM+0PWoMdnzE1AdnPN8efpWE7FSaz4lJ9Ex+qilKr3EgBoB5B++WJMRhxr0r8pUICu/ghqISKrcVlaYLiHnowMcLqe968xxrc40iA48h6n0aPKKFSuYVNFIkkxJSWHqt96+xxRCJEnuzZ03hhpBRaHvAUTHxiWk5VecMHe3aguT0MEwRc961f3tisHGvrRxaRtUnpj5Q+7+KM2TKoIYtBk4qSLlu/XmVn1Fjp9U0WLjxGtKtV91G3/LijUekyJYV69ebWtrY+qOjo6enh6mbjcuYAoh2s4suDsqIC+hi10qrz51sWVXBmpHgFXXbqNQTYuWZJdJUe2PtCxLHI1qGmVr11lRTROXnmjRFktJ1iv8iooVb9Iav6yO4Pn4mkT/S6e4uHjatGl6vR61xy1NfPDe+lG/06unrv9j1vmzc1FDiGJ99+4gQ6EPqt+okldaUAsJcSg8V56+wzReeo1rTktleokRNXgoDl+s5bycNXqSyhPGirQQz4Y+nwGDKrvK63yCmmJzrInGDZajo1x3HtXj5iS8K5OlSxO8xxSXdb9CeSwCU2AaWWk0F3l+q9R1vTxP4+ejyYovTcpET3dkb5IpatFrM2pN9YoEr66KGrJ3netsu3qtv3Vg7lqJJOX9tFVSabx3+FxdGsVmfUjnA8EKiBusfqNYXolqFnrWov6sQBrHvmiUXZ+j0IQx+WUpbekpk8xCDfdk/BNZ+SXU4FilNR9jzYru23QpmxqYOqvefFDGmTBRDvN+laqJ5/KLFTW1u/PFnHSF/KfygoOVnJycmZmJGpFDUVRzc/Pdu3dRmyCmT3+yLnd45qzHqP3Utz0x9l7PRfMmKFhuZLa2oVbO7hCoHp2kCF3WMGUcMB9eG3x16L0a7CiR7WRGMO+ejBix6j5VNni2a3yIlIcbyzIWst5y01yyRiV8QHzBwRL445/DjRs3ioqKbt++TdfR0Y/3/vG7JfGseTDL4c8X+Z14CQ4WjVS1mLZIPJdizN68XqGOSKclqjZ+VSh+tuTg7Q69XsP+6V49GeEwb5WpOGM6H1GFsVXJWghQtnrJpkOoEZTAKzv1dt4XL16sVCqZOlsx4i9VtILiO6gKj6NeZxpAtVuUOEMVbA0n0KD65NdOVNOixTKfT5aqMjyponu1r08+y7R0o4Q9CDotDcFTRRvUaNr7Ue0WLX63FJWRMyVv6fT19THFjX+/whS8/vXPGagKl7XqIufPlEzwLNXFWXJ5TvAvWRpnIvSModHKnuCQacp8VDLylZw3OqyNnrFSnuD3nwKzVppt91FNi16SLEdlxOAaChsaGnDMsWhHjhw5cOAAahBEXsH3v+Lrmb79JuZg3aJRfzd5QhkK3URa81nWoDNiVa9SNrsrwdsNTkt5egmz0+CltMlWluIZmdgrPu+VI2d6p9R3V3jOwf/n86pptecvRTU9vOqTFBrUCOLFrwrnzZuHqsgZGxtzuVyo8dSMmY9fnu59Fj/8N+BmaajBIspaeko9KziXVZOqHN9wExwsz1t8eO1RDZqUH5SPb35KtWf1ctH4QTevvS5usAYM4uwqVAugPNHN2vrqN4jlAt/84udYoxj4por244NpdIy8vtC/TQlGded1VLqJpErFeFFckulJFUFc71QH2EGdZCZ0jsXbh82eM4bjC316pIjIOPbexSPC75LBnxGn/790h7qTfYcnLuPjapIgq3M9/ZG7x/urOtB2U/SckBYUr85lfTYGE7dBqlarN2zY0NTUVFtbyxyJe+3hlt/8582VrGlk5LjnWPsXjY5EaI6122gvZv0G+gziHGbo4AyFVK9evtHf7nlgXqOew1Rpk9SyZnWe8fEZUnvW7HlLaJsg3GHUM2UMbnJtN+zYsYNOFV0UFRU92yz4tGwIU6pob71979eqIdQIF1mdxvm7cvTzz5J/unfnuVJFs+os7AtGyveyN6go+3n2LWeG40I/a6silE0QUvV+MrvDumUXmCrhJihYy5cvRxVBLFu2jCneSHzAFJi88YsfURUe8hP1h4moHuew/cXnKofNUXvSwsoJ58EeZ9fJfTyJNZ27xn4Huaaigj0n80ekVBew9nvpTqhL4IowBBMUrEOH0M7u8PDw0aNHmfqUfvzhJGxONUbi87Oq60vYcx2CumLS8d7RC5fB3xOF/RY9/w6VUW9lj33R4sIv6guDZCuj5lCZlH1z3WVt24fKCJq4OZZIJMrNzT19+vTQkGeESlp5/01JCE/zCReRe4Xiovr6XTLOQ05Uv2GnvMqzwc2ZY7m6NKmb+bcUhPG6LT2OfcvZF/dEaNSQtXl/taadL6NJhfV1FTIR53zsjXIFX3foz4vfx5rUAgZLnCVPlmTK1mT6PGfi+0hWpCbviNf9ZhrrljMv3oexKGev5czfznQ2MRM3UroxPz9blvlOQix3H4bqM5TmVIU0rkOwAvL5QxeAcp7Xbdrq9fSS4A3ScY6OctnOgNvjAW45+5VR016fH8/uh4QZsWoKlHqhC0lkcq0Kn8O2bdsa+aSmpqJXjIt77WFxya13pD+gNi4ue0uVT6pCNnd+sGnfIGdLi33L2T9L1ZYqU19oO2vUkOU5UiXcJA1WXV3d9u3b6Qz5orO1evVq5mXzFjz6fd1363JHdv3O8d66UeZgxFE3rfpdCsVeU5ipEqjhoPnpDxJ8X3nQVJ6zSd3a7xK0MUw5uvSqrBJ8qaJNxmCRJLl+/XrU4JOXl8cUH3w48rO4R0ydW/A9Uwgi5AKMuZx9VsN+pXyNkn8u/BzGBPQrl3Tm6+6XUT0G/gdK+dmbP5OnFqgNXf7jNUbPvUyazXLZZk2oj7qHapLOsS5fvhwTE4MaPlQqldlsposVyfcq/3CDOWg2zT/2558ztQCkdK0kzv9DN9Qtm8D/3knP9BOETtYop83M2SDwJ6tavzN+4IBSLeT5Kh702cllWQnk6+LX59A/9s7AwM3+q51P5/JhmdqT9yVLllRWVqanp6M2y/Hjx7VaLWoQBD0CbvjI+U337C/qF6JDACdYFQIspvyqEExpECyABQQLYAHBAlhAsAAWECyABQQLYAHBAlhAsAAWECyABQQLYAHBAlhAsAAWECyABQQLYAHBAlgIfdAPgJBAjwWwgGABLCBYAAsIFsACggWwgGABLCBYAAsIFsACggWwgGABLCBYAAOC+B8Z8t8O5pV1lgAAAABJRU5ErkJggg==") as usrcol1