Re: Extract the text between last comma and last but one comma.
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Wed, 05 Mar 2008 17:12:30 -0600
If you only want to keep the Seq=###, you could do this, too:
Select the range to fix
Edit|Replace
what: *Seq (asterisk, Seq)
with: Seq
Replace all
Then
Edit|Replace
what: ,* (comma, asterisk)
with: (leave blank)
replace all
The asterisk is a wildcard that represents any set of characters.
Sreedevi wrote:
I have a very long text in a cell. EX:
4919,"0.019999","7.2.84.192","10.160.18.52","RTP","PT=Unknown (99), SSRC=0x0,
Seq=343, Time=514216 "
I need to extract only the Seq=343 portion of it. The length of the text is
not constant in all the rows. Also, the sequence number is sometimes 2/3/4/5
digit.
Please help
--
Dave Peterson
.
- Prev by Date: Re: Need to find the Average
- Next by Date: Re: formatting help
- Previous by thread: Re: Extract the text between last comma and last but one comma.
- Next by thread: Re: pivot table charts
- Index(es):
Relevant Pages
|
