Table Field with Strange Character

[eduardo_dimperio]

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

[eduardo_dimperio]

I create a workround, save in a qvd and not a csv, but I'll still looking for an answer.

[eduardo_dimperio · Accepted solution]

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);