• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

How to adding leading spaces to MCU

Andrew2009

Well Known Member
The MCU field in F0006 has 12 characters. I have a value such as "36000" and I want to query F0006 by passing in this value into the MCU field. I need to add leading spaces to the value "36000". Is there a bsfn that I can use to do this or I have to manually add spaces to it?

Thanks
 

nkuebelbeck

VIP Member
which is all N1000032.FormatBusinessUnit pretty much does

Event Level Variables
----------------------------------------
evt_szTempBusinessUnit_MCU [MCU]
----------------------------------------
00001 VA evt_szTempBusinessUnit_MCU = rtrim([BF szUnformattedBU],' ')
00002 BF szFormattedBU = lpad([VA evt_szTempBusinessUnit_MCU],' ',12 )
 
Top