All Forums Analytics
sham 1 post Joined 04/07
03 Apr 2007
how to select part of string

In the foll Eg... , I want to select part of the string before numeric. If the first word numeric, want to select 2nd word to before numeric.

O PREMIUM WATER ACH 070228 DIR PAYMENTXXXX YYYYY
94009 NASE PAYMENT 94009 9544537498XXXX YYYYYY
NATIONWIDE INS CUST-AGNT 070312 43000-934483250 AGENT CENTER
Sprint PCS Telcom 070302 0584245200xxxx yyyyy
WEST COAST LIFE INS. PREM. 070228 WC1Z02418843xxxx y zzzz
STATE FARM RO 08 SFPP 08 S 043840zzzz tttt x
THE LIFESTYLE CLUB DRAFT 030507 28802xxxx yyyy
PRIMERICA LIFE INS. PREM MAR,07 000002343Yx y zzzz

I want to be able to select Only

O PREMIUM WATER ACH
NASE PAYMENT
NATIONWIDE INS CUST-AGNT
Sprint PCS Telcom
WEST COAST LIFE INS. PREM.
STATE FARM RO
THE LIFESTYLE CLUB DRAFT
PRIMERICA LIFE INS. PREM

Thanks very much in advance.
Sham

You must sign in to leave a comment.