Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do i keep the first character of a field in the load script?
I only want to keep the "A" from "AJDKOPDKPDKP"
Thanks
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.