Extraer numero de texto

[Anonymous]

Buenos días, necesito extraer los dos últimos caracteres de esta cadena de texto. Intenté hacerlo con el comando DERECHO y me dio, pero el número de los resultados se mantiene como un texto y lo necesito como un número porque debo realizar operaciones con él. Muchas gracias por la atención y ayuda.

[ChrisMendoza · Accepted solution]

@Anonymous,

You can write an IF ( ) with an ISERROR to only show when there is no error.

Column = 
IF (
    NOT (
        ISERROR (
            VALUE (
                RIGHT ( Table1[Column1], 2 )
            )
        )
    ),
    VALUE (
        RIGHT ( Table1[Column1], 2 )
    )
)

[Anonymous · Accepted solution]

Excellent!!!!
Thank you very much for your help. Can I take advantage and ask about a formula to calculate the growth rate?

[Joorge_C · Accepted solution]

Hola,

En power query intenta:

1-Transforma la columna a Texto (temporalmente)

2-En el Menu>Transform (o Add Column en caso ocupes una columna extra)>Extract  (aqui seleciona los ultimos 2 characteres)

3-Cambiar el formato de las columnas de Texto a Numero

[Joorge_C · Accepted solution]

Hola,

En power query intenta:

1-Transforma la columna a Texto (temporalmente)

2-En el Menu>Transform (o Add Column en caso ocupes una columna extra)>Extract  (aqui seleciona los ultimos 2 characteres)

3-Cambiar el formato de las columnas de Texto a Numero

[Anonymous]

Thanks Joorge_C
Another solution to what I needed. Thank you very much for your contribution

[ChrisMendoza]

@Anonymous,

Try using VALUE ( ) :

Column = VALUE(RIGHT(Table1[NOCONTENEDOR],2))

[Anonymous]

Good morning Chris Mendoza,
Thanks for your attention. It shows #ERROR in the column. Already validate that the number does not have spaces

[ChrisMendoza]

@Anonymous,

My guess is that in your actual data you can't always just take the RIGHT ( ) 2 characters? Possibly you need to take the x characters to the RIGHT of the '-'?

Hm, actually I can't reproduce your error.

Google Translate says:
you can not convert the 'E' value of the Text type to the tip number

My attempt translating to Spanish using Google Translate

Esto significa que tiene un carácter 'E' que se encontró en la DERECHA (), 2

[Anonymous]

Maybe you're right, I just saw the following:

[Anonymous]

Thank you. Maybe another way to do it?

[petrovnikitamai]

try this

column = right([NONCONTENEDOR];2)

and change column type

[Anonymous]

Nothing, it shows me the same error

[ChrisMendoza · Accepted solution]

@Anonymous,

You can write an IF ( ) with an ISERROR to only show when there is no error.

Column = 
IF (
    NOT (
        ISERROR (
            VALUE (
                RIGHT ( Table1[Column1], 2 )
            )
        )
    ),
    VALUE (
        RIGHT ( Table1[Column1], 2 )
    )
)

[Anonymous · Accepted solution]

Excellent!!!!
Thank you very much for your help. Can I take advantage and ask about a formula to calculate the growth rate?

[ChrisMendoza · Accepted solution]

@Anonymous,

You should start another Post as it is not related to this Post.  You should make sure to include sample data that is relevant to your issue.

[Anonymous]

Thanks Chris, I did not understand very well. I am using the translator because I am very bad for English. Thank you for your comments

[petrovnikitamai]

new column = value(right([NOCONTENDOR];2))