topic Re: How to remove spaces in qlikview script. in QlikView

How to remove spaces in qlikview script.

viveksingh — Sat, 16 Nov 2024 19:54:32 GMT

Hi Experts,

I have a qlikview script where I'm reading from QVS file. I'm getting spaces in script log. I want to remove the spaces which is appearing in script. Below is the screen shot.

Please help on the above

Re: How to remove spaces in qlikview script.

viveksingh — Mon, 14 Oct 2019 03:48:15 GMT

@rwunderlich Need your suggestion on this please.

Re: How to remove spaces in qlikview script.

rwunderlich — Mon, 14 Oct 2019 15:31:08 GMT

Those spaces are inserted by the logger to indicate you are in nested code.

If you want to remove those leading spaces when loading the log, use the Trim() function.

-Rob

Re: How to remove spaces in qlikview script.

viveksingh — Tue, 15 Oct 2019 01:57:24 GMT

Thanks for the reply.

I use trim function. Still getting the same.

Data after loading:

Re: How to remove spaces in qlikview script.

Ksrinivasan — Tue, 15 Oct 2019 02:48:23 GMT

hi,

can you attach your file to do test,

K. Srinivasan.

Re: How to remove spaces in qlikview script.

viveksingh — Tue, 15 Oct 2019 02:56:24 GMT

I'm unable to upload txt file. attched in zip format. please un zip and load

Re: How to remove spaces in qlikview script.

Ksrinivasan — Tue, 15 Oct 2019 05:58:51 GMT

hi,

before execute your LOAD, you can execute below Statement,

TRIM:
LOAD
@1,
@2,
@3,
@4
FROM [lib://TEST_CASE/Test log.log]
(txt, utf8, no labels, delimiter is spaces, msq);

Store TRIM into [lib://TEST_CASE/Viviksingh.txt] (txt);

then use Viviksingh.txt as source file of your Script,

i attached output in text format, it has no indented space in front of log lines,

K. Srinivasan.

Re: How to remove spaces in qlikview script.

viveksingh — Tue, 15 Oct 2019 06:11:55 GMT

Thanks for the reply. We should not change the input file as these are the logs generated by qlikview.

Please let me know if there is any other way.

Re: How to remove spaces in qlikview script.

Ksrinivasan — Tue, 15 Oct 2019 08:34:47 GMT

Hi,

Just you copy and past below Script as Given, just change your file path,

TEMP:
load
*,
Mid(YES_01,1,10) AS LOAD_DATA,
Mid(YES_01,11,8) AS LOAD_TIME,
Mid(YES_01,1,18) AS Date_Time,
Mid(YES_01,19,24) AS PID,
Mid(YES_01,25,100) AS Description,
LEFT(YES_01,10) as DTS;
LOAD
*,
DATE(LEFT(YES_01,10),'DD-MM-YYYY') as CHE;

LOAD
*,
Replace(YES,'','') as YES_01;

LOAD
*,
Replace(TEST,' ','') as YES;

LOAD [@1:n] as TEST

FROM
[C:\Users\Ksrinivasan\Desktop\Cali\Test log.QVS.log]
(fix, utf8, no labels);

Result Below:

K. Srinivasan.

Re: How to remove spaces in qlikview script.

atoz1158 — Tue, 15 Oct 2019 08:39:04 GMT

You could also try the following, note there is a funny non-space char at the beginning of the first line of your test log that is the reason for the PurgeChar()

RAWLOG:
NoConcatenate
LOAD PurgeChar(Trim([@1:n]),chr(65279)) as Log_Line
FROM [Test log.log]
(fix, utf8, no labels);

LOG:
NoConcatenate
LOAD
Left(Log_Line,10) as Load_Date,
Mid(Log_Line,12,8) as Load_Time,
Left(Log_Line,19) as Date_Time,
Mid(Log_Line,20,5) as PID,
Trim(Mid(Log_Line,25)) as Description
Resident RAWLOG;

DROP Table RAWLOG;

Regards

Adrian

Re: How to remove spaces in qlikview script.

asinha1991 — Tue, 15 Oct 2019 09:23:13 GMT

not sure if this is your issue, but there is something called non breaking space which doesn't get replaced by trim..it has ascii 160 , you can copy paste your text in some ascii online converter and see if you get this or simply try

trim(replace(yourfied,chr(160),''))

Re: How to remove spaces in qlikview script.

Luke69857 — Wed, 16 Oct 2019 10:07:25 GMT

Thanks for this, works for me. i am here to find such solution. Thanks again!

Re: How to remove spaces in qlikview script.

Ksrinivasan — Tue, 15 Oct 2019 18:33:45 GMT

Thanks to close.

K, Srinivasan