PurgeChar not working

Tue, 24 May 2011 15:56:29 GMT

I have an ID field that is a key field that shows up across several input tables. This ID, unfortunately, can have spaces in them. But, if you have a space in it, I can't seem to get the Select on that field to work correctly. So, I was thinking I wanted to purge all the spaces in the ID field in the load script. Unfortunately, I am getting an error: SQL###f - SqlState: S0002, ErrorCode: 173, ErrorMsg:[Microsoft][ODBC Visual FoxProDriver]File 'purgechar.prg' does not exist.

What's going wrong? Is there another way around this problem?

Say for example, one of the IDs that I am trying to select is 'AB 6766', and there are other records that start 'AB', it will select all of those records, instead of just the one that I told it.

Thanks in advance.

PurgeChar not working

danielrozental — Tue, 24 May 2011 15:59:38 GMT

Purgechar is a QlikView Function not a Foxpro one. You should use it in the LOAD part of your statement not in the SQL SELECT.

LOAD Purgechar(ID,'CHARS') AS ID

SQL SELECT ID

FROM TABLE;

Using purgechar after the SQL sentence will cause an error.

topic PurgeChar not working in QlikView

PurgeChar not working

PurgeChar not working