Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.
Thanks a lot, it seems to work
You are welcome