10-01-2008
File formating question.
Hi,
I have a file with only data 1 row:
AA#?BB#?CC#?DD
Assume '#?' is the delimiter, i want the output in another file to be:
AA
BB
CC
DD
Pls let me know if this is possible by sed ?
Thanks in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have two files file1 and file2 as shown below:
file1:
name
nameabc
bcd
nameabcdefg
file2:
age
age1111
age2345
age6743
I have pasted one file on the other with the delimiter "|" and the resulttant file is:
name|age
nameabc|age1111
bcd|age2345
nameabcdefg|age6743 (1 Reply)
Discussion started by: udiptya
1 Replies
2. Shell Programming and Scripting
Hi,
I am new to unix , I have a requirement for formating the input file and generate the output file as per the downstream requirement ..
My application receiving a text input file having 4 field and my application need to check each field and if some value of a field is blank ..then it need... (1 Reply)
Discussion started by: julirani
1 Replies
3. UNIX for Dummies Questions & Answers
I have a file called vm.cfg .
content of file.
acpi = 1
apic = 1
builder = 'hvm'
How would i write a script which will add
boot = 'd' at 3rd line.
For example.
after running the script the file should be like below.
acpi = 1
apic = 1
boot = 'd'
builder = 'hvm'
I dont want to... (3 Replies)
Discussion started by: pinga123
3 Replies
4. Shell Programming and Scripting
I am new ot unix. Is there one or two lines of command (sed may be) to format a file.
My source is..
<tag1>
<tag2>
<datatag1>
data1
</datatag1>
<datatag2>
data2
</datatag2>
<datatag3>
data3
</datatag3>
<datatag4>
data1
</datatag3>
</tag2>
</tag1> (2 Replies)
Discussion started by: reachsam11
2 Replies
5. Shell Programming and Scripting
Pls help in formatting a txt file using shell scripting
Input file format:
Name priya 2010-09-21 10:43:49
TEXT ID 1
hi
TEXT ID 2
how
TEXT ID 3
r
TEXT ID 4
u
Output required:
name priya hi how r u (4 Replies)
Discussion started by: bha148
4 Replies
6. Emergency UNIX and Linux Support
can anyone one help me....to make date and time format...to following format for my file
DATE TIME
DD- MON- YEAR 24 Hours
I have a need of format like this
12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me...
... (4 Replies)
Discussion started by: nex_asp
4 Replies
7. UNIX for Beginners Questions & Answers
Hi All,
Need to modify a file basically join the extra line to one I am having a file like below
And would like to make it as below . (4 Replies)
Discussion started by: arunkumar_mca
4 Replies
8. UNIX for Beginners Questions & Answers
Hi all,
I am having the file below
I need that as below
Thanks,
Arun (12 Replies)
Discussion started by: arunkumar_mca
12 Replies
9. Shell Programming and Scripting
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
10. Shell Programming and Scripting
I have a file like below
position1 0 7802 7802 0 client1 - -
position1 8 8032 8032 0 client1 ... (7 Replies)
Discussion started by: manas_ranjan
7 Replies
LEARN ABOUT DEBIAN
mdb-export
MDBTools(1) MDBTools(1)
NAME
mdb-export - Export data in an MDB database table to CSV format.
SYNOPSIS
mdb-export [-H] [-d delimiter] [-R row_delim] [[-Q] | [-q quote [-X escape]]] [-I] [-D format] database table
DESCRIPTION
mdb-export is a utility program distributed with MDB Tools.
It produces a CSV (comma separated value) output for the given table. Such output is suitable for importation into databases or spread-
sheets.
OPTIONS
-H Supress header row
-Q Don't wrap text-like fields (text, memo, date) in quotes. If not specified text fiels will be surrounded by " (double quote) char-
acters.
-d Specify an alternative column delimiter If no delimiter is specified, table names will be delimited by a , (comma) character.
-R Specify a row delimiter
-I INSERT statements (instead of CSV). You must specify the SQL dialect.
-D Set the date format (see strftime(3) for details)
-q Use to wrap text-like fields. Default is ".
-X Use to escape quoted characters within a field. Default is doubling.
-N namespace
Prefix identifiers with namespace.
NOTES
ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
SEE ALSO
gmdb2(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1)
HISTORY
mdb-export first appeared in MDB Tools 0.1.
AUTHORS
The mdb-export utility was written by Brian Bruns.
BUGS
Memo fields are allowed to contain a newline characters, the current program does nothing about this.
0.7 13 July 2013 MDBTools(1)