Search Results

zaxxon..

i went with your suggestion and it worked great...

but the more i dug into the data, the more i saw how crappy it was..

lots of leading and trailing whitespace on most of the...

thanks zaxxon..

ill tinker around with your second idea today

much appreciated

ladies and gents..

im trying to do a surgical search and replace though a 3 GB file;

any timestamp fields that are spaces need to be changed to null
any numerics that are spaces need to be...

thanks much... the number of fields and output file separators seems to be what i was missing.. life is easier now.

works great.. thanks

ob

ladies, gents..


say i have a file that should have 10 fields... (9 delimiters)

some records have 10 fields, some have 5 some have 8, etc.. nothing consistent, but i need my file to have 9...