Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with:
ID
1
20
333
400
In the script process i'd like to convert in this format C######
C000001
C000020
C000333
C000400
thank's guys
Eduard
Hi,
you could concat 'C'&right('000000'&ID,6)
You can concat that
While Loading
Load 'C' & right('000000'&ID,6)
For example like this:
load num(ID, 'C000000') as ID Inline [
ID
1
20
333
400];
Hi
PFA... Hope it will help you
Thank's Saumya 😉