So you did NOT add any spaces to try to line things up? I ask because the alignment of the right most column has flaws in it. I have to make sure of the format in order to make this easy for both of us. 😉 Is there any way that you could email an actual, untouched file to me with the understanding that I will not expose the content to anyone or anything else and will destroy the file as soon as I've solved your problem?
Hi Jeff,
1.no spaces added, file has original alignment.
2.I can't send original file (comp. policy)
3.Since we trying to create script that will be called 500 times (once for each server) ) daily I can't rely on exact alignment of the column,
output will always produce 4 columns, column1 and column2 might or might not contain values but "delimiter" will be same all the time
Thank you
Got it... and figured so on #2 but had to ask. So there aren't just 2 leading spaces on these things... it's more like printed output than delimited output. That's a pretty simple substring job with the understanding that the starting position of each column can change but can also be easily derived from the first line in the file.
I'll be back.