InfoPath Dev

Hello,

I have an InfoPath form with some data connections to SharePoint lists. I concatenate several fields into 1 field. Example:

Field1 = 45
Field2 = 66
Field3 = 00

So concatenated, Field4= 456600

Sometimes, Field2 is empty. Then I get Field4= 4500. But that's not what I need, Field4 needs to be 6 characters long! So I want it to be 45  00. Is this possible?

This should do it:

concat(Field1, substring(concat(Field2, "  "), 1, 2), Field3)