Forum Discussion
Split text columm with date and # delimiter
Please, I have a string columm (obs) with date and text. I need to split the text and date in the Obs column (see BEFORE) into a separate row for each Funci (see AFTER), using the # as a delimiter...
Hi,
The best I reached is the folowing code:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Funci", type text}, {"obs", type text}}),
#"Filled Down" = Table.FillDown(#"Changed Type",{"Funci"}),
#"Lowercased Text" = Table.TransformColumns(#"Filled Down",{{"obs", Text.Lower, type text}}),
Custom1 = Table.AddColumn(#"Lowercased Text", "Date", each Text.Remove([obs],{"a".."z", "#"})
)
in
Custom1
To make it work you have to add after the "#" all the alphabetical and special characters that are not covered in my code.
Hope have helped you a little bit:
You can follow me on LinkedIn -->Abdoul Karim Niang | LinkedIn