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

What are stage variables and constants?

1134


Define Job control?

1125


On which Dimension Table you implemented SCD Type in your Project

2014


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2042


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2491


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

912


Explain how a source file is populated?

1351


What are the partitioning techniques available in link partitioner?

2261


Triggers,VIEW,Procedures

1214


What is difference between join, merge and lookup stage?

1081


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2366


Differentiate between datastage and datastage tx?

1040


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2799


What is orabulk stage?

1032


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2089