add 0 to string

[Shani1]

Hi,

i have a 19 million+ rows of data which i need to adjust in load script. But don't know how.

I have prodcts serials with different lengths and i need to add '0's on left side of sales Serials so this can become 30 characters

see the example below. 

how do i do that?

SaleSerial	SystemSerial
CCCC8E53616C	000000000000000000CCCC8E53616C
8E5361212	00000000000000000000008E5361212

[vijayaganesh_s · Accepted solution]

Hello,

Please try the below code and method this will help you!

Table:
LOAD
SaleSerial,
REPEAT(0,30-LEN(SaleSerial))&SaleSerial AS SystemSerial;
LOAD * INLINE [
SaleSerial
CCCC8E53616C
8E5361212
];

This code will add 0s to the left side of the SaleSerial that you are expecting as SystemSerial.

[Shani1]

Thanks a lot, it seems to work 

[vijayaganesh_s]

You are welcome