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

Give an idea of system variables.

1083


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

1428


what is the use of materialized view?

1629


What are the main differences you have observed between 7.x and 8.x version of datastage?

1129


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

2330


What a datastage macro?

1098


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)

2439


What is a ds designer?

1111


What is the flow of loading data into fact & dimensional tables?

1107


How do you register plug-ins?

991


Define orabulk and bcp stages?

1170


Differentiate between hash file and sequential file?

1120


On which Dimension Table you implemented SCD Type in your Project

2109


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3290


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3179