Byte order mark

Wed, 14 Sep 2011 06:42:00 GMT

HELLO EVERYONE,

Below line puts BOM to text file, is there any way to skip while writing to a text file?

Store sampletable into C:\Qlikview\buildsql.txt (txt);

Thanks & Regards

Byte order mark

Thu, 29 Sep 2011 03:43:33 GMT

Hello Everyone,

I found a way to achive, read the text and search for the special character with ascii value and trim. Below is the script that i have used. Hope this might help other, Hence sharing

set FSO= createobject("Scripting.FilesystemObject")
set openReconFile=FSO.OpenTextFile("C:\Qlikview\buildsql.txt")
scriptBackup= openReconFile.ReadAll

openReconFile.Close

If (Len(Trim(scriptBackup)) > 0) Then
Dim AscValue : AscValue = Asc(Trim(scriptBackup))
If ((AscValue = -15441) Or (AscValue = 239)) Then
scriptBackup = Mid(Trim(scriptBackup),4) :
End If
End If

topic Byte order mark in QlikView

Byte order mark

Byte order mark