left function

[Anonymous]

Hi,

How is it possible to load values of some field on the backfront so that only the first 3 symbols could be loaded?

Thank you in advance,

Larisa

[sunny_talwar · Accepted solution]

May be this:

Left(YourFieldName, 3)

[MK_QSL]

You mean

Load(FieldName,3) as NewFieldName

My Mistake:

Updated:

Left(FieldName,3) as NewFieldName

[petter]

FIRST 3 LOAD

*

FROM xyz.txt (txt);

Load the first 3 rows of the source