You can use Excel functions: 1. to get sub strings of what you need, and then 2. to concatenate those sub strings to one single string.
this looks interesting, what package would i need to make this command line work? i see there are plenty packages and im asuming i only need one?
thank you. how exactly do i make a call to gawk from the cmd window ? i do need to point to the directory ? i have been able to find alot information and tutorials about gawk but what they dont tell you is how to install gawk on windows
figured it all out, how come i never came across this before. shows what kind of a noob i realy am. thank you guys for the help here, its apreciated
There's a lot of unix based tools that will make your life a lot easier if you put in a bit of effort. I'd recommend installing it inside a VM and playing with it if you have some free time.