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: 

Delete/Replace content of column with blank value

0 Kudos
608

Hi Everyone,

The internal table contains contains field A,B,C,D

I need to remove the contain of D

suppose table has following entries:

A B C D

1 2 3 (blank)

4 5 6 .00

7 8 9 .00

0 6 1 (blank)

Requirement is to remove ".00" and keep it blank

How can this be achieved?

Thanks.

3 REPLIES 3

lenapadeken
Product and Topic Expert
Product and Topic Expert
548

Hi,

The "blank" entries depend on the data type, since initial values are returned. Character-like types return blanks or empty strings while numeric types return 0.

You can find an overview here.

Best regards,

Lena

0 Kudos
548

how do i delete content of column w/o deleting the row

lenapadeken
Product and Topic Expert
Product and Topic Expert
0 Kudos
548

For deleting the values of a column, many answers are given, for example, here.