topic How to add space between text value? in App Development

How to add space between text value?

MuraliPrasath — Mon, 19 Dec 2022 05:29:56 GMT

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 — Mon, 19 Dec 2022 07:07:46 GMT

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 — Mon, 19 Dec 2022 09:57:55 GMT

Thank you Vegar 🙂

MuraliPrasath — Tue, 20 Dec 2022 14:15:07 GMT

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 — Tue, 20 Dec 2022 21:25:11 GMT

You could try this:

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