It's not straightforward, but it can be done.
Archive of posts tagged awk
“Range of fields” in awk
This is asked very often, and the solution isn't always obvious (if at all).
Three text processing tasks
Unlikely to help someone, but anyway.
Pulling out strings
Some ways to "pull out" strings from files
Argument juggling with awk
How to pass extra stuff without awk noticing