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

To see hidden files in LINIX?

0 Answers   CTS,


In merge stage can we update the values?

3 Answers   TCS,


How to remove blank spaces from data?

3 Answers  


Name the different types of Lookups in Datastage?

0 Answers  


Explain datastage architecture?

0 Answers  






how to create document in datastage?

1 Answers   Cap Gemini,


source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,


How to Convert the columns into rows?

2 Answers  


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

0 Answers  


What is active and passive stage?

0 Answers  


table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  


how CAN we remove duplicates in dataset?

2 Answers   IBM,


Categories