How to remove ? from file

[abhay_aggarwal]

Hi All,

I am using fileConetnt Conversion at receiver side.

When getting data <POS_TXT>Manager u2013 Development</POS_TXT> in field this - is getting converted into ? sign in file .

to elminate this Do I need to use replaceByValue Fuction.

or Is there any alternative to handle this charecters?

Regards

[stefan_grube]

> in field this - is getting converted into ? sign in file .

This seems to be a code page issue.

Assign the correct code page to channel

[abhay_aggarwal]

Hi Stefan,

I changed the encoding to UTF-8 .When I am opening the CSV file with notepad it is working but when I opening this wid excel -

is converting into ? only.

I have used replace by string also but it did'nt work for me

Plz help me.

Regards

[Former Member]

Hi

Try changing the receiver channel Processing parameter File type to "Text".

Regards

Ramg

[stefan_grube]

which codepage does the file have originally?

[Former Member]

HI Abhay,

If your problem is that : in SXMB_MONI when you are checking the payload then "- " symbol is there but after content conversion when it is getting posted at target destination then - is being converted to ? .

if this is the problem then I dont think it will be removed by replace function .you have to use proper encoding in reciver adapter

just make the file type as text and use the encoding as UTF-8 or ISO-8859

However if in source it is coming as - and you want to replace it to ? or vice- versa then it can be done by replace function .

Regards,

Saurabh

[prasanna_shanmugasundaram]

you need not use replace by value function. You have to check your file content conversion parameters.

Post in detail about your file content conversion.