topic Re: Format Changing DB table field. in Application Development and Automation Discussions

Format Changing DB table field.

Former Member — Wed, 29 Aug 2007 06:23:33 GMT

Hi Every Body!

In the table the field was stored in this format '123-12-5255' , What's my requirement is If i entered last four digit it should find the remaining field .

Ex:

If i Entered : 5255

It should find and display : 123-12-5255.

Any body can me help me out. Its An Urgent.

Thank you.

Re: Format Changing DB table field.

Former Member — Wed, 29 Aug 2007 06:40:20 GMT

Hi,

You can use offset for this.

Try this piece of code

if field+7(4) = 5255.

write:/ field.

endif.

<b>Reward points if it solves ur query or come up with some more details.</b>

Thanks

Chinmay

Re: Format Changing DB table field.

Former Member — Wed, 29 Aug 2007 06:50:19 GMT

Try this

<b>SELECT <field> FROM <tablename> into <variable> where field+7(4) = '5255'</b>.

You can see the output in <b><variable></b>

Regards,

Amit

Re: Format Changing DB table field.

Former Member — Wed, 29 Aug 2007 06:50:36 GMT

Hello Markiv,

for this you have to do one thing...

after entering 5255 in that field...

at selection-screen on <Selet-option>

concatenate '*' <select-option>-low into <field1>

select single * from <tab> where <field> eq field1.

if sy-subrc = 0.

move <tab>-<field> to <select-option>.

modify <select-option>.

else.

write: ' no such value'.

endif.

Reward If Helpful.

Regards

Sasidhar Reddy Matli.

Message was edited by:

Sasidhar Reddy Matli

Re: Format Changing DB table field.

Former Member — Wed, 29 Aug 2007 06:53:46 GMT

if field = '*5255

write :/field

select field

where field in '*5255'

into ...

rewards points . hope it help