Having the 5th character in a label Always - or a _

[Anonymous]

Hello!

I basically want someone to type this as example:

18013-13_0009

Now basically when someone typed 18013 I want the - to come up automatically. This will always be in the same order. The 6th character will always be a - and the 9th character will always be a _

How can i do this?

[eka24]

Change the Right 4 to 5 as follows:

If(!IsBlank(DataCardValue22.Text),
Concatenate(Left(DataCardValue22.Text,5),"-",
Mid(DataCardValue22.Text,6,2),"-",Right(DataCardValue22.Text,5))," ")

[Anonymous]

Sorry but what does this change? This only makes it so the last numbers will the 5 long instead of 4? Is it possible to just have this done in one textbox? And when you type 5 numbers the - will come straight away?

So if you type: 12345 there will automatically be a - added to it. 

So when you type 1234567 it should automatically add a - between the 5 and 6; 12345-67 then after these 2 numbers another - and then 4 more numbers after that. 

End result: only typing 12345678910 and in the same textbox it should be: 12345-67-8910 

@eka24 

[eka24 · Accepted solution]

I have added trim function:

If(!IsBlank(DataCardValue22.Text),

Concatenate(Left(Trim(DataCardValue22.Text),5),"-",

Mid(Trim(DataCardValue22.Text),6,2),"-",
Right(Trim(DataCardValue22.Text),4))," ")

Test it and give feedback

[eka24]

Attached

[Anonymous]

Hello @eka24 

Thanks for your answer. This all works like it should be, but this is not exactly what I'm looking for. 

This is what I want:

https://gyazo.com/b2299b05e460f0eaf8bb0fd6b6e47de1

Like let's say I only type the first 5 numbers. I want then automatically an - added behind it. All of this in the same textbox. then after I typed another 2 numbers I want another - to be added. Hope this makes it more clear.

[WarrenBelz]

Please disregard - wrong thread

[Anonymous]

@eka24 Could you answer me please?

[Anonymous]

What do you mean ? @WarrenBelz there is still no solution😕

[eka24]

Please I don't have the solution to doing your request in the same textbox. if it is another textbox, then apply my earlier post.

thank you

[WarrenBelz]

Hi @Anonymous ,
I can get this to appear after the user hits enter (probably not your preferred option) OnChange of CodeBox

UpdateContext(
   {vText:
      Left(CodeBox.Text,4) & "-" & 
      Mid(CodeBox.Text,6,2) & "_" & 
      Right(CodeBox.Text,4)
   }
);
Reset(CodeBox)

Default of CodeBox  -  vText
MaxLength of CodeBox - 12
Second option you might like - see below.
Four text boxes - three visible and one hidden if you want (which is the one to be written to the data).

Settings - I have called the boxes Code1, Code2, Code3 and FullCode for the bottom one
Default of FullCode

Code1 & If(!IsBlank(Code2),"-") & Code2 & If(!IsBlank(Code3),"_") & Code3

MaxLength of the three boxes - 4, 2 and 4
TabIndex of the three boxes 1, 2 and 3 (you will have to make sure this fits with other elements on the screen).
OnChange of all three boxes

Reset(FullCode)

So as per the video, the user types in the first one and numbers start appearing and stop them typing at the fourth. press the tab and the moment a character appears in the second box, the "-" appears in between in the bottom box. The same happens with the next transition.
I don't believe it is possible to do what you want exactly as your cannot reset a control from itself until the end of the data input.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.