topic 'u00A3' in file in Application Development and Automation Discussions

'u00A3' in file

Former Member — Wed, 26 Nov 2008 16:25:43 GMT

Hello experts,

i have pound sign in my file.have to update the database table.

to open file iam using:

OPEN DATASET p_ifile FOR INPUT IN TEXT MODE ENCODING UTF-8 IGNORING CONVERSION ERRORS .

Its uploading into internal table but instead of £ sign its updating # into the table.

Having said that when I use

OPEN DATASET p_ifile FOR INPUT IN TEXT MODE .

its throwing me a bug .

if i use

OPEN DATASET p_ifile FOR INPUT IN TEXT MODE ENCODING default.

program dumps when reading the data from file.

plz advise.

Re: 'u00A3' in file

BH2408 — Wed, 26 Nov 2008 16:28:58 GMT

Hi ,

It is considering the pond sym as the tab space in the internal table.

Regards,

bharani

Re: 'u00A3' in file

Former Member — Wed, 26 Nov 2008 16:34:33 GMT

OPEN DATASET p_ifile FOR INPUT IN TEXT MODE .

its throwing me a bug .why?

when its ok in other programs.

Re: 'u00A3' in file

Former Member — Wed, 26 Nov 2008 16:35:36 GMT

Will the '£' actually be updated in the table or can you try to get rid of it?

Rob

Re: 'u00A3' in file

Former Member — Wed, 26 Nov 2008 16:38:00 GMT

hi rob,

thanks for your reply..well it shud get updated along with the line.

like i have a line

tv cost £12. the whole line should get updated.

Re: 'u00A3' in file

Former Member — Wed, 26 Nov 2008 16:47:05 GMT

Check Thread:

[Note|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333133393338333433383331%7D.do]

Re: 'u00A3' in file

former_member194669 — Wed, 26 Nov 2008 16:50:39 GMT

Please try with addition

ENCODING NON-UNICODE in OPEN DATASET

this option uses default code page from table TCP0C.

I think UTF-8 is as same as codepade 1100. and Euro sign not supported with UTF-8

a®