Microsoft Office Forums Converting into a fixed column width table with data alignment&table length under 72  colums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2019, 09:54 AM
samirahmed007 samirahmed007 is offline Converting into a fixed column width table with data alignment&table length under 72  colums Windows 7 32bit Converting into a fixed column width table with data alignment&table length under 72  colums Office 2016
Novice
Converting into a fixed column width table with data alignment&table length under 72  colums
 
Join Date: Jan 2019
Posts: 1
samirahmed007 is on a distinguished road
Default Converting into a fixed column width table with data alignment&table length under 72 colums

Hi everyone

I have to convert xlsx/csv/txt file into a fixed column width table with data alignment and table split over 72 columns.
The input files may be in 3 different types like (.xlsx/.csv/.txt).
That's what I have attached 3 different types of input files [input.xlsx/input.csv/input.txt (any one can be used according to convenience)]
and 2 different output (1_output_with_align.txt and 2_output_with_align_with_split_table_under_72_colu mn.txt).

Output file should be meet bellow criteria:

  1. Table column align with decimal characters, if there is text in table cell that text should be in left align and only numeric characters always be in right align.
  2. All table's width should be maximum 72 columns in length like our output text file (2_output_with_align_with_split_table_under_72_col umn.txt).
  3. If the table is more than 72 column then split extra part of table with common heads and common columns from the beginning.
  4. Distance between any two columns should be 2 spaces maximum.
  5. Table header and table body should be separated with a blank line.


    Please help me..........

Attached Files
File Type: zip Input.zip (11.9 KB, 0 views)
File Type: zip Output.zip (3.1 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table column width wrong - unless macro paused!? Kebap Word VBA 7 09-21-2018 03:14 PM
Converting into a fixed column width table with data alignment&table length under 72  colums how to set column width fixed in all similar documents blackice Word 6 07-14-2014 11:36 AM
create fields with multiple lines - fix column width in table expert4knowledge Word 4 02-14-2014 01:06 PM
Merge only the text in a table and keep the 2 original colums of a table james1979uk Word Tables 5 12-15-2013 05:48 PM
Converting into a fixed column width table with data alignment&table length under 72  colums Word 2012: Change column width changes table width OpfinnarJocke Word Tables 1 09-22-2012 04:03 AM


All times are GMT -7. The time now is 09:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft