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 |
---|---|
196 | |
125 | |
88 | |
49 | |
42 |
User | Count |
---|---|
285 | |
162 | |
138 | |
76 | |
73 |