This tutorial is going to show you how to export Excel data to a pipe delimited text file
In this tutorial you are going to learn how to export data from excel to pipe delimited text file.
Step # 1 — Opening Region and Language Settings
Close Excel if you have the program open. Click “Start” and then click “Control Panel”. In the window that appears you need to click on the “Region and Language” option. At the bottom of this new window click on the “Additional settings…” button.
Step # 2 — Changing the Default List Separator
This will open the “Customize Format” window. Locate the “List separator” box and replace the comma with the pipe symbol. Click “OK” and then “OK” again in the previous window. Now you need to open the Excel file that you want to export.
Step # 3 — Saving the File
Once the file has loaded click the “File” option in the main menu and then click on the “Save As” option. In the window that opens click on the drop down box next to “Save as type”, and from this list you need to select the option “CSV (Comma delimited)”. Click on the “Save” button, and in the dialog box that appears click “OK”.
Step # 4 — Opening the File with Notepad
This is how to export data from excel to pipe delimited text file, and to view the file in Notepad go to where it is located, right click on it, navigate to “Open with” and click “Notepad”. As you can see all the bits of data from the file are separated with the pipe delimiter.
For more interesting updates Please subscribe My Channel
🌐 Facebook :
🌐 Twitter :
🌐 Google+ :
🌐 Instagram :
🔊 LIKE ➡ SHARE ➡ SUBSCRIBE
YouTube Tips And Tricks Playlist :
How to Make Money Online Playlist :
Windows 10 Tips And Tricks Playlist :
Common Tutorials Playlist :
Mobile Tips And Tricks Playlist :
Photoshop Tutorial Playlist :
Facebook Tips And Tricks Playlist :
My Channel is The best & ultimate technology platform for Bangladeshi tech peoples in Bangla language. You can get lots of technology news, android tips, review, photo editing, unboxing, computer tricks & tips, mobile tricks and more.
note: all the image picture shown in the video belongs to the respected owner and not me. i am not the owner of any pictures showed in the video.
DISCLAIMER: This Channel Does Not Promoted Any Illegal Content, All Content Provided By This Channel Is Meant For EDUCATIONAL purposes Only.
Xem thêm bài viết khác: https://androidsvn.com/lap-trinh-php/
Xem thêm Bài Viết:
- Tự học Linux – LPI 1 [Part 1/4] – Tổng quan về Linux và các lệnh cơ bản
- Lập trình viên – Học lập trình web ra làm gì? Cách kiếm tiền từ nghề lập trình web bạn cần biết
- BÀI BÁO BỊ XÓA: Cháy nhà máy Rạng Đông hậu quả tương đương 1 quả bom nguyên tử
- #8 Lộ diện cao nhân cảm âm "nghe tiếng đàn định giới tính" | SIÊU TRÍ TUỆ VIỆT NAM
- Login system using PHP with MYSQL database