Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
3 years ago

Fields are auto appended at the end

Hi Good day, I am stuck at an issue where I happened to find there is an extra string getting appended at the end of the field name. We are filtering the Japanese field name based on certain condit...
darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago

I’ve worked on flat files having foreign characters (like japanese, chinese, korean) and while using CSV UTF-8 formatting, it worked for me.
For user case, if you’re seeing any characters getting appended, I would recommend converting your excel into a CSV with UTF-8 encoding and then go ahead with the transformations.

You can always change the format of file as per the desired output in the end using formatter snap.

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    3 years ago

    @Harsha3: I assumed you shared the input data with me and all I did was converted that into CSV UTF-8 encoding style. Using the csv as an input file, here is what I see in my csv parser:

    I believe, the extra characters are not coming in anymore, please test it out with all your 140 fields and use this alternative. The other notable difference is that when you use excel file as an inputData, not all fields are visible in the parser.

    Please keep me posted with your findings.

    BR,
    Darsh