how to select part of string

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

how to select part of string

Rate Topic

Display Mode

Topic Options

Author

Message

sham

Posted 4/3/2007 6:52:37 PM

Forum Newbie

Group: Forum Members
Last Login: 4/26/2007 6:35:00 PM
Posts: 1, Visits: 1

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

Sham

Post #7053

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 8:30pm