How to remove blank spaces from data?

Answers were Sorted based on User's Feedback



How to remove blank spaces from data?..

Answer / vennapusa

sed 's/' '//g ' sample

Is This Answer Correct ?    4 Yes 0 No

How to remove blank spaces from data?..

Answer / 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

How to remove blank spaces from data?..

Answer / bharath

By using the following command you can remove blank lines from unix file:

$ sed 's/ *//g' sample

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Data Stage Interview Questions

What are the various kinds of the hash file?

0 Answers  


Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,


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

9 Answers   Patni,


SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,


What are the types of containers in datastage?

0 Answers  






What is ibm datastage?

0 Answers  


file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,


sed,awk,head

0 Answers   CTS,


Explain ibm infosphere information server and highlight its main features?

0 Answers  


how many types of remove the duplicate records?

3 Answers   Caterpillar,


my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  


Can you explain link buffering?

0 Answers  


Categories