In Attribute Manager I have created 3 fields (Borough Code, Block_Leading, Lot_Leading), 2 of which have leading zeros in them. I need to concatenate the three fields into a 10 digit string while retaining the leading zeros in the order listed above. My formula for for Block_Leading is @PadLeft(@Value(Block),5,0) and the formula for Lot_Leading is @PadLeft(@Value(Lot),4,0). Can I concatenate all three fields in a single formula in a new field in Attribute Manager and if so how?
I don't think you need the intermediate step
You could just do this
@Value(Borough Code)@PadLeft(@Value(Block),5,0)@PadLeft(@Value(Lot),4,0)
Thanks for your response ebygomm. I think you're right about removing the intermediate step but the formula above returns a value with like 5 carriage returns in it:
2
022600010
Thanks for your response ebygomm. I think you're right about removing the intermediate step but the formula above returns a value with like 5 carriage returns in it:
2
022600010
Are you sure the carriage returns aren't in your first value?
If they are you can do @Trim(@Value(Borough Code))
Thanks ebygomm the carriage returns were in the first value.