Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Format problem of text file
Top Forums Shell Programming and Scripting Format problem of text file Post 302352736 by repinementer on Sunday 13th of September 2009 06:25:39 AM
Old 09-13-2009
Yes the input sample above reflects the original input except 2 additional columns before it.
The attachements correctones.txt or wrongones.txt reflect only some of the values from the the fifth column of the output I posted in code. For example the original input looks like this
Sorry for the inconvenience
Code:
AGGG	FTFHG	7829885		7831552		+	1    1667               0
FFFDFFD	HFFFF	7829885		7831552		+	1   1667,               0,
FHGJJJ	JGGGGG	35934936	35937087	-	2  1281,870,       0,1281,
OP23	HU899	35934936	35937087	-	2  1281, 870,      0 ,1281 ,
PFF	FDFDD	35934936	35937087	-	2  1281 , 870 , 870,890,890,680,   0, 1281 ,

The expected output should be like the above I already mentioned (But with 2 additional columns) with out any format troubles. Te format troubles I posted as attachment files already. The troubled ones as wrongones.txt but they suppose to look like correctones.txt
Last edited by repinementer; 09-13-2009 at 07:37 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Format a text file

I have a file that gets created by pasting 3 files together to get the one file. The output of the 3 files follows. sft.rtf c3_critappdb_u5 start 04:22:20 end 08:03:41 c3_critappdb_u6 start 18:01:31 end 20:21:19 c3_critappdb_u7 start 00:02:50 end 08:30:17 c3_critappdb_u8 start 17:00:42 end... (2 Replies)
Discussion started by: jhardy
2 Replies

2. Shell Programming and Scripting

Changing the text file format

Hi, I have a shell script to unload all the empname who have salary >50000 from the emp table into a text file(empname.txt) . m_db unload "$dbc_file" -column_delimiter ',' -select "SELECT empname FROM emp where salary > 50000" >> empname.txt Now my text file have data in the following format ... (3 Replies)
Discussion started by: kavithakuttyk
3 Replies

3. UNIX for Dummies Questions & Answers

Content format in a text file

Hi, I need to format the content in a text file as below format. Can some one help me how to approach? Also whether is it possible to convert the output to excel in column wise? Present: ============================================================================= Name: vinodh Status:... (1 Reply)
Discussion started by: vino_hymi
1 Replies

4. Shell Programming and Scripting

format text file

i have a text file in this format: name1^A1^B1^ name2^A2^B2^ ... namex^Ax^Bx^ name1^AA1^ name2^AA2^ ... namex^AAx^ name1^AAA1^BBB1^ name2^AAA1^BBB2^ ... namex^AAAx^BBBx^ name1^AAAA1^ name2^AAAA2^ ... namex^AAAAx^ i want to generate a file: (2 Replies)
Discussion started by: busystock
2 Replies

5. Shell Programming and Scripting

Text format problem with xmail

Hi, I have a very weird problem when I try to send a text file to outlook using the xmail command. # cat -e dec1.tmp SPEEDY 23-MAR-2011 01:28 ok$ 99svpp pas d'information$ 98pdrt pas d'information$ 57METZ 22-MAR-2011 23:50 ok$ # cat -e dec2.tmp SPEEDY 23-MAR-2011 01:14, SaveSYST ==>... (6 Replies)
Discussion started by: Castelior
6 Replies

6. Shell Programming and Scripting

Conversion of spaces Text file into CSV format file

Input file (each line is separaed by spaces )given below: Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- -----... (18 Replies)
Discussion started by: sreenath1037
18 Replies

7. Shell Programming and Scripting

Want to format column of a text file

Hi Techies I have written a script which is collecting the logs of job running on server and let mail me the output. I want to format column of output, please help. CCMS_BAU_from_CACHE RUN ETL_SUBSITE_TO_SITE_BAU RUN GetClient_Prep_Main RUN MDM_Client_BAU RUN Sweeper RUN... (11 Replies)
Discussion started by: atul9806
11 Replies

8. Shell Programming and Scripting

Format problem while converting text file to csv

Hi , I need a help in following scenario.I tried searching in google but couldn't able to find the exact answer. Sorry if i am re-posting already answered query. While i am trying to convert into log file into csv i couldn't able to get the format which i am looking for. I converted file... (4 Replies)
Discussion started by: varmas424
4 Replies

9. Shell Programming and Scripting

Reading the text file for particular format

Hi All, Need your help!! I have particular host file with below format: 172.34.45.67 Host1 Host2 134.45.56.67 Host3 Host4 Host5 I need shell script snippet which read this file and change the format of the file to the below format 172.34.45.67 Host1 172.34.45.67 ... (9 Replies)
Discussion started by: sharsour
9 Replies

10. Shell Programming and Scripting

Format text file to html

Hi Experts, Anybody out there figure out on how to achieve in shell scripts or tools. I have done googling to find solutions but no luck. I have thousands of .txt files to batch process, please see the below sample text content after -------- start here --------. What I want to achieve is to... (10 Replies)
Discussion started by: lxdorney
10 Replies

LEARN ABOUT DEBIAN

shelxle

ShelXle(1)							   User commands							ShelXle(1)

NAME

       shelxle - graphical user interface for SHELXL

SYNOPSIS

       shelxle [options] [file]

DESCRIPTION

       ShelXle	combines  an  editor  with  syntax highlighting for the SHELXL-associated .ins (input) and .res (output) files with an interactive
       graphical display for visualization of a three-dimensional structure including the electron density (Fo)  and  difference  density  (Fo-Fc)
       maps.

OPTIONS

       There  are  currently  only  a  few options supported, which are mainly targeted to debugging. It further supports the traditional QT (X11)
       options, see qtoptions(7). The program further optionally accepts a path to a .res or .ins file.

CITATION

       Please cite this article if you find this program useful:

       C. B. Hubschle, G. M. Sheldrick and B. Dittrich, ShelXle: a Qt graphical user interface for SHELXL, J. Appl. Cryst., 44, (2011) 1281-1284.

       See the following URLs:

       http://dx.doi.org/10.1107/S0021889811043202
       http://journals.iucr.org/j/issues/2011/06/00/kk5092/kk5092.pdf

SEE ALSO

       qtoptions(7)

AUTHORS

       The program author is Christian B. Huebschle <chuebsch@moliso.de>.

       This manual page page was written by Daniel Leidert <daniel.leidert@wgdd.de> for the Debian distribution (but may be used by others).

								    2012-07-01								ShelXle(1)
All times are GMT -4. The time now is 03:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy