Special Character removal from the flat file

dataservices job design
1

Hi

I have a problem with a flat file.
I am loading the file’s data into the target table and the flat file contains a pound symbol (‘£’) for some of the columns.The target column is numeric.

BODI is not able to read this special character. It is throwing an error stating cannot convert pound symbol into decimal.Is there any way I can handle this in BODI? (It is reading it as a small square and throwing this problem.)

Please help me in this regard.

Regards,
Sree Lakshmi

sree1 (BOB member since 2010-02-04)

2

Hi,

You can remove that pound character from your string using DI string function.

data_guy :us: (BOB member since 2006-08-19)

3

Have you set a matching codepage at the file format?

Werner Daehn :de: (BOB member since 2004-12-17)

4

Thanks a lot for the reply.It is working fine now…I set the code page of the datastore to UTF - 8

sree1 (BOB member since 2010-02-04)