SOLVED
Home

Transformation of values' lenght in a field based on the number of caracters

%3CLINGO-SUB%20id%3D%22lingo-sub-908458%22%20slang%3D%22en-US%22%3ETransformation%20of%20values'%20lenght%20in%20a%20field%20based%20on%20the%20number%20of%20caracters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908458%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20add%20a%20new%20field%20by%20applying%20a%20condition%20on%20data%20values%20from%20my%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EVendor%20field%3C%2FSTRONG%3E.%20I%20want%20to%20set%20each%20values%20in%20that%20field%20so%20they%20all%20have%2010%20characters%20and%20to%20do%20so%20i%20want%20to%20apply%20a%20condition%20in%20such%20a%20way%20that%20if%20the%20value's%20lenght%20is%20smaller%20than%2010%20then%200%20should%20be%20added%20in%20front%20of%20the%20value%20until%20it%20makes%2010%20characters.%3C%2FP%3E%3CP%3EFor%20Example%3A%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EVendor%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E0045676%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E000034567%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E76890650%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2340987653%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20should%20get%20the%20following%20results%3A%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EVendor%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E0000045676%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E0000034567%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E0076890650%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2340987653%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ETatiana%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-908458%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ee%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908524%22%20slang%3D%22en-US%22%3ERe%3A%20Transformation%20of%20values'%20lenght%20in%20a%20field%20based%20on%20the%20number%20of%20caracters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424271%22%20target%3D%22_blank%22%3E%40Tatynout%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20custom%20format%20with%2010%20zeroes%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20399px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137170i355F47C1A2AD443D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909059%22%20slang%3D%22en-US%22%3ERe%3A%20Transformation%20of%20values'%20lenght%20in%20a%20field%20based%20on%20the%20number%20of%20caracters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909059%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909118%22%20slang%3D%22en-US%22%3ERe%3A%20Transformation%20of%20values'%20lenght%20in%20a%20field%20based%20on%20the%20number%20of%20caracters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424271%22%20target%3D%22_blank%22%3E%40Tatynout%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Tatynout
New Contributor

Hello,

I would like to add a new field by applying a condition on data values from my Vendor field. I want to set each values in that field so they all have 10 characters and to do so i want to apply a condition in such a way that if the value's lenght is smaller than 10 then 0 should be added in front of the value until it makes 10 characters.

For Example:

Vendor
0045676
000034567
76890650
2340987653

 

I should get the following results:

Vendor
0000045676
0000034567
0076890650
2340987653

 

Thanks for your help.

Regards,

Tatiana

3 Replies
Solution

@Tatynout 

You may apply custom format with 10 zeroes

image.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies