Add trailing place holders to fields 2

[man5104]

I have to append 2 fields together but before I do that I need to append spaces to the end of the 1st field to ensure its length is 15 characters. And the 2nd field needs to be 10 characters and therefore it may need spaces too. I can use spaces or the @ symbol as the place holder. For example
if I have 00ANA00AI001 in the first field and XQ01 in the second field I need to combine the two fields and change them to 00ANA00AI001@@@XQ01@@@@@@.

Can anyone help me with the sytax to accomplish this?

Thanks,

Michelle

 

[RoyVidar]

The easiest, though perhaps not very elegant, is probably something like the following:

[tt]const cstrPadString as string "@@@@@@@@@@@@@@@"
msgbox left$(FirstField & cstrPadString",15) & _
left$(SecondField & cstrPadString",10)[/tt]

Roy-Vidar

 

[RoyVidar]

Ouch, wrong forum, though the technique could be used:

NewField: left$(FirstField & "@@@@@@@@@@@@@@@,15) & left$(SecondField & "@@@@@@@@@@",10)

Roy-Vidar

 

[man5104]

Roy,

Thanks for the quick response! I must be applying your solution wrong becuase it isn't working. Here is what I filled into the "Update To field" in the query:

left$([U6 Analog Tags].KKS & "@@@@@@@@@@@@@@@,15) & left$([U6 Analog Tags].Sigdef & "@@@@@@@@@@",10)

This gave a syntax error so I had to remove the " after the 3rd Ampersand, then the sytax was correct but the result didn't pad the first field with trailing zeros up to 15 characters?? It did combine the 2 fields and add @ after the 2nd field. Any more ideas???

Thank you,

Michelle

 

[traingamer]

try:

left$([U6 Analog Tags].KKS & "@@@@@@@@@@@@@@@[COLOR=red]"[/color],15) & left$([U6 Analog Tags].Sigdef & "@@@@@@@@@@",10)

You were on the right track.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[man5104]

That worked! Thanks for helping me out.

Michelle