Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    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.

     

AnkitBI's avatar
AnkitBI
Solution Sage
6 years ago

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.

 

IDSVina's avatar
IDSVina
New Member
4 years ago

 So I have this type of data. Could you help me write the formula that will return the values as "-00_김미자35-a3-35" for example.
I want to remove the date value. Thanks