Pad middle with fixed character length

Hi,

Let me know if there is a tool that can do this! thanks!!

Invoice #: GHMCC5300

Amount: -55611175

What I need to accomplish is a total string of 24 characters adding zeros before the amount but after the negative sign. The 8 is a fixed digit.

8 GHMCC5300-000055611175

Custom Tools

Accepted answers

Try this.

'8 ' + [Invoice]+ '-' +padleft(REGEX_Replace(tostring([Amount]), '-', ''),12,'0')

Is the Invoice and Amount on two different rows or are they in two different columns?

They are in two different columns - thx!

Try this.

'8 ' + [Invoice]+ '-' +padleft(REGEX_Replace(tostring([Amount]), '-', ''),12,'0')

This worked perfectly! thank you