Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

How to remove spaces in middle of the Field ?

Hi experts

I want to remove the spaces in middle of the field values.

I am attaching the sample excel file and Application

Thanks

Madhu

16 Replies
sasiparupudi1
Master III
Master III

Please see the attached app

Untitled.jpg

madhubabum
Creator
Creator
Author

HI Sasidhar

Thanks a lot

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

PFA....

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

if we use this Exp : Replace(Description,'  ','')  as NewDescription

The sentence is Not proper to read .

Use SasiParupudi1

Expression

adang
Contributor III
Contributor III

This solution is genius! Thank you so much @MK_QSL !

Unlike using the replace function. This MapSubString function would replace however the space duplicated in the string with just one space. Which it'd be a massive nested If statement if I use replace to achieve the same thing.

JuanManuelLopezFelizzola
Contributor III
Contributor III

This is so overkill taking it all the way to 125, but even after 5 years of this post, I gotta give it to you, it is an elegant solution, and I like elegant.

 

Cheers

Juan Manuel Lopez Felizzola
wigchert
Partner - Contributor II
Partner - Contributor II

Brilliant solution, thnx!