Solved: Splitting 4 numbers - Page 2

Domearian · 09-27-2024 09:47 AM

Hi all, I have a four number item. For Example "3423".

I want to get the 1st number of the four, then the 2nd , 3rd etc.

So column 1 would be the first number,

column 2 would be the 2nd

and so on. How can I split the 4 numbers apart?

Suvrutt_Gurjar

LEFT([FOUR_DIGIT_NUMBER],1) for first digit.

If you wish the extracted part to be a number type, please wrap it by NUMBER()

NUMBER(LEFT([FOUR_DIGIT_NUMBER],1))

Similarly, please follow for extracting other numbers by using MID() function for second and third digit and RIGHT() for the fourth digit.

NUMBER(RIGHT([FOUR_DIGIT_NUMBER],1)) should give the 4 th digit.