Forum Discussion

Tiger2514555's avatar
Tiger2514555
Icon for Helper III rankHelper III
2 years ago
Solved

Extract dates from text mixed with dates in row

Exception Message that is not Move In Rcpt or Move Out Rcpt will take the value from the Date column. If it is Move In Rcpt or Move Out Rcpt, take the date value in Move In Rcpt or Move Out Rcpt.

The results I want

DateException MessageResult
06/09/2023Expedited 82 Days06/09/2023
19/07/2023Move In Rcpt 16/05/202316/05/2023
20/06/2023Move Out Rcpt 02/09/202302/09/2023

 

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    2 years ago

    Give this a try as a calculated column on your table.

    Result = 
IF ( 
    ISERROR ( DATEVALUE ( RIGHT ( YourTable[Exception Message], 10 ) ) ), 
    BLANK(), 
    DATEVALUE ( RIGHT ( YourTable[Exception Message], 10 ) ) 
)

     

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    2 years ago

    Give this a try as a calculated column on your table.

    Result = 
IF ( 
    ISERROR ( DATEVALUE ( RIGHT ( YourTable[Exception Message], 10 ) ) ), 
    BLANK(), 
    DATEVALUE ( RIGHT ( YourTable[Exception Message], 10 ) ) 
)