Cut substring from a field?

[marcde...@gmail.com]

Is it possible to cut a substring from a field,
e.g. substring 1 to 3 from field 2?

Please excuse if the answer is listed in the
help file, I haven't read every topic yet.

Thank you.

[Neil Butterworth]

Yes, use the  substr() function in the expression language with commands like eval. See http://neilb.bitbucket.org/csvfix/manual/csvfix16/ExpressionLanguage.html

In your case this would be the call to use:

         substr( $2, 1, 3 )

[marcde...@gmail.com]

Hi Neil,

great, thank you very much. I have done it successfully with csvfix eval -e "substr($2,1,3)"

Regards,
Marc