Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!