=MID(A2,24,2)
... also numbers?=MID(A134,35,FIND("-",A134,33)-35)
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Split Column by Character Transition" = Table.SplitColumn(Source, "path_unix", Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)), {"path_unix.1", "path_unix.2", "path_unix.3"}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Split Column by Character Transition", "path_unix.2", Splitter.SplitTextByEachDelimiter({"/"}, QuoteStyle.Csv, true), {"path_unix.2.1", "path_unix.2.2"}),
#"Removed Other Columns" = Table.SelectColumns(#"Split Column by Delimiter",{"path_unix.2.2"})
in
#"Removed Other Columns"
Cant find Povery query in Excel 2016an alternative solution is to employ Power Query. Here is the Mcode
Your file attached for review of this method.Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Split Column by Character Transition" = Table.SplitColumn(Source, "path_unix", Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)), {"path_unix.1", "path_unix.2", "path_unix.3"}), #"Split Column by Delimiter" = Table.SplitColumn(#"Split Column by Character Transition", "path_unix.2", Splitter.SplitTextByEachDelimiter({"/"}, QuoteStyle.Csv, true), {"path_unix.2.1", "path_unix.2.2"}), #"Removed Other Columns" = Table.SelectColumns(#"Split Column by Delimiter",{"path_unix.2.2"}) in #"Removed Other Columns"
=LEFT(MID(A2,FIND("-",A2,20)+1,255),19)
in one column=RIGHT(MID(A2,FIND("-",A2,20)+1,255),25)
in another colimnsdieselkhan
If ... as above is clear for You then ... You could use it.
Others or at least I ... would need clear rules, what are You looking for.
Your 'if there is no...' looks clear rule.
In 2016, it is called Get and Transform and is located on the Data Tab. Also, there is a link in my signature that you should not ignore.Cant find Povery query in Excel 2016