Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm saving a file in txt format, but when a load this file, the field name is broke. I think that have some relation with UTF-8 encode, but I don't know how to store properly this
If($(vError_code)<>0) then
Let MyMessage ='$(vDetail)';
Log:
LOAD
'$(vApp_Id)' as [App_Name]
,'$(vStep)' as [Step]
,'$(MyMessage)' as [Message]
AutoGenerate 1;
STORE Log INTO [lib://Dados/LightP&D/cas_br_cuc/Log/Log_$(vDataCarga).txt](txt);
Drop Table Log;
Load * from [lib://Dados/LightP&D/cas_br_cuc/Log/Log_$(vDataCarga).txt](txt);
PS: I read about and I believe that my problem is the BOM, but still don't know how to remove that
Finally I found a way. I 'll keep this post if someone have the same problem that I.
LOAD
App_Name,
"Step",
Message
FROM [lib://Dados/Light P&D/cas_br_cuc/Log/Log_20191210.csv]
(txt, utf8, embedded labels, delimiter is ',', no quotes);
I create a workround, save in a qvd and not a csv, but I'll still looking for an answer.
Finally I found a way. I 'll keep this post if someone have the same problem that I.
LOAD
App_Name,
"Step",
Message
FROM [lib://Dados/Light P&D/cas_br_cuc/Log/Log_20191210.csv]
(txt, utf8, embedded labels, delimiter is ',', no quotes);