topic Re: How i will get the some format for postal code? in Application Development and Automation Discussions

How i will get the some format for postal code?

Former Member — Wed, 25 Mar 2009 11:30:35 GMT

Hi,

Iam getting the postal code(PSTLZ) from Pa0006.How i will get the Format is 'X9X 9X9' (space between characters 3 & 4).sample data for postal code is J7T 3J4.

Regards,

sujan

Re: How i will get the some format for postal code?

GauthamV — Wed, 25 Mar 2009 11:35:14 GMT

Postal code in genaral will be a six digit number.You dont have any problem

with numbers for that field.If you are giving some text along with numbers in

that field then it appears as space in between but there is no space really.

Re: How i will get the some format for postal code?

Former Member — Wed, 25 Mar 2009 11:48:14 GMT

hi,

refer this .

postal_code = 400012

then

lv_post1 = postal_code(3)

lv_post2 = postal_code+3(3)

then

concatenate lv_post1 ' ' lv_post2 to final_code.

Re: How i will get the some format for postal code?

Former Member — Wed, 25 Mar 2009 11:50:10 GMT

HI,

I hope there is space in the input of the data. since until unless if we pass the data as the space it will not form the space. Any how we can pass any type of data in that fields its not necessary to have only a 6digit of numberic value for the postal address.

regards,

naresh

Re: How i will get the some format for postal code?

Former Member — Wed, 25 Mar 2009 12:02:10 GMT

Hi sujan,

Try following.

Suppose l_pstlz is field in which you are getting ur postal code.....

concatenate l_pstlz(3) l_pstlz+3(3) into l_pstlz separated by space.

Hope it helps,

Pratik

Re: How i will get the some format for postal code?

Former Member — Wed, 25 Mar 2009 12:04:11 GMT

Thanks for reply.

regards,

Sujan