topic Re: problem with character field in Application Development and Automation Discussions

problem with character field

Former Member — Mon, 31 Jan 2011 11:14:39 GMT

hi experts,

i have two character fields with legth 18 each..values are 123 and 126.

i have to display in smartfrom as 123 to 126.

bcoz of 18 characters leght i am facing some place adjutment problem in smartfrom

so it is displaying as

' somespace 123to

126.

can any body plz help me how to acheive this?

Edited by: s veena on Jan 31, 2011 12:17 PM

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:17:43 GMT

Try the key word CONDENSE.


   CONDENSE VARIABLE

Mishra

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:21:10 GMT

Hi mishra,

Thanks for giving reply

i have to display as

gv_sernr = 123 to 126 ( it should be one line).

but it is coming like

somespace 123to

126.

can you plz help me out....

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:27:01 GMT

I think you should search the forum or google about concatenation.

Or do F1 on CONCATENATE.

These are basic questions for a fresher, do some search or investigation on your issues you will get the result.

Regards

Mishra

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:27:05 GMT

Hi veena,

Condense it before concatenating or use as below;

&gv_sernr_from(C)& to &gv_sernr_to(C)

Regards,

Karthik D

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:29:32 GMT

since its a character variable u can use condense statement to compress it

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:34:01 GMT

gv_sernr = 123 to 126 ( it should be one line).
but it is coming like
somespace 123to
126.


> I think you should search the forum or google about concatenation.
> Or do F1 on CONCATENATE.

I'm not sure how CONCATENATE will serve here,but CONDENCE might do.

@ S veena: Can you please check the space on the window if this is sufficient to accommodate the whole value in one line.

Cheers,

Amit

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:36:13 GMT

For both variables use -->> shift var_nam LEFT DELETING LEADING '0'.

and then concatenate var1 ' to ' var2 into var3.

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:40:30 GMT

@Amit: Concatenate will serve if you concatenate those tow variable in to one..

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:41:36 GMT

my previous assumption was it is showing leading zeroes.

For space either you can use condense for both variables or shift var_nam LEFT DELETING LEADING ' '. and then concatenate using the way i have mentioned earlier.

Re: problem with character field

Former Member — Mon, 31 Jan 2011 11:50:52 GMT

Check with the layout size too.

You can do one thing: take another variable of char type and concatenate the two fields into it. with TO as a seperator.

also check with the length of the variable.

The box containing the varaible should be large enough to hold it.

Regards, Uttam

Re: problem with character field

Former Member — Mon, 31 Jan 2011 12:06:24 GMT

Hi Veena,

write in smartform like this

&gv_sernr_from(CR)& to &gv_sernr_to(CR) " CR is used for condense as well as Right allignment

Regards,

Ganesh Reddy