Replace only first space to a underscore in expression

[#1]

Hi,

Replace only first space to a underscore in expression

this is urgent please reply

[Gabriel]

Hi,

Try this

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

The AB CDEFG could be filed name

[robert_mika]

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

[#4]

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'

[#5]

can you please expalin this

[robert_mika · Accepted solution]

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  --'))

[robert_mika]

Another way

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

[Anonymous]

I hope it is simpler:

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

[#9]

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

[#10]

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