Forum Discussion
Remove Text between a pattern of string
I have a Column with data as below "/Data/Bucket-Folder/Heritage-Bucket-Folder/2019/09/02/01/30/newtext" Here i would like remove the pattern of text starting with numbers/dates as following 2019...
Anonymous
Have you tried this custom column
Text.Combine(List.Select(Text.Split([Column1],"/"),each Text.Start(_,1) > "A"),"/")
Thanks
Ankit JainDo Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Zubair_Muhammad, i tried with the following:
This creates a lot of duplicates after expanding the custom column.
Table.AddColumn(#"Removed Top Rows", "Custom", each if Text.StartsWith([Url], "/Data/Bucket-Folder/Heritage-Bucket-Folder/") then (Text.Start([Url],Text.PositionOf([Url],"/2"))
& Text.End([Url],Text.Length([Url])-Text.PositionOf([Url],"/",Occurrence.Last)))
else [Url])
Anonymous
Have you tried this custom column
Text.Combine(List.Select(Text.Split([Column1],"/"),each Text.Start(_,1) > "A"),"/")
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
