on 08-09-2009 11:06 PM
Hi! I have part numbers that tend to have varying length and I have a requirement to put leading zeros before them when I load the catalog data via Import Manager. The Replace function would not work for this as the number of leading zeros is not fixed. Does anyone know o a way to do that?
Cheers!
SF
Hi,
Have a look at the below approach
Assumption- Max Part Number length would be 10 digits.
Create one Assignment with expression
Mid(10000000000+PartNumber,2,10)
Expression will first add the PartNumber with 1000000000 then using Mid function it will extract the desired result.
E.g.
PartNumber = 3030
1000000000+3030 = 10000003030
After Mid = 0000003030
Create one workflow with the Assign step and use the assignment created above. Launch this workflow on Record Import.
I tried this and its working fine.
Regards,
Jitesh Talreja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.