Identify character in a string

[qvqfqlik]

I am trying to to identify a  character in a string

eg: SXOWERF, STOFGHJK

for the example strings, I am trying to identify if the 2nd character in them is/is not 'X' or 'T'.

Please help me with this

[sunny_talwar]

May be like this:

If(Match(Mid(FieldName, 2, 1), 'X', 'T'), 'Matched X or T', 'Did not Match X or T')

[sunny_talwar]

Here is a screenshot

You can replace True and False statements based on your requirement.

Best,

Sunny

[qvqfqlik]

I am trying to exclude all such strings with 2nd charater 'X','T'  from the Field values. How to achieve this?

[sunny_talwar]

In the script, you can do this:

LOAD *

FROM ...

WHERE Match(Mid(FieldName, 2, 1), 'X', 'T') = 0;

[saimahasan]

You can use

if(Match(Mid(FieldName, 2, 1), 'X', 'T'),null(),FieldName)