ETL and Data Integration tools - Modern ETL software for everyone

Hello.

I have an excel file with some special characters.
I would like to replace them with spaces.
Is it possibel to do it using replace function?
Or shall I use calculation?

John

Hello.

What you need to do is use EscapeString ETL Transformation Function

It will convert your special characters into something like \n\l

line1
line2
to
line1\n\lline2

Than you can use Replace function to get rid of \n\l

and if necessary UnEscapeString ETL Transformation Function

for example if you wish to keep the TABS

Hope That helps
Pete