Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

col1
123
abc
234
def
jkl
768
opq
567
789

but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like

trg1
123
234
768
567
789

trg2
abc
def
jkl
opq

Answer Posted / prasad

hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sequencers?

1172


Is the value of staging variable stored temporarily or permanently?

1054


What is the difference between account and directory options ?

1234


Differentiate between datastage and informatica?

1250


What is size of a transaction and an array means in a datastage?

1366


What is difference between server jobs & parallel jobs?

1089


What are the types of containers in datastage?

1226


How to manage date conversion in Datastage?

1183


What is the sortmerge collector?

1176


what is ds administrator used for?

1219


What is a datastage job?

1055


What is a merge?

1240


Nls stands for what in datastage?

1236


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2665


What is ibm datastage?

1022