You could possibly use a regex pick out the specific character field and check if its, say, ‘F’, to determine the sex (presumably if its not ‘F’ then it must be ‘M’?..)
However, it is probably more generally useful to extract specific fields in the ‘@’ delimited string - in this case you want the 4th - which you can do using (sub) string functions. Have a play with this:
substring.xlsx (14.4 KB)
Note, if all the fields are actually fixed width, then you can simplify this expression a lot to extract the specific nth-index character itself, using substr().
