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

How to remove blank spaces from data?

Answer Posted / shar

sed 's/' '//g ' sample
Or
Other way:(just in case)

In Transformer we can use function : CompactWhiteSpace(%string%)
Through which we can remove spaces.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Different ways a project can be moved to production ?...example ….export-import and Version control.

2446


What is the use of hoursfromtime() function in transformer stage in datastage?

1068


What is ds designer?

1103


Is the value of staging variable stored temporarily or permanently?

998


How you Implemented SCD Type 1 & Type 2 in your project?

4129


Describe link sort?

1011


What are the partitioning techniques available in link partitioner?

2278


What is the purpose of pivot stage and types of containers in datastage

1037


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2730


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1387


Define Routines and their types?

1185


How many areas for files does datastage have?

1152


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224