luke.bourke
New member
- Local time
- Today, 13:07
- Joined
- Apr 22, 2011
- Messages
- 3
Hi, I would like to know how to take the first character from one field as the character to show for a new field that has a text string and then the second and third characters of that same one field as the two characters to show in the new field's text string.
For example, if I have a field named Player that has something like A03456565656 for the values and I want to make a new field called Tag that reads for its values: First Authorization: A Second Authorization: 03. How would I build the expression in expression builder or manually in the query field name so that it returns that result?
For example, if I have a field named Player that has something like A03456565656 for the values and I want to make a new field called Tag that reads for its values: First Authorization: A Second Authorization: 03. How would I build the expression in expression builder or manually in the query field name so that it returns that result?