View Single Post
 
Old 01-18-2019, 09:54 AM
samirahmed007 samirahmed007 is offline Windows 7 32bit Office 2016
Novice
 
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, 6 views)
File Type: zip Output.zip (3.1 KB, 6 views)
Reply With Quote