Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Grabbing a Subset of a String
#1
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?
Quote
#2
I would go with a regular expression (the re module). Regular expressions are used in tons of languages, so if you did a web search for "date regular expression" I'm sure you would find one fitting your requirements.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures

Quote
#3
(Jun-18-2019, 02:26 PM)ichabod801 Wrote: I would go with a regular expression (the re module). Regular expressions are used in tons of languages, so if you did a web search for "date regular expression" I'm sure you would find one fitting your requirements.
Thanks!
Quote
#4
If structure of strings is similar then one can achieve desired result also without re

>>> s = "Call Loc/Folder/(555) 555-5555 - 2/27/2019 8:52:34 AM/RoomB"
>>> " ".join(s.rsplit("/", maxsplit=1)[0].rsplit(maxsplit=3)[-3:])
'2/27/2019 8:52:34 AM'
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Da Bishop: There's a dead bishop on the landing. I don't know who keeps bringing them in here. ....but society is to blame.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Grabbing comma separed values from SQLite and putting them in a list PythonNPC 1 41 Yesterday, 02:16 PM
Last Post: buran
  Grabbing a value from one python script into another nickayres 3 480 May-24-2019, 08:21 PM
Last Post: snippsat
  Grabbing questions from a quiz app CodingUnicorn 0 403 Mar-05-2019, 11:26 PM
Last Post: CodingUnicorn

Forum Jump:


Users browsing this thread: 1 Guest(s)