How do i keep the first character of a field in the load script?
I only want to keep the "A" from "AJDKOPDKPDKP"
Try Left(FieldName, 1) as NewField,
Update: and try not to create multiple discussion for the same requirement.
Use the function keepchar. EX:
KeepChar(FieldName, 'a') as NewField
Ah never mind, read the requirement wrong. Yes as Sunny recommends use the Left function.
Retrieving data ...