Skip to Content
0
Former Member
Dec 07, 2011 at 07:09 PM

Clean up multi-valued parameter data (append spaces) for record selection

27 Views

Hi Everyone,

I have id info that is stored in the db as a string, and with leading spaces, like this

"      2120"

. However, the input variables will be numeric string or numbers, either "2120" or 2120. The field is always 10 characters including spaces.

How do I collect the Part Numbers from the user (as parameters) and then convert those parameters to the required format for the DB?

So far I'm able to do this for 1 part number , just not a multi-valued parameter full of them.

f_InputPartNumber =

stringvar InputPartNumber:= "2120"

f_AppendPart =

if length({@f_InputPartNumbers}) <= 10 then 

space(10 - length({@f_InputPartNumbers})) + {@f_InputPartNumbers}

else {@f_InputPartNumbers}

Record Selection Formula: =

{V_MISP1.MI_PART} = {@f_AppendPart}

Thanks for your tips,

😊 John