How to convert customers id in load script

[ecabanas]

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

[bbi_mba_76]

Hi,

you could concat 'C'&right('000000'&ID,6)

[saumyashah90 · Accepted solution]

You can concat that
While Loading

Load 'C' & right('000000'&ID,6)

[Gysbert_Wassenaar]

For example like this:

load num(ID, 'C000000') as ID Inline [

ID

1

20

333

400];

[#5]

Hi

PFA...   Hope it will help you

[ecabanas]

Thank's Saumya 😉