Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
filosofo
Creator
Creator

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
Contributor III
Contributor III

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

View solution in original post

2 Replies
beristardj
Contributor III
Contributor III

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

View solution in original post

filosofo
Creator
Creator
Author

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