You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I add leading zeroes to certain fields?

Received Response
18
Views
1
Comments

Looking for advice/insights:

Using Oracle Eloqua, I'm looking for a way to ADD a '0' to zip codes with 4 digital (US east coast zip codes), for example 2345 should be 02345

AND

add leading zeros to an ID field where the total character count should be 15, however, sometimes the leading zeros are stripped and we're left with 123 or 12356, so we'd need 123 to be: 000000000000123 and 12356 should be: 000000000012356

I was poking around in Regex replacement in the data washing machine activity but I wasn't able to find anything definitive.

anybody have any insights on how to accomplish this? THANKS! 🍩

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!