Copy and paste query results in text document and remove Tabs 1

[DrSmyth]

Hi,

I've written a query that I need to distribute the results of in a text file with no tabs.

My current process is to run the query, copy and past it into anotepad and then remove all of the Tabs.

Trouble is I now have over 3000 lines of data and I don't want to manually remove all of the TABS from the text document (would take too long)

Anybody know a way around this??

 

[Crowley16]

export it as a csv and use something else as delimiter, maybe the old "," perhaps?

--------------------
Procrastinate Now!

 

[dhookom]

Can't you use Edit->Replace in Notepad? You might need to first find and copy a "tab" into your clipboard and then paste it into the "Find What".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[DrSmyth]

Cheers Crawley, works like a dream. dhookom, didn't try your technique, sounds logicalthough..

Cheers gents