Substring

[#1]

Need to pull text from a text filed in specific position. For Example, I would like to select the first position from field 1 where the text in the filed is 10 positions and it's content look like: ABBPTZZZZZ

I only want to select the "A"

Thanx

[disqr_rm]

You can use left(FieldName, 1) and load it as new field name.

[#3]

Thank you for the quick reply. It almost answers my issue. What is the syntax to substring out other positions not just the first, for Example if I want to select the fifth position?

[Miguel_Angel_Baeyens]

Hello,

Mid() will do:

Mid('ABCDEF', 2, 3) // "BCD" starting on 2, 3 chars.

Hope that helps.