Pad middle with fixed character length

[mzlee]

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

[cjaneczko]

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

[mzlee]

They are in two different columns - thx!

[cjaneczko · Accepted solution]

Try this. 

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

[mzlee]

This worked perfectly! thank you