Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

filosofo
Contributor

Slash sign interpreted as end of field

Hi, I'm pulling data from a SQL server db via OLEDB. In one table some fields have a /-sign (slash) in it. Now i suspect that while getting the data into QV those field values are truncated at the slashes. Current statement is simply: SQL SELECT FROM blah.dbo.blah. Any advice? Thanks, Sander

1 Solution

Accepted Solutions
beristardj
New Contributor III

Re: Slash sign interpreted as end of field

One suggest is, in select sentence can use functions for SQL, in this case, you can be use function replace().

select a, b, c from table

select a, replace(b,'/','x') as b_r, c from table

This functions works for the execution run in Server, not in QV.

im wait this stuff works for you, regads.

Saludos desde Mexico

2 Replies
beristardj
New Contributor III

Re: Slash sign interpreted as end of field

One suggest is, in select sentence can use functions for SQL, in this case, you can be use function replace().

select a, b, c from table

select a, replace(b,'/','x') as b_r, c from table

This functions works for the execution run in Server, not in QV.

im wait this stuff works for you, regads.

Saludos desde Mexico

filosofo
Contributor

Re: Slash sign interpreted as end of field

Hi BeristarDJ, your tip to use the replace function helped me to 'restore' the value I need in this case. Still looking into a way to fully prevent the truncating at the slash in this setup. But fine for now. Regards, Sander