topic Replace only first space to a underscore in expression in QlikView

Replace only first space to a underscore in expression

Tue, 07 Apr 2015 23:45:17 GMT

Hi,

Replace only first space to a underscore in expression

this is urgent please reply

Re: Replace only first space to a underscore in expression

Gabriel — Tue, 07 Apr 2015 23:52:12 GMT

Hi,

Try this

=Replace('AB CDEFG',' ' ,'_')

The AB CDEFG could be filed name

Re: Replace only first space to a underscore in expression

robert_mika — Tue, 07 Apr 2015 23:57:42 GMT

=mid('mam ko ll --',1,index('mam ko ll --',' ')-1)&'_'&mid('mam ko ll --',index('mam ko ll --',' ')+1,len('mam ko ll --'))

Re: Replace only first space to a underscore in expression

Tue, 07 Apr 2015 23:58:07 GMT

Hi,

the String has more than one spaces but want to replace only the first one.

example:

'ab cd ef gh'

output required

'ab_cd ef gh'

Re: Replace only first space to a underscore in expression

Tue, 07 Apr 2015 23:59:21 GMT

can you please expalin this

Re: Replace only first space to a underscore in expression

robert_mika — Wed, 08 Apr 2015 00:04:14 GMT

I just added pictures but

You have got 3 part

the first mid takes all characters up to first space-- mid('mam ko ll --',1,index('mam ko ll --',' ')-1)

then you add underscore -----> &'_'&

and the second mid will add the rest of the string -> mid('mam ko ll --',index('mam ko ll --',' ')+1,len('mam ko ll --'))

Re: Replace only first space to a underscore in expression

robert_mika — Wed, 08 Apr 2015 00:08:04 GMT

Another way

=TextBetween('mam ko ll --','',' ',1)&'_'&TextBetween('mam ko ll --',' ','',1)

Re: Replace only first space to a underscore in expression

Anonymous — Wed, 08 Apr 2015 00:08:44 GMT

I hope it is simpler:

=subfield('ab cd ef gh', ' ',1) & '_' & mid('ab cd ef gh', len(subfield('ab cd ef gh', ' ',1))+1)

Re: Replace only first space to a underscore in expression

Wed, 08 Apr 2015 15:04:58 GMT

can you please tell me the same for the third Space.

Re: Replace only first space to a underscore in expression

Wed, 08 Apr 2015 15:05:33 GMT

can you please tell me the same for the third Space.

Re: Replace only first space to a underscore in expression

Anonymous — Wed, 08 Apr 2015 15:26:15 GMT

=left('ab cd ef gh',index('ab cd ef gh', ' ',3)-1)

& '_'

& mid('ab cd ef gh',index('ab cd ef gh', ' ',3)+1)

It should work with any - just replace this '3' with 1 or 2 and try

Re: Replace only first space to a underscore in expression

Wed, 08 Apr 2015 15:39:39 GMT

thanks