Converting data in field with number formatting

[#1]

Hello All

I need to convert the data in the filed(last_accessed_page),

for example data in the field(last_accessed_page )are like,

last_accessed_page

1,1,1

1,1,2

1,1,3

(Above 1,1,1 specifies page number=1)

i need to format this  and display it like 1,2,3

dimension:

last_accessed_page

measure:

Count({<subject_status={'incomplete'}>}last_accessed_page)

Data Load Editor:

LOAD `subject_access_track_id`,

    `subject_name`,

    `client_id`,

    `lender_offer_id`,

    `subject_status`,

    last_accessed_page;

SQL SELECT `subject_access_track_id`,

    `subject_name`,

    `client_id`,

    `lender_offer_id`,

    `subject_status`,

    `last_accessed_page`

FROM SUBJECTACCESSTRACKING;

[Anonymous]

Using the subfield function on '1,1,2' returns just the last character of 2

     subfield( '1,1,2' , ',' , 3 )

So maybe in your load script maybe use something like :

     subfield(last_accessed_page,',',3)      as     [Page Number] ,

[OmarBenSalem · Accepted solution]

load *, SubField(last_accessed_page,',',3) as NewField;

LOAD `subject_access_track_id`,

    `subject_name`,

    `client_id`,

    `lender_offer_id`,

    `subject_status`,

    last_accessed_page;

[#4]

Ok thank you for that,

but instead of   subfield(last_accessed_page,',',3)  (ie instead of 3 can i place #)

[#5]

Sorry i think u understood in other way,

last_accessed_page 

1,1,1

1,1,2

1,1,3

It should be

1

2

3

[Anonymous]

Give it a try.  I think I understand your needs and my suggestion should work.

[OmarBenSalem]

That's what I'm doing :

[#8]

Thanks for that,,,it worked

[#9]

Page numbers are skipped!!!

[OmarBenSalem]

Go under aspect , x-axis: