How to: Create a pipe delimited file

Last month I received the following question:
I need to know how to convert an excel file into a pipe delimited file using the ASAP software.

You can use the following tool to do this:
ASAP Utilities » Export » Export selection or active sheet as new file...

Then choose "CSV (comma separated value) or customer separated" and specify the pipe-character (|) as delimiter:Create a pipe-delimited text file

Of course you can use with any character to create a specific separated kind of text file.

3 comments

Kanwaljit

Hi Bastien,

May the Couple Live 1000 years !

Wish !
Wish to delete only text boxes, but the "Delete all objects on the Selected worksheet" delete all the objects. Is it possible to select which objects to delete and which to keep ( Some Advanced options to do this ) ?

Sincere Regards
Kanwaljit

Kanwaljit

Hi Bastien,

May the Couple Live 1000 years !

Asap->8.Text Utilities->15. Remove Ending carriage return is not working. I have sent you a sample file.

Sincere Regards
Kanwaljit

Bastien

Hello Kanwaljit,

Thank you for your feedback.

To remove only the text boxes is indeed not possible at this moment.
Since there are many, many different kind of objects and it has never been asked before, I haven't created an option to choose which kind of objects to remove. If I have some time left I will write you a custom macro to do this.

The "Remove ending carriage return (alt+enter character)" utility only removes the line breaks at the end of the cell values. Not the line breaks in between. I have just wrote the following article to show you how you can remove all line breaks:
//www.asap-utilities.com/blog/index.php/2010/01/18/how-to-remove-replace-line-breaks-carrage-returns-in-cells/

Kind regards,
Bastien