Advanced Account Correlation Rule - Left padding an attribute value

[Paul_Meyer]

For an application, the accounts have an attribute value that is not consistent and multiple conditions would be required to find a match. The User username attribute is a left padded 8 digit number, such as 00012345.

Example account attribute values:

• 4567
• 00012345

Any suggestions on how an advanced query should look like to either match a username on the exact account attribute value or match with a left padded account attribute value?

[rushikeshvartak]

Based on my understanding 

Accountname is 12345

Username is 00012345

Then below will be correlation rule.

user.username=LPAD(accounts.name, 8, "0")