replacing special characters based on ascii or hex equivalents

Highlighted
One Star

replacing special characters based on ascii or hex equivalents

I have an issue where i need to check character value based on ascii or hex equivalent & replace it with another ascii or hex equivalent.
Can somebody suggest a solution for me?
Moderator

Re: replacing special characters based on ascii or hex equivalents

Hi vguru,
I have an issue where i need to check character value based on ascii or hex equivalent & replace it with another ascii or hex equivalent.

Would you mind setting an example for your use case with input and expected output result?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: replacing special characters based on ascii or hex equivalents

I have a file with special characters that represent ASCII values 130, 133
Here is a sample string:
ISA?00?          ?00?          ?ZZ?T‚…
The output should be
ISA|00|          |00|          |ZZ|T (put CR and LF)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read