Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

'u00A3' in file

Former Member
0 Likes
988

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
947

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

Rob

6 REPLIES 6
Read only

BH2408
Active Contributor
0 Likes
947

Hi ,

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

Regards,

bharani

Read only

Former Member
0 Likes
947

OPEN DATASET p_ifile FOR INPUT IN TEXT MODE .

its throwing me a bug .why?

when its ok in other programs.

Read only

Former Member
0 Likes
948

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

Rob

Read only

0 Likes
947

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.

Read only

0 Likes
947

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

Read only

Former Member
0 Likes
947

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]