Forum Discussion
Extract date and text
Hello,
I have a field with this example:
01/07/2022: a exemple of phrase 1
03/06/2022: a exemple of phrase 2
04/05/2022: a exemple of phrase
I would like to extract in a column the last date and the last text:
01/07/2022: a exemple of phrase 1
thanks
domstan152 , Power Query Split by Delimiter: into columns
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
4 Replies
domstan152 , Power Query Split by Delimiter: into columns
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
thanks amitchandak but which delimeter I have to use ? in my data there is no delimiter like a point or coma:
01/07/2022: a exemple of phrase 1
03/06/2022: a exemple of phrase 2
04/05/2022: a exemple of phrasedomstan152 , Colon :
based on what I see in your example
thank you very much amitchandak it works well !!!
