Search word

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

Search word

Post by subrat »

Can you suggest any idea on below requirement

The below criteria/keyword i want to search from a text field/column coming from source.

1)C/O
2)C / O
3)C.O


1)COMPANY
2)C O M P A N Y
3)C.O.M.P.A.N.Y

-I want to find out all records where any of these combination would be there.
-Both key word should be adjeacent to each other.
-Combination should include upper or lower case.

any idea how to make a efficient way to deal with
Last edited by subrat on Wed Aug 24, 2011 1:00 am, edited 1 time in total.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Search word

Post by SURA »

Only these combinations or more ?

DS User
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

Re: Search word

Post by subrat »

There are many simmilar combination. But to get a efficient idea related to above comination would more then enough to progress on rest.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

QualityStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply