Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Export field contents to text file

Participant ,
Feb 11, 2023 Feb 11, 2023

Hi
I wonder if someone could please help me solve this problem
I have 4 fields
this.getField("LAST NAME").value; The text is YYYY
this.getField("NAME").value; The text is BBBB
this.getField("PRICE").value; The text is 10000
this.getField("TEXT").value;

In the TEXT field I inserted this function in the custom calculation script:

var s1=this.getField("LAST NAME").value;
var s2=this.getField("NAME").value;
var s3=this.getField("PRICE").value;
event.value=s1+" "+s2+" "+util.printf("€ "+"%,2.2f",s3);

In the TEXT field it appears:
YYYY BBBB € 10,000.00
Then I inserted this function in a button script to export the text contained in the TEXT field into a .txt file
var fields ="TEXT";
var endarray = [];
for(i=0 ; i <= fields.length -1 ; i++)
{console.println(fields);
arrayvalue = this.getField(fields).value.toString();
endarray = arrayvalue;
console.println(arrayvalue);
console.println("i-value: " + i);}
console.println(endarray);
var namestring = endarray[3] + " " + endarray[2] + " " + endarray[1];
console.println(namestring);
this.createDataObject({cName: "REPORT.txt", cValue: endarray});
this.exportDataObject({cName: "REPORT.txt", nLaunch: 1});

In the txt file the euro symbol € disappears

can anyone help me to solve this problem?
Thank you

TOPICS
JavaScript
373
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 11, 2023 Feb 11, 2023
LATEST

Instead of setting the value directly in createDataObject, try using the setDataObjectContents method.

That will allow you to encode the string as "utf-8". See the examples given under that method in the API Reference.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines