Workflow pulls in diamond with ? in text

[alishadhillon__]

Hi, 

I have workflow A pulling from an API that outputs to a database. I then have workflow B pulling the output of A as the input for B.

I noticed that I am seeing text where accents appear in the middle as a black diamond with a question mark inside. The output of the field is a v_wstring as is the input of the same field into workflow B. As it is coming from a database, and outputting to one, I'm unsure on how to change the code.

Any help would be appreciated.

Thanks.

[Luke_C]

Hi @alishadhillon__ 

You could try using this formula on the field in question: 

DecomposeUnicodeForMatch(String)

[alishadhillon__]

Hi @Luke_C 

Thanks for offering a solution. 

It has partially worked and taken away the diamond but now I'm left with a lot of question marks mid text. The character is not consistent enough for me to replace the question marks either.

[Luke_C]

Hi @alishadhillon__ 

Are you able to share an example of the text? Preferably with the original characters returned by the API?

[alishadhillon__]

Hi @Luke_C 

I managed to find the fix in the configuration of the API. Changing the download tool from UTF to ISO.

[Luke_C · Accepted solution]

Thanks, I see. 

This issue is probably sourced from the download tool itself. Have you tried playing with the encoding on the 'Basic' tab?

[alishadhillon__]

Thanks @Luke_C ! That did it!