将SQL表格数据格式化为文本表格 [英] Format SQL Table data as Text Table
本文介绍了将SQL表格数据格式化为文本表格的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
1 ChiPhíLươngFA_Phan_Bo_Chi_Phi_Luong 8 JOHN 8 2015(BLOB)FA_Phan_Bo_Chi_Phi_Luong_Final .csv 09-NOV-15ĐàHoànThành
2TổngHợpTimeSheetNhânViênFA_Tong_Hop_Timesheet 8 JOHN 8 2015(BLOB)FA_Tong_Hop_Timesheet_COM_Final.csv 09-NOV-15ĐàHoànThành
3TổngHợpDoanh Thu FA_Tong_Hop_Doanh_Thu 8 JOHN 8 2015(BLOB)FA_Tong_Hop_Doanh_Thu_Final.csv 09-NOV-15ĐàHoànThành
4 ChiPhíHoạtĐộngCôngTy FA_CP_Hoat_Dong 8 JOHN 8 2015(BLOB)FA_CP_Hoat_Dong_Final.csv 09-NOV-15ĐàHoànThành
5KhấuHaoMáyMócThiếtBịFA_CP_Khau_Hao_Phan_Bo_MMTB 8 JOHN 8 2015(BLOB)FA_CP_Khau_Hao_Phan_Bo_MMTB_Final.csv 09-NOV-15ĐãHoànThành
如何将文本格式化为具有相同列宽的表格?
决方案
您的文本sql结果:
+ --- + ------- ----------------------- + -------------------------- --- + --- + ------ + --- + ------ + -------- + -------- ------------------------ + ----------- ------------- + - +
| 1 | ChiPhíLương| FA_Phan_Bo_Chi_Phi_Luong | 8 | JOHN | 8 | 2015 | (BLOB)| FA_Phan_Bo_Chi_Phi_Luong_Final.csv | 09-NOV-15 | ĐãHoànThành|
+ --- + ------------------------------ + ---------- ------------------- + --- + ------ + --- + ------ + -------- + --------------------------------------- + --------- - + --------------- +
| 2 | TổngHợp时间表NhânViên| FA_Tong_Hop_Timesheet | 8 | JOHN | 8 | 2015 | (BLOB)| FA_Tong_Hop_Timesheet_COM_Final.csv | 09-NOV-15 | ĐãHoànThành|
+ --- + ------------------------------ + ---------- ------------------- + --- + ------ + --- + ------ + -------- + --------------------------------------- + --------- - + --------------- +
| 3 | TổngHợpDoanh Thu | FA_Tong_Hop_Doanh_Thu | 8 | JOHN | 8 | 2015 | (BLOB)| FA_Tong_Hop_Doanh_Thu_Final.csv | 09-NOV-15 | ĐãHoànThành|
+ --- + ------------------------------ + ---------- ------------------- + --- + ------ + --- + ------ + -------- + --------------------------------------- + --------- - + --------------- +
| 4 | ChiPhíHoạtĐộngCôngTy | FA_CP_Hoat_Dong | 8 | JOHN | 8 | 2015 | (BLOB)| FA_CP_Hoat_Dong_Final.csv | 09-NOV-15 | ĐãHoànThành|
+ --- + ------------------------------ + ---------- ------------------- + --- + ------ + --- + ------ + -------- + --------------------------------------- + --------- - + --------------- +
| 5 | KhấuHaoMáyMócThiếtBị| FA_CP_Khau_Hao_Phan_Bo_MMTB | 8 | JOHN | 8 | 2015 | (BLOB)| FA_CP_Khau_Hao_Phan_Bo_MMTB_Final.csv | 09-NOV-15 | ĐãHoànThành|
+ --- + ------------------------------ + ---------- ------------------- + --- + ------ + --- + ------ + -------- + --------------------------------------- + --------- - + --------------- +
您可以根据以下格式在表生成器中生成文本表。
您可以输入以下内容:
- 文件 - >粘贴表格数据中的SQL结果
- 文件 - >导入CSV文件
- 或者您可以手动生成表格
< p $>
不使用表格边界的Unicode符号
+ ---- + ------------- + -------- + ------- + - --- +
| id |名字|性别|状态|年龄|
+ ---- + ------------- + -------- + ------- + ----- +
| 1 |约翰·肯尼迪|男| | NY | 32 |
+ ---- + ------------- + -------- + ------- + ----- +
| 2 | Meresa奥斯陆|女| | HI | 26 |
+ ---- + ------------- + -------- + ------- + ----- +
| 3 | Mike Lanes |男| | FL | 25 |
+ ---- + ------------- + -------- + ------- + ----- +
对表格边框使用Unicode符号
╔═══════════════════════╦════════ b $ b║id║name║gender║state║age║
╠═════════════════════════════════ ═══════════════$ b $b║1║JohnKenedy║男║NY║32║$ b $b╠╠═══╬╬═══════════════ ╬═════════════════$ b $b║2║MeresaOslo║║║║║║║║║║b b b b b b bb║║║b bb╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬ ═════════════════════$ b║3║Mike Lanes║男║FL ║25║
╚═════════════════════ ════════════════
降价表
| id |名字|性别|状态|年龄|
| ---- | ------------- | -------- | ------- | ----- |
| 1 |约翰·肯尼迪|男| | NY | 32 |
| 2 | Meresa奥斯陆|女| | HI | 26 |
| 3 | Mike Lanes |男| | FL | 25 |
I have a result from Oracle database as below:
1 Chi Phí Lương FA_Phan_Bo_Chi_Phi_Luong 8 JOHN 8 2015 (BLOB) FA_Phan_Bo_Chi_Phi_Luong_Final.csv 09-NOV-15 Đã Hoàn Thành
2 Tổng Hợp TimeSheet Nhân Viên FA_Tong_Hop_Timesheet 8 JOHN 8 2015 (BLOB) FA_Tong_Hop_Timesheet_COM_Final.csv 09-NOV-15 Đã Hoàn Thành
3 Tổng Hợp Doanh Thu FA_Tong_Hop_Doanh_Thu 8 JOHN 8 2015 (BLOB) FA_Tong_Hop_Doanh_Thu_Final.csv 09-NOV-15 Đã Hoàn Thành
4 Chi Phí Hoạt Động Công Ty FA_CP_Hoat_Dong 8 JOHN 8 2015 (BLOB) FA_CP_Hoat_Dong_Final.csv 09-NOV-15 Đã Hoàn Thành
5 Khấu Hao Máy Móc Thiết Bị FA_CP_Khau_Hao_Phan_Bo_MMTB 8 JOHN 8 2015 (BLOB) FA_CP_Khau_Hao_Phan_Bo_MMTB_Final.csv 09-NOV-15 Đã Hoàn Thành
How can I format text as a table with the same width of column?
解决方案
Your text sql result:
+---+------------------------------+-----------------------------+---+------+---+------+--------+---------------------------------------+-----------+---------------+
| 1 | Chi Phí Lương | FA_Phan_Bo_Chi_Phi_Luong | 8 | JOHN | 8 | 2015 | (BLOB) | FA_Phan_Bo_Chi_Phi_Luong_Final.csv | 09-NOV-15 | Đã Hoàn Thành |
+---+------------------------------+-----------------------------+---+------+---+------+--------+---------------------------------------+-----------+---------------+
| 2 | Tổng Hợp TimeSheet Nhân Viên | FA_Tong_Hop_Timesheet | 8 | JOHN | 8 | 2015 | (BLOB) | FA_Tong_Hop_Timesheet_COM_Final.csv | 09-NOV-15 | Đã Hoàn Thành |
+---+------------------------------+-----------------------------+---+------+---+------+--------+---------------------------------------+-----------+---------------+
| 3 | Tổng Hợp Doanh Thu | FA_Tong_Hop_Doanh_Thu | 8 | JOHN | 8 | 2015 | (BLOB) | FA_Tong_Hop_Doanh_Thu_Final.csv | 09-NOV-15 | Đã Hoàn Thành |
+---+------------------------------+-----------------------------+---+------+---+------+--------+---------------------------------------+-----------+---------------+
| 4 | Chi Phí Hoạt Động Công Ty | FA_CP_Hoat_Dong | 8 | JOHN | 8 | 2015 | (BLOB) | FA_CP_Hoat_Dong_Final.csv | 09-NOV-15 | Đã Hoàn Thành |
+---+------------------------------+-----------------------------+---+------+---+------+--------+---------------------------------------+-----------+---------------+
| 5 | Khấu Hao Máy Móc Thiết Bị | FA_CP_Khau_Hao_Phan_Bo_MMTB | 8 | JOHN | 8 | 2015 | (BLOB) | FA_CP_Khau_Hao_Phan_Bo_MMTB_Final.csv | 09-NOV-15 | Đã Hoàn Thành |
+---+------------------------------+-----------------------------+---+------+---+------+--------+---------------------------------------+-----------+---------------+
You can generate text tables at tablesgenerator like following formats.
You can give input as:
- SQL result in File -> Paste Table Data
- File -> Import CSV File
- Or you can generate table manually
Here you can align column values to left, right, centre.
Without Using Unicode symbols for table borders
+----+-------------+--------+-------+-----+
| id | name | gender | state | age |
+----+-------------+--------+-------+-----+
| 1 | John Kenedy | male | NY | 32 |
+----+-------------+--------+-------+-----+
| 2 | Meresa Oslo | female | HI | 26 |
+----+-------------+--------+-------+-----+
| 3 | Mike Lanes | male | FL | 25 |
+----+-------------+--------+-------+-----+
Useing Unicode symbols for table borders
╔════╦═════════════╦════════╦═══════╦═════╗
║ id ║ name ║ gender ║ state ║ age ║
╠════╬═════════════╬════════╬═══════╬═════╣
║ 1 ║ John Kenedy ║ male ║ NY ║ 32 ║
╠════╬═════════════╬════════╬═══════╬═════╣
║ 2 ║ Meresa Oslo ║ female ║ HI ║ 26 ║
╠════╬═════════════╬════════╬═══════╬═════╣
║ 3 ║ Mike Lanes ║ male ║ FL ║ 25 ║
╚════╩═════════════╩════════╩═══════╩═════╝
Markdown table
| id | name | gender | state | age |
|----|-------------|--------|-------|-----|
| 1 | John Kenedy | male | NY | 32 |
| 2 | Meresa Oslo | female | HI | 26 |
| 3 | Mike Lanes | male | FL | 25 |
这篇关于将SQL表格数据格式化为文本表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文