topic Re: spaces in database need to be loaded with spaces or a value in qlikview in QlikView https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198444#M386278 <HTML><HEAD></HEAD><BODY><P>Thank you so much</P></BODY></HTML> Sat, 15 Oct 2016 13:19:11 GMT 2016-10-15T13:19:11Z spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198439#M386273 <HTML><HEAD></HEAD><BODY><P>I have unstructured data in database, where i have spaces in the data</P><P></P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/140699_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P><IMG class="jive-image image-4" src="https://community.qlik.com/legacyfs/online/140702_pastedImage_4.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>when i'm loading data into qlikview, i'm getting data as below</P><P></P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/140701_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>I need a number or space in qlikview as well when i load data from DB</P><P></P><P>Pleas help me out</P><P></P><P></P><P>Regards</P><P>John</P></BODY></HTML> Fri, 14 Oct 2016 21:14:57 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198439#M386273 2016-10-14T21:14:57Z Re: spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198440#M386274 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/SystemVariables/Verbatim.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/SystemVariables/Verbatim.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/SystemVariables/Verbatim.htm</A></P></BODY></HTML> Fri, 14 Oct 2016 21:20:06 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198440#M386274 sunny_talwar 2016-10-14T21:20:06Z Re: spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198441#M386275 <HTML><HEAD></HEAD><BODY><P>and here you can see it in action:</P><P></P><P><A href="https://www.youtube.com/watch?v=jTeRL4MH0Io" title="https://www.youtube.com/watch?v=jTeRL4MH0Io">Qlikview SET Verbatim = 1 by RFB 184 - YouTube</A></P><P></P><P>hope this helps</P></BODY></HTML> Fri, 14 Oct 2016 21:22:49 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198441#M386275 Frank_Hartmann 2016-10-14T21:22:49Z Re: spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198442#M386276 <HTML><HEAD></HEAD><BODY><P>Thank you so much Frank its working fine and saved my day</P></BODY></HTML> Sat, 15 Oct 2016 13:16:31 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198442#M386276 2016-10-15T13:16:31Z Re: spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198443#M386277 <HTML><HEAD></HEAD><BODY><P>Thank you so much Sunny, its working fine and saved my day</P></BODY></HTML> Sat, 15 Oct 2016 13:16:44 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198443#M386277 2016-10-15T13:16:44Z Re: spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198444#M386278 <HTML><HEAD></HEAD><BODY><P>Thank you so much</P></BODY></HTML> Sat, 15 Oct 2016 13:19:11 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198444#M386278 2016-10-15T13:19:11Z Re: spaces in database need to be loaded with spaces or a value in qlikview https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198445#M386279 <HTML><HEAD></HEAD><BODY><P>No problem <A href="https://community.qlik.com/people/john_cen">john_cen</A>‌!! We are glad that we were able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 15 Oct 2016 13:26:12 GMT https://community.qlik.com/t5/QlikView/spaces-in-database-need-to-be-loaded-with-spaces-or-a-value-in/m-p/1198445#M386279 sunny_talwar 2016-10-15T13:26:12Z