Create a column to extract the number

[jobf]

Hello. Look at the table below.

Application

1st application

12th application

3rd application

7th application

11 application

I need to create a new column that extracts only the number from the previous column. Generally I would use LEFT, but as some numbers have different digits, this option would not work. The table would have to look like this:

Application	Index
1st application	1
12th application	12
3rd application	3
7th application	7
11 application	11

[Anonymous · Accepted solution]

Hi @LeandroDeodato ,Thank you for your quick reply, I will add more.

Hi @jobf ,

The Table data is shown below:

Use the following DAX expression to create a column

Column =
VAR _len =
    LEN ( [Application] )
VAR _table =
    ADDCOLUMNS (
        GENERATESERIES ( 1, _len, 1 ),
        "Char", IFERROR ( VALUE ( MID ( [Application], [Value], 1 ) ), BLANK () )
    )
RETURN
    VALUE ( CONCATENATEX ( _table, [Char] ) )

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LeandroDeodato]

use data transform and split colummn using "space caracter" delimiter, also substitute "ª" caracter to " "