Hex to String Problem Help

[umutcankurt]

Hello
I have a workflow where I clean up special characters and html code residues in the text. I wanted to clear some special characters with hex, but the hex return was worse.

Now, can you help me with a suggestion or a sample workflow by looking at the examples below?

Text : Text:
Execution of the Works of Traffic Lights in the Bridge in Prud Šamac on the Road M14.2. Execution of the works of traffic lights in the Bridge in Prud Šamac on the road M14.2. PUBLIC COMPANY ROAD FEDERATION BIH D.O.O. Country:-Bosnia and Herzegovina [Disclaimer : For Exact Organization Tendering Authority details, please refer the tender notice.] bmujezinovic@jpcfbih.ba Tender Notice International Competitive Bidding 260-1-3-267-3-411 23 Bosnia and Herzegovina GT-92325125

---

Hex :
457865637574696f6e206f662074686520576f726b73206f662054726166666963204c696768747320696e207468652042726964676520696e2050727564202020160616d6163206f6e2074686520526f6164204d31342e322e20457865637574696f6e206f662074686520776f726b73206f662074726166666963206c696768747320696e207468652042726964676520696e2050727564202020160616d6163206f6e2074686520726f6164204d31342e322e205055424c494320434f4d50414e5920524f41442046454445524154494f4e2042494820442e4f2e4f2e20436f756e7472793a2d426f736e696120616e64204865727a65676f76696e61205b446973636c61696d6572203a20466f72204578616374204f7267616e697a6174696f6e2054656e646572696e6720417574686f726974792064657461696c732c20706c65617365207265666572207468652074656e646572206e6f746963652e5d20626d756a657a696e6f766963406a7063666269682e62612054656e646572204e6f7469636520496e7465726e6174696f6e616c20436f6d70657469746976652042696464696e67203236302d312d332d3236372d332d34313120323320426f736e696120616e64204865727a65676f76696e612047542d3932333235313235

---

Hex to Text
Execution of the Works of Traffic Lights in the Bridge in Prud Ö2öâ F†R&öBÓBã"âW†V7WF–öâöb F†R v÷&·2öb G&ff–2Ɩv‡G2–â F†R’&–FvR–â 'VB
`amac on the road M14.2. PUBLIC COMPANY ROAD FEDERATION BIH D.O.O. Country:-Bosnia and Herzegovina [Disclaimer : For Exact Organization Tendering Authority details, please refer the tender notice.] bmujezinovic@jpcfbih.ba Tender Notice International Competitive Bidding 260-1-3-267-3-411 23 Bosnia and Herzegovina GT-92325125

Hex to Text ?

[AlexanderFillbrunn]

Hi,
Can you explain your cleaning logic a bit more? Maybe you could also use the Text Processing extension with the Diacritic Remover or simply a regexReplace in the String Manipulation node. Might be easier than the Hex transformation.
Kind regards,
Alexander

[mlauber71]

@umutcankurt maybe you can try and use R to do this (also other suggestions):

Hex to ASCII conversion

You could take a look at this example using R. [image]

A result would like this:

Execution of the Works of Traffic Lights in the Bridge in Prud Ö2öâFR&öBÓBã""âWV7WFöâöbFRv÷&·2öbG&ff2ÆvG2âFR’&FvRâ’VB`amac on the road M14.2. PUBLIC COMPANY ROAD FEDERATION BIH D.O.O. Country:-Bosnia and Herzegovina [Disclaimer : For Exact Organization Tendering Authority details, please refer the tender notice.] bmujezinovic@jpcfbih.ba Tender Notice International Competitive Bidding 260-1-3-267-3-411 23 Bosnia and Herzegovina GT-92325125

KNIME Forum (75403) - Hex to String conversion with R.knwf (86.5 KB)

[umutcankurt]

Hi; @AlexanderFillbrunn @mlauber71
Thank you for your answers. I tried clearing special characters with a simpler method.

It was an easier and more precise solution for me.

[mlauber71]

@umutcankurt that is great. Maybe you can post your example in a small workflow so other could also use it with ease