How to add space between text value?

[MuraliPrasath]

Hi Qlik,

I need to add space between the text value before the numbers. so that I can search the number without * in the field.

Need help with this. Thanks!

example (employee name with a number)  field value: 

Almnz-Michli, LeelIvan-88779

Expected field value:

Almnz-Michli, LeelIvan- 88779

[Vegar · Accepted solution]

I assume you have some kind of pattern in your string.

My best guess by looking at your example is that the number comes after the last  '-' sign. If that is the case then you can do like this.

Mid(Textfield, 1, index(Textfield,'-',-1)) & ' ' & subfield (Textfield, '-', -1)

[MuraliPrasath]

Thank you Vegar 🙂

[MuraliPrasath]

Hi Vegar,

I got the space after the '-' now. How to get the space before the '-' also like below.

Example:  Almnz-Michli, LeelIvan - 88779

[Vegar]

You could try this:

=Mid(Textfield, 1, index(Textfield,'-',-1)-2) & ' - ' & subfield (Textfield, '-', -1)