Add four "0" after the "-"

[BautistaC888]

Hello,

I need to add four "0" after the "-"
Input:

Output:

Thank you.

[Luke_C · Accepted solution]

Hi @BautistaC888 

Assuming there's only going to be one hyphen, you can use a replace function to update the hyphen to have four 0s after it. 

replace([Entrega],"-","-0000")

[cplewis90]

Hey @BautistaC888,

You could use a standard formula tool and use this formula to add the 4 "0"s after the "-":

Left([Entrega], FindString([Entrega], "-")+1)+"0000"+right([Entrega], Length([Entrega])-FindString([Entrega], "-")-1)

[Hollingsworth]

It occurs to me that you may want to error trap for instances in which there are a different number of characters after the hyphen by using the padleft() function.

left([Field1],FindString([Field1], '-')+1) + padleft(Substring([Field1],FindString([Field1], '-')+1),8,'0')

With this formula, if the input is 1234-345 or 1234-45677, then the output would always be 13 characters: 1234-00000345 and 1234-00045677, respectively.