topic Re: if (first space), then someting. in QlikView

if (first space), then someting.

retko1985 — Wed, 25 Nov 2020 16:16:04 GMT

How do I find first space in my string and replace it with something else.

Thank you.

sunny_talwar — Fri, 05 Jan 2018 13:27:04 GMT

May be this

Replace(String, ' ', '@')

tresB — Fri, 05 Jan 2018 13:30:33 GMT

May be like:

=SubField(String, ' ',1) & 'ReplaceString' & Mid(String,Index(String,' ')+1)

However, an easier solution could be there. If hits, would let know.

zebhashmi — Fri, 05 Jan 2018 13:30:35 GMT

if (left(string,1)=" ",then

Anil_Babu_Samineni — Fri, 05 Jan 2018 13:32:29 GMT

Seems, Working this?

=SubField('Sa mpl e', ' ',1) & 'WEE' & Mid('Sa mpl e',Index('Sa mpl e',' ')+1)

Peter_Cammaert — Fri, 05 Jan 2018 16:18:42 GMT

From the array of possible solutions, here's another one:

=Left(String, Index(String, ' ')-1) & 'Substitute' & Right(String, Len(String)-Index(String, ' '))

Probably the only bonus is that this expression uses Left() for the left part, and Right() for the right part

If you prefer to first check for the occurrence of a space, you may want to do it like this:

=IF (Index(String, ' ') = 0,

String,

Left(String,Index(String,' ')-1) & 'Substitute' & Right(String,Len(String)-Index(String,' ')))