Cleaning data of special characters

More
11 years 8 months ago #4411 by bernd
Hello

I have a flat file and the fields are like below

****%%^^@@@V**@#A@#$N*&^D%^A@#h@@@##$$

In this format.

Means unlimited special character between and sides of the string data..output should be(VANDA)

Please anybody tell me how can get the name in required format.

Thanks in Advance.

Regards,
Bern

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #4412 by admin
Bernd

You can use delete characters function.

Easy

See attached pictures

Peter

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.