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