Python Regex : substring date from string

Question

Can someone help me providing correct regex. I want to remove date from a string.

Ex string : IO_SE_SOURCE_2015-01-30T19_14_59 I want to remove the date part in the string and fetch only IO_SE_SOURCE as the result

I am doing this in python using re.sub() def.

So, when I do the below command

var=re.sub(regexpattern,repl,"POC_LN_SOURCE_2015-01-30T19_14_59.something")

var should contain the value POC_LN_SOURCE

-Thanks

Do you want to capture everything from the beginning of the string up to _<datetime>? — Alex Hall
– Alex Hall, Commented Jul 4, 2017 at 23:05
Try re.sub('([A-Z_]+)_([\d\-T_]+)(.+)','\\1', 'POC_LN_SOURCE_2015-01-30T19_14_59.something'). — Abdou
– Abdou, Commented Jul 4, 2017 at 23:10
@AlexHall - Yes. I want capture before(_datetime) to a variable — no1
– no1, Commented Jul 4, 2017 at 23:16
@Abdou- I tried. The entire is been captured. I want only POC_LN_SOURCE to be captured. — no1
– no1, Commented Jul 4, 2017 at 23:18
That's exactly what the code captures. It returns POC_LN_SOURCE. Isn't that what you're getting? — Abdou
– Abdou, Commented Jul 4, 2017 at 23:21

Alex Hall · Accepted Answer · 2017-07-04 23:18:54Z

2

There's no need for re.sub, just capture a group from a match:

>>> re.match(r'(.+)_\d{4}-\d{2}-\d{2}', 'POC_LN_SOURCE_2015-01-30T19_14_59.something').group(1)
'POC_LN_SOURCE'

answered Jul 4, 2017 at 23:18

Alex Hall

36.2k5 gold badges63 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1