Handling special characters in a particular columns

[Former Member]

Hi all,

My requirement is I need to handle special characters in data.

For ex my data is coming like 'School Fees - ???' . I need to convert it to 'School Fees'.

I was doing hard coding till now but such data is coming frequently. So need a permanent solution for it.

Thanks,

Nakul Kothari

+919987039379

[former_member183463]

Hi

Nakul Kothari

check this link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0cdc928-5e2d-2e10-e1bb-ec77bcb5c...

regards

kamal

[former_member183463]

also check..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0afbb81-f219-2c10-4181-b20f6b10e...

[Former Member]

Hi Kamal,

I want to handle the special characters issue in HANA.

The links provided are for BI.

Please if you can help me in handling this issue in HANA.

[former_member182302]

Hi Nakul,

Why don't you want to handle the special characters before loading the data to HANA.?

What is the ETL tool you are using for loading into HANA?

Based on your input we can validate the data and load the clean data into HANA. It can be done easily using SAP BODS using Validation Transform.

If you still want to handle it in HANA, you may need to write a generic procedure in HANA and reload the data into the table or you may need to keep your "if" conditions as calculated columns in the models and remove them ( This makes more if's depending on possible special characters).

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

I am using SAP BODS as the ETL tool. Can u tell me how I can fix this issue in BODS itself.

Regards,

Nakul Kothari

[former_member182302]

Hi Nakul,

We can use "Validation Transform" in BODS to remove the special characters.

Depending on whether you want to "Fail" the record if there is special character or you just want to replace all the special characters you may decide on creating the error table.

Have a look on the below thread for the similar activity:

The below document covers most of the capabilities along with validation transform:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0e61192-b296-2b10-ca90-a21eea43f...

Also remember you need to define these rules for all the data types, i.e. char ( where ever you feel you want to control ).

I am actually documenting the similar results which i will be publishing on monday @SCN as i am currently traveling and do not have access to the system now.

Regards,

Krishna Tangudu

[rama_shankar3]

Krishna,

Thanks for the good how-to docs.

Rama