How to select certain digit from a field

[geam1988]

Hello,

I have i have a field with 16 digit number. How can i select  first 10 digits from that field and rename it as well as how to select last 6 digits and rename it.

Example:  FIELD A = 0010025010001000

i want to show first 10 digits as TEST1  and 2nd 6 digits as TEST2  (TEST1 =0010025010   and TEST2 =001000 )

Best Regards

Kazi

[YoussefBelloum]

Hi,

use left() function

like this:

TABLE:

LOAD

.

.,

LEFT(FIELDA,10) as TEST1,

LEFT(FIELDA,6) as TEST2

FROM...

[wade12]

i have attached a great "cheat sheet" for you.

best wishes.

[tulabandula · Accepted solution]

Use below

Tab:

Load *,

left(field_name,10) as Desired_name,

right(field_name,6) as Desired_name1

from table;