• v7.8.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
To Float (float)
NEXT
To Int (int)

Searching data / Building a query / Operations reference / Conversion group / To image (image)

Download as PDF

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:

ArgumentData typeMore 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
Download as PDF

PREVIOUS
To Float (float)
NEXT
To Int (int)

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.8.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport