Hi Paul Brett,

Thanks in advance.

"How to remove the Trademark (™) symbol from an Input Text item 'Native' of a file to an Output Text item 'Native'"

--> SUBTITUTE (Input,SYMBOL(153),"") - Did not return the expected result

--> There is a scenario to get Extended ASCII characters like , whereas LEAVEPRINT removed all the Extended ASCII characters 

Text - "LYNAE KU€™UIPO"

When we use UTF-8 at both the sides then the text is returned as "LYNAE KU€UIPO"

Please advise.

------------------------------
Suriya Prakash
------------------------------

Hi there, 
I'm not Paul Brett but I think I can be of service.  Your problem is greater than the (tm) symbol - those 3 characters together are actually a ' (single quote) decoded as CP-1252.  I am not sure what all your business requirements are in this scenario however using =CTEXT(testIn, "US-ASCII") removes the 3 extended characters altogether.  Without going through all the possible encodings to guess what your systems might need to decode this properly back to the single quote I believe the name should be LYNAE KU'UIPO (looks/sounds Hawaiian or Polynesian). The root cause of this may be the data source not encoding the symbols properly.  If you'd like to manually decode this is what I did (ISO-8859-1: is the new "Latin1" which is what the char set seems to be - others can be used)
=SUBSTITUTE(CTEXT(testIn, "ISO-8859-1"), SYMBOL(194) + SYMBOL(128) +SYMBOL(153), "'")
results in "LYNAE KU'UIPO".

I will leave you with a few resources to help you understand the problem and hopefully point you to a solution. 

This give you a great background on the symbols and how it may be rooted to a database encoding issue...

https://stackoverflow.com/questions/2477452/%C3%A2%E2%82%AC-showing-on-page-instead-of

Here are the different character set values for using the CTEXT and associated function in ITX - depending on the source of the data you should pick the character set to use to get back to the single quote that was (more likely than not) intended:

https://www.ibm.com/docs/en/ste/10.1?topic=expressions-character-set-codes-cpackage-cseriestotext-ctext

Best of luck decoding!

------------------------------
Lisa Edwards
Software Engineer / Subject Matter Expert
Rainbow Data Systems, Inc

Original Message:
Sent: Fri April 07, 2023 06:59 AM
From: Suriya Prakash
Subject: How to remove ™ from an text in ITXA

Hi Paul Brett,

Thanks in advance.

"How to remove the Trademark (™) symbol from an Input Text item 'Native' of a file to an Output Text item 'Native'"

--> SUBTITUTE (Input,SYMBOL(153),"") - Did not return the expected result

--> There is a scenario to get Extended ASCII characters like , whereas LEAVEPRINT removed all the Extended ASCII characters 

Text - "LYNAE KU€™UIPO"

When we use UTF-8 at both the sides then the text is returned as "LYNAE KU€UIPO"

Please advise.

------------------------------
Suriya Prakash
------------------------------