Jun-18-2019, 02:22 PM
I need to create a new field we can call Date_Time_txt, which is based off of a long string (!FolderPath!). Example of the full string: "Call Loc/Folder/(555) 555-5555 - 2/27/2019 8:52:34 AM/RoomB". I initially started the code as Date_Time_txt= !FolderPath![42:64], which would start at the date and grab the time, but because of varying time and date characters, I also grab "/R" on some sets. How can I run the function to just grab the date and time?