How to split at specified delimiter

Thread Rating:

1 Vote(s) - 4 Average
1
2
3
4
5

Thread Modes

How to split at specified delimiter

SriRajesh
Lumberjack

Posts: 124

Threads: 74

Joined: Apr 2017

Reputation: 0

Dec-27-2018, 01:00 PM (This post was last modified: Dec-27-2018, 01:01 PM by SriRajesh.)

Hi,
I have below DataFrame:
input:

VA004L200E2T99
VG002K500E4T99
VG002K500E4R45
VN009K30E6T00
VA007K100E2T40

I want to split at "E" and extract the numerical part to the right & left side of "E"
Desired output:

200E2
500E4
500E4
30E6
100E2

I tried the bleo code, but it is removing the specified character.

import re
out=re.sub(r'E', '', input)
print(out)

Find

Messages In This Thread

How to split at specified delimiter - by SriRajesh - Dec-27-2018, 01:00 PM

RE: How to split at specified delimiter - by metulburr - Dec-27-2018, 02:14 PM

RE: How to split at specified delimiter - by SriRajesh - Dec-27-2018, 02:28 PM

RE: How to split at specified delimiter - by Gribouillis - Dec-27-2018, 02:30 PM

RE: How to split at specified delimiter - by SriRajesh - Dec-27-2018, 02:41 PM

RE: How to split at specified delimiter - by snippsat - Dec-27-2018, 03:43 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	python Read each xlsx file and write it into csv with pipe delimiter	mg24	4	1,525	Nov-09-2023, 10:56 AM Last Post: mg24
	Context-sensitive delimiter	ZZTurn	9	1,544	May-16-2023, 07:31 AM Last Post: Gribouillis
	Read csv file with inconsistent delimiter	gracenz	2	1,219	Mar-27-2023, 08:59 PM Last Post: deanhystad
	Delimiter issue with a CSV file	jehoshua	1	1,328	Apr-19-2022, 01:28 AM Last Post: jehoshua
	How to create new line '/n' at each delimiter in a string?	MikeAW2010	3	2,879	Dec-15-2020, 05:21 PM Last Post: snippsat
	copy content of text file with three delimiter into excel sheet	vinaykumar	0	2,377	Jul-12-2020, 01:27 PM Last Post: vinaykumar
	How to print string multiple times separated by delimiter	Mekala	1	1,925	May-23-2020, 09:21 AM Last Post: Yoriz
	How to split string after delimiter	SriRajesh	1	2,137	Sep-11-2019, 11:25 AM Last Post: metulburr
	Merge 2 lines with delimiter	Buddhism	9	4,520	May-05-2019, 02:43 AM Last Post: Buddhism
	Parsing text list to csv using delimiter discarding non-interesting data	murdock72	3	4,274	Feb-22-2017, 06:38 PM Last Post: buran

Users browsing this thread: 2 Guest(s)

View a Printable Version

How to split at specified delimiter

User Panel Messages

Announcements