Sponsored Content
Top Forums Shell Programming and Scripting Convert delimited to fixed length Post 87771 by Perderabo on Thursday 27th of October 2005 01:40:07 PM
Old 10-27-2005
Neither record has any numeric data in it. I do not understand how this data relates to the original problem which was:
Bob Smith<<tab>>139.90
Kathy Reys<<tab>>-40.50
Two fields per record, not three.
Second field was numeric.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert XML file into Text file(fixed length)

If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts. My xml file: <root> <header_rec recordtype="00"> <record_id>00</record_id> ... (0 Replies)
Discussion started by: ram2s2001
0 Replies

2. Shell Programming and Scripting

how to convert Fixed length file to delimited file.

I have below fixed lenth file . I have to convert this to delimitted file. File1.txtE116005/29/19930E001E000 E12201/23/19940E001E003 E10406/4/19940E001E003 I want to convert this to : E116,0,05/29/1993,0,E001,E000 E122,0,1/23/1994,0,E001,E003 E104,0,6/4/1994,0,E001,E003 I have a... (7 Replies)
Discussion started by: satyam_sat
7 Replies

3. Shell Programming and Scripting

convert fixed length file to CSV

Newbie Looking for a script to convert my input file to delimited text file. Not familier with AWK or shell programing. Below is sample record in my input file and the expected output format. My OS is HPUX 11.23. Thanks in advance for your assistance. tbtbs input file:... (12 Replies)
Discussion started by: tbtbs
12 Replies

4. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

5. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

6. Shell Programming and Scripting

converting fixed length file to delimited file

hi , i need to convert fixed length file to delimited file using unix where length of each column is variable (2 Replies)
Discussion started by: Nishithinfy
2 Replies

7. UNIX for Dummies Questions & Answers

convert # delimited text file to fixed width

Hello gurus, I have a file containing 5 columns delimited by '#' as shown in the example below: HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA# 99991231#AU7129#000000000#1 PROCTER & GAMBLE# 99991231#TT4283#1000013883#21111 LAUNDRY# 99991231#TT4283#1000013884#21121 DISH... (3 Replies)
Discussion started by: chumsky
3 Replies

8. Shell Programming and Scripting

Fixed length to delimited file conversion

Hi All, I need to convert a fixed length file to a delimited file with , (comma). But not all columns, some of the columns in the fixed files are used as fillers and I do not need that in the output file. test_fixed_len.txt I 0515 MR 394 I 0618 MR & MRS 942 I 0618 MR & MRS... (7 Replies)
Discussion started by: member2014
7 Replies

9. Shell Programming and Scripting

Convert variable length record to fixed length

Hi Team, I have an issue to split the file which is having special chracter(German Char) using awk command. I have a different length records in a file. I am separating the files based on the length using awk command. The command is working fine if the record is not having any... (7 Replies)
Discussion started by: Anthuvan
7 Replies

10. UNIX for Beginners Questions & Answers

Convert a fixed width file to a delimited file

Hi - this is a generic question .... is there any utility which can convert a fixed width file format to a delimited file (any given character delimited) ? (5 Replies)
Discussion started by: i4ismail
5 Replies
QDataView(3qt)															    QDataView(3qt)

NAME
QDataView - Read-only SQL forms SYNOPSIS
#include <qdataview.h> Inherits QWidget. Public Members QDataView ( QWidget * parent = 0, const char * name = 0, WFlags fl = 0 ) ~QDataView () virtual void setForm ( QSqlForm * form ) QSqlForm * form () virtual void setRecord ( QSqlRecord * record ) QSqlRecord * record () Public Slots virtual void refresh ( QSqlRecord * buf ) virtual void readFields () virtual void writeFields () virtual void clearValues () DESCRIPTION
The QDataView class provides read-only SQL forms. This class provides a form which displays SQL field data from a record buffer. Because QDataView does not support editing it uses less resources than a QDataBrowser. This class is well suited for displaying read-only data from a SQL database. If you want a to present your data in an editable form use QDataBrowser; if you want a table-based presentation of your data use QDataTable. The form is associated with the data view with setForm() and the record is associated with setRecord(). You can also pass a QSqlRecord to the refresh() function which will set the record to the given record and read the record's fields into the form. See also Database Classes. MEMBER FUNCTION DOCUMENTATION
QDataView::QDataView ( QWidget * parent = 0, const char * name = 0, WFlags fl = 0 ) Constructs a data view which is a child of parent, called name, and with widget flags fl. QDataView::~QDataView () Destroys the object and frees any allocated resources. void QDataView::clearValues () [virtual slot] Clears the default form's values. If there is no default form, nothing happens. All the values are set to their 'zero state', e.g. 0 for numeric fields, "" for string fields. QSqlForm * QDataView::form () Returns the default form used by the data view, or 0 if there is none. See also setForm(). void QDataView::readFields () [virtual slot] Causes the default form to read its fields from the record buffer. If there is no default form, or no record, nothing happens. See also setForm(). QSqlRecord * QDataView::record () Returns the default record used by the data view, or 0 if there is none. See also setRecord(). void QDataView::refresh ( QSqlRecord * buf ) [virtual slot] Causes the default form to display the contents of buf. If there is no default form, nothing happens.The buf also becomes the default record for all subsequent calls to readFields() and writefields(). This slot is equivalant to calling: myView.setRecord( record ); myView.readFields(); See also setRecord() and readFields(). void QDataView::setForm ( QSqlForm * form ) [virtual] Sets the form used by the data view to form. If a record has already been assigned to the data view, the form will display that record's data. See also form(). void QDataView::setRecord ( QSqlRecord * record ) [virtual] Sets the record used by the data view to record. If a form has already been assigned to the data view, the form will display the data from record in that form. See also record(). void QDataView::writeFields () [virtual slot] Causes the default form to write its fields to the record buffer. If there is no default form, or no record, nothing happens. See also setForm(). SEE ALSO
http://doc.trolltech.com/qdataview.html http://www.trolltech.com/faq/tech.html COPYRIGHT
Copyright 1992-2007 Trolltech ASA, http://www.trolltech.com. See the license file included in the distribution for a complete license statement. AUTHOR
Generated automatically from the source code. BUGS
If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html. Good bug reports help us to help you. Thank you. The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially supported by Trolltech. If you find errors in this manual page, please report them to qt-bugs@trolltech.com. Please include the name of the manual page (qdataview.3qt) and the Qt version (3.3.8). Trolltech AS 2 February 2007 QDataView(3qt)
All times are GMT -4. The time now is 12:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy