on 09-27-2017 1:37 PM
Hello,
in another thread I asked similar thing 'How to get element from Array'
and the Solution is via UBound , but Ubound returns Number only
How get into variable Text element/index from Array?
Thank You
I have used your text from original post and both the formula below work
If Ubound(split('F1E|I21|R|4|30|50|180|35|BG340SR|S10|D11|T10|1P|PVC|PZS-Z25|HS|/|F11|R20|K7035|T7035|/|SNAL|/,|/,/|TOB,S|H,2|/|VZKT|VZKT|SD|','|')) >= 2 then split('F1E|I21|R|4|30|50|180|35|BG340SR|S10|D11|T10|1P|PVC|PZS-Z25|HS|/|F11|R20|K7035|T7035|/|SNAL|/,|/,/|TOB,S|H,2|/|VZKT|VZKT|SD|','|')[2]
or without Ubound
split('F1E|I21|R|4|30|50|180|35|BG340SR|S10|D11|T10|1P|PVC|PZS-Z25|HS|/|F11|R20|K7035|T7035|/|SNAL|/,|/,/|TOB,S|H,2|/|VZKT|VZKT|SD|','|')[2]
Both return element 2
I21
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try
split({originalTextfield},'|')[2]
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found it:
Global StringVar Design ;
If UBound(myString)>=2
Then Design:= ToText(myString[2]);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.