if first N contains value then extract all after - Power Query Excel

[afgi]

hi,

I am looking for a solution that will extract text after "/", but only if that delimiter is within the first 15 digits of a text. I am looking for a solution in Power Query.

For example:

RTP2/ 1111101100501000011201	1111101100501000011201
RTP2/ 1111101100501000011201 / hj7G olk33	1111101100501000011201
1111101100501000011201	1111101100501000011201

[dosydos]

lets say your data starts in A1.
then in B1 use:

Please Login or Register  to view this content.

[afgi]

hi, sorry, I didnt specify it in my question, but only in the subject. I need to find a solution in Power Query in Excel.

[DJunqueira]

In Power Query you could use this statement.

= Table.TransformColumns(#"Colunas Removidas", {{"Test1", each if Text.Contains(_, "/") then Text.BetweenDelimiters(_, "/ ", " /") else _, type text}})

As in:

Please Login or Register  to view this content.

[Czeslaw]

Power Query

Please Login or Register  to view this content.

[afgi]

thanks, this is what I was looking for!

[afgi]

Power Query

Please Login or Register  to view this content.

thanks, also works fine

[DJunqueira]

Tks for the feedback, glad to have helped.