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...

i want anser this question empno,ename,sal 12,mmm_ww,200
13,nnn_xx,300 14,bbb_qq,400 which stages are take which
types of logicks are doing pls help me i don't need "_"ex
nnnxx this type i want

Answer Posted / roshan nayak

To achieve this use "Convert" function.
ex - Convert('+-_()?','',NullToEmpty(Input_link))

this will convert "_" or any of the specify special
char-rector with empty string.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a quality stage in datastage tool?

1076


Is it possible to query a hash file?

2012


why do u need the IOS upgradation in a FC switch

2282


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1380


Define APT_CONFIG in Datastage?

1080


Can you explain players in datastage?

1199


Is possible to create skid in dim,fact tables?

2636


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2294


Differentiate between Join, Merge and Lookup stage?

1093


how to add a new records into source?

2000


In Datastage, how you can fix the truncated data error?

1161


project Steps,hits, Project level HArd things,Solved methods?

2132


What is a merge?

1169


Can you explain kafka connector?

1312


What is staging variable?

1092