Special Characters getting replaced in Output tool

[viral_gada]

Hi,

I have a below issue with special characters.

Ex1: Input - £100 fixed rate

Output - #100 fixed rate.

The pound sign replaces with # in output

Ex2: Input - Children’s Hospital

Output - Children?s Hospital

The ' sign is getting replaced with ? in output.

Can someone please guide me here. Thanks in advance !

[ShankerV]

hi @viral_gada 

Are you trying to save in the .CSV format to save?

If yes, you need to change the below setting in configuration window.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[viral_gada]

Thank you @ShankerV

I am trying to save in *.xlsx instead of .csv

Is it possible ?

[ShankerV]

Hi @viral_gada 

Yes, you can save in any format you needed.

The below setting will help to save the output in .xlsx. Please let me know if the special characters are truncated in .xlsx format also.

Many thanks

Shanker V

[viral_gada]

Hi @ShankerV,

Yes, I am facing this issue in .xlsx format.

[ShankerV]

Hi @viral_gada 

Can you please share the output tool settings as screenshot.

Or attach the workflow if possible please. will be easy to fix the issue.

Many thanks

Shanker V

[viral_gada]

Hi @ShankerV ,

I tried in .csv format but still data gets truncated.

Below is the screenshot of output tool settings window.

[viral_gada · Accepted solution]

Finally, I got the solution.

The Force SQL WChar Support should be ticked.

Sharing the screenshot below for reference.