Sponsored Content
Top Forums Shell Programming and Scripting Converting csv file to flat file Post 303023608 by rohit_shinez on Wednesday 19th of September 2018 11:47:21 PM
Old 09-20-2018
Converting csv file to flat file

Hi All,

I have a csv file which is comma seperated. I need to convert to flat file with preferred column length

Code:
country,id
Australia,1234
Africa,12399999

Expected output
Code:
country id
Australia 1234
Africa 12399999

the flat file should predefined length on respective columns. Here country - 1- 20 , id - 21-30
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Pivot file to flat file

I have a file in this format. P1 P2 P3......................... A001 v11 v21 v31...................... A002 v12 v22 v32............................ A003 v13 v23 v33.......................... A004 v14 v24 v34.............................. . . . A00n... (2 Replies)
Discussion started by: vskr72
2 Replies

2. Shell Programming and Scripting

Awk to convert a flat file to CSV file

Hi , I have a file with contents as below: Contract Cancellation Report UARCNCL LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY ========= ======= ==== ==== ==== ========= ==== ==== 8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN 8678696 8091709 1S NONE DDEB 30-JUN-2008... (14 Replies)
Discussion started by: rkumudha
14 Replies

3. Shell Programming and Scripting

Converting Column to Rows in a Flat file

Hi, Request To guide me in writing a shell program for the following requirement: Example:if the Input File contains the follwing data Input File Data: 80723240029,12,323,443,88,98,7,98,67,87 80723240030,12,56,6,,,3,12,56,6,7,2,3,12,56,6,7,2,3,88,98,7,98,67,87... (5 Replies)
Discussion started by: srinikal
5 Replies

4. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies

5. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies

6. UNIX for Dummies Questions & Answers

cleaning up spaces from fixed width file while converting to csv file

Open to a sed/awk/or perl alternative so that i can stick command into my bash script. This is a problem I resolve using a combination of cut commands - but that is getting convoluted. So would really appreciate it if someone could provide a better solution which basically replaces all... (3 Replies)
Discussion started by: svn
3 Replies

7. Shell Programming and Scripting

Converting a flat file in XML

Hello Friends, I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file. Flat file: (Input File entries looks like this) John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600 The... (4 Replies)
Discussion started by: humkhn
4 Replies

8. UNIX for Advanced & Expert Users

Converting the date format in a flat file

Hi All, I am new to this forum, could any one help me out in resolving the below issue. Input of the flat file contains several lines of text for example find below: 5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2 5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1... (0 Replies)
Discussion started by: av_sagar
0 Replies

9. Shell Programming and Scripting

Help with converting XML to Flat file

Hi Friends, I want to convert a XML file to flat file. Sample I/p: <?xml version='1.0' encoding='UTF-8' ?> <DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen .xsd'> <Contact... (3 Replies)
Discussion started by: karumudi7
3 Replies

10. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies
APT-SPY.CONF(5) 						File Formats Manual						   APT-SPY.CONF(5)

NAME
apt-spy.conf - configuration file for apt-spy(8) DESCRIPTION
apt-spy.conf is the configuration file for apt-spy(8). It consists of a series of area labels, followed by a list of countries belonging to that label. Whitespace is ignored. Comments may be added anywhere, and begin with the hash ('#') character. Once a hash character is encountered, the rest of the line is ignored. A label consists of any alphanumeric characters, and ends with a colon character (':'). The label must be on a line by itself (excluding comments). Following a label are a list of country codes (one per line) of countries belonging to that label. Each country has a unique two-letter country code corresponding to its top level domain identifier. This is the same as the ISO3166 code. You can find the country code for a specific country either by looking at /var/lib/apt-spy/mirrors.txt, or by looking at the commented examples in the default apt-spy.conf. Labels cannot exist within labels. The end of a label section is signaled by the start of a new one, or by the end of file. Any valid label existing in apt-spy.conf can be specified to apt-spy using the '-a' option. apt-spy will then proceed to benchmark the mirrors in the list of countries associated with that label. EXAMPLES
This is an example of a valid apt-spy.conf file: USUK: GB # United Kingdom US # United States Australia: AU France-Germany-Netherlands: FR DE NL There is a default configuration file included with apt-spy. For further examples, and for a list of valid country codes, please refer to this. SEE ALSO
apt-spy(8), apt(8), sources.list(5) 20th May, 2003 APT-SPY.CONF(5)
All times are GMT -4. The time now is 03:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy