Extracción delimitada

[Tesy]

Hola, estoy tratando de extraer un dato con la función de extrar, pero no me da el resultado que necesito:

Sólo necesito el numero posterior de Horas de participación:-

[Anonymous]

Hi @Tesy , 

Thanks for reaching out.

You can easily extract the numbers by splitting with ":".

Steps:

Reference:

Split columns by delimiter - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

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

[Tesy]

Muchas gracias @Anonymous y @amitchandak 

Lo que realmente necesito es aplicar lo que tengo en el Excel al Power BI

=VALUE(MID(W2,SEARCH("Horas de participación",W2)+26,SEARCH(";Evaluación global",W2)-SEARCH("Horas de participación",W2)-26))

[Anonymous]

Hi @Tesy ,

I saw that your screenshot is from Power Query, so I have provided a workaround in Power Query.

Pls does my workaround help?

If you're looking for help with Excel, I'm afraid I can't assist you here, as this is the Power BI Desktop forum.

Best Regards,
Stephen Tao

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

[amitchandak]

@Tesy , Can you use only  "-"  and that from start from end skip 0 

[Tesy]

Hello @amitchandak ,

Can it be made conditional?
If the column has a certain text, extract the necessary data?
For example, if the column has "Horas de participación: -15", extract the 15