Load InLine, Numbers like text

[MarcoARaymundo]

Hi!

I need load fields(ACC_COOR and ACC_VEND) like text.

LOAD * INLINE [

    ACCESS, USERID,  PASSWORD, ACC_COOR, ACC_VEND

    ADMIN,  admin, ,  *, *

    USER, user1, ,  000048, 000047

];

Any ideia?

[alexandros17 · Accepted solution]

Use the function text(nnnn)

[kaushiknsolanki]

Hi,

     Try

LOAD ACCESS,USERID,PASSWORD,Text(ACC_COOR) as ACC_COOR,Text(ACC_VEND) as ACC_VEND INLINE [

    ACCESS, USERID,  PASSWORD, ACC_COOR, ACC_VEND

    ADMIN,  admin, ,  *, *

    USER, user1, ,  000048, 000047

];

Regards,

Kaushik Solanki