topic How to select certain digit from a field in QlikView

How to select certain digit from a field

geam1988 — Thu, 06 Sep 2018 10:54:20 GMT

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

Re: How to select certain digit from a field

YoussefBelloum — Thu, 06 Sep 2018 11:13:19 GMT

Hi,

use left() function

like this:

TABLE:

LOAD

LEFT(FIELDA,10) as TEST1,

LEFT(FIELDA,6) as TEST2

FROM...

Re: How to select certain digit from a field

wade12 — Thu, 06 Sep 2018 12:34:54 GMT

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

best wishes.

Re: How to select certain digit from a field

tulabandula — Thu, 06 Sep 2018 13:07:02 GMT

Use below

Tab:

Load *,

left(field_name,10) as Desired_name,

right(field_name,6) as Desired_name1

from table;