Hello all,
I am struck with a problem. I have defined a formulae to TextInput Scan_Scanner.Value it returns a value after scanning as
00160099;26.07.2020 02:48;J.Vollendorf T#: DW2438;000914812223;91465903;0005918841;n.a.;n.a.;81669628;0209028880
Now for another text input i wanted only a specific value of the scanner value eg i need only the number 81669628
How can i do this .? It would be very useful if you can help me. I tried Last(FirstN( Scan_Scanner.Value , 5)) , but it didnt work.
Thanks
Solved! Go to Solution.
Hi @Gunayathi
This should give you the result you need:
Last(
FirstN(Split( Scan_Scanner.Value, ";").Result, 9)).Result
Hi @Gunayathi
This should give you the result you need:
Last(
FirstN(Split( Scan_Scanner.Value, ";").Result, 9)).Result
User | Count |
---|---|
211 | |
94 | |
84 | |
50 | |
38 |
User | Count |
---|---|
270 | |
104 | |
102 | |
59 | |
59 |