Special characters in input Feed

[Former Member]

Hi ,

Appreciate if you could help me to resolve the following scenario.

My input file(flat file) contains records with special characters. It is required to seggregate these records from the normal records and write to  a seperate file.The target for my normal record is xml file. Records with special characters can be written to a flat file.  Please let me know if any work around is there.

Thanks

[kamal264]

As  Arun suggested  you can use replace_substr() and

If you have so many special character you use search_replace() with substr

and you can refer this blog also

http://scn.sap.com/community/data-services/blog/2013/02/03/remove-special-character-in-data-service-...

and you can use this code also in UDT

re.sub("[^ 0-9a-zA-Z]","","INPUT FIELD")

Regards,

Kamal

[Former Member]

What kind of characters? Example please.

Arun

[Former Member]

Hi Arun, 

Please find the character after N. 'MANÆS'

[Former Member]

You have to use a replace_substr() function to remove the characters.

Arun