10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Would like to insert value between two empty delimiter and at the very last too if empty.
$ cat customerleft.tbl
300|Customer#000000300|I0fJfo60DRqQ|7|17-165-193-5964|8084.92|\N|p fluffily among the slyly express grouches. furiously express instruct||||||||||||||||||||||||\N... (3 Replies)
Discussion started by: Mannu2525
3 Replies
2. Shell Programming and Scripting
Given a csv file with 40 columns with name, address, hometown etc.
I use a bash command in 1 line which:
1. gets the address column and pipes that to
2. grep the first digit and everything that follows
Command:
awk -F ";" '{print $19}' /Users/jb/Desktop/ReorderTempTotal.csv | grep -o "\d.*"... (7 Replies)
Discussion started by: JBVeenstra
7 Replies
3. Shell Programming and Scripting
Hi All ,
I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows .
My file
1|2|3|4|5|6|7|8|9|10|11
New file
... (11 Replies)
Discussion started by: Hypesslearner
11 Replies
4. Shell Programming and Scripting
Hi,
I have a tab delimited flat file, for example shown below
Name Desg Loc
a b c
d e fI want to insert an empty column inbetween the column Desc and Loc, the result should be like shown below:
Name LName Desg Loc
a b c
d e ... (6 Replies)
Discussion started by: sampoorna
6 Replies
5. Shell Programming and Scripting
Hi,
I want to insert the text 'Unknown' in 2 specific columns in a csv file (actually | separated) if the column is blank. Its always the same columns.
I have tried using sed: sed "s/||/|Unknown|/g"
but there are occasion where other fields are blank and they need to be left blank. This... (4 Replies)
Discussion started by: ksexton
4 Replies
6. Shell Programming and Scripting
I have an awk script to extract data from several files and create output in the following format as a csv file:
xxxx 01/04/12 0001 0
When data is present, I have a file. When no data is available in the input files, I would still like to create a file that looks like this:
xxxx... (1 Reply)
Discussion started by: banjo25
1 Replies
7. Shell Programming and Scripting
I have a directory with several hundred files.
The file format is a space delimited row with an unknown number of columns:
A B C D E F G ...
I need to turn this format
File1 A
File1 B
File2 A
File3 A
File3 B
File3 C
...
I can use grep to display the filename next to each row of... (2 Replies)
Discussion started by: newreverie
2 Replies
8. Shell Programming and Scripting
Hi! i've been reading you guys for some time, now there is something I couldn't find here,
I'm trying to purge some data for my thesis but my measurements have some gaps in the third columns.
The solution is simple,
-Erase those lines where the third column is empty
¿How?
example... (1 Reply)
Discussion started by: AriasFco
1 Replies
9. Shell Programming and Scripting
I can't seem to get sed to allow me to insert text in the first line of an empty file. I have a file.txt that is a 0 byte file. I want sed to insert " fooBar" onto the first line. I've tried a few options and nothing seems to work. They work just fine if there's text in the file tho. Help? (4 Replies)
Discussion started by: DC Slick
4 Replies
10. Shell Programming and Scripting
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies
JODREPORTS(1) General Commands Manual JODREPORTS(1)
NAME
jodreports - use libjodreports-java directly from the command line to merge OpenDocument text with data
SYNOPSIS
jodreports <template-document> <data-file> <output-document>
DESCRIPTION
jodreports is a java program that merge OpenDocument text with data by using libjodreports-java. The command line tool is especially useful
to test templates while you are adding instructions to them. You use a .properties or .xml file to contain the <data-file> to be merged
into the template. The <template-document> needs to be an existing OpenDocument text with simple fields. A field that will be replaced with
the value of a variable passed can be specified using the standard FreeMarker expression notation by typing the variable name into the doc-
ument as follows
Hi ${name}!
here name will be replaced with the value passed in at runtime.
However, mixing processing instructions and normal text into the document may become confusing and clutter the layout. So JOOReports pro-
vides an alternative way of inserting fields. You can insert a visual field in OpenOffice.org Writer from the menu Insert / Fields /
Other... (or just press Ctrl+F2), then click on the Functions tab and select Input field. Change the field Reference to JOOScript and in
the following field Content enter the variable name (e.g. "$name"). This field will typically be displayed by Writer as a grayed rectangle
with the variable name, while moving the mouse over it will reveal the field reference.
This is a nice way of keeping processing instructions separate from the document layout and is thus the recommended approach. Whatever you
specify as the field Reference will be treated as a FreeMarker ${...} expression, so it could also be something more complex than a simple
variable name.
To insert more advanced instructions, e.g. for conditionally displaying a portion of text, or repeating a table row for each item in a col-
lection, you can use FreeMarker directives.
A simple directive is assign. You can use it to define a new variable, for example
[#assign totalPrice = unitPrice * quantity]
Note that we always use the alternative (square bracket) syntax for FreeMarker directives.
While it may be possible to insert this directive directly as text into the template, this does not always work (for reasons we'll see
below) and as mentioned mixing instructions into the document is a practice we want to avoid anyway. For this reason, JOOReports lets you
insert FreeMarker directives as scripts. You can insert a script in Writer from the menu Insert / Script..., then change the Script type to
JOOScript and insert any FreeMarker directives in the script Text box. A script will be displayed by Writer as a small green rectangle, and
you can double click on it to open it and modify it.
So you directive will be executed at the point where the script has been inserted. This is ok for something like assign but as we'll see
will not work for something like list.
Alternatively, you can insert a FreeMarker directive in OpenOffice.org Writer from the menu Insert / Fields / Other... (or just press
Ctrl+F2), then click on the Functions tab and select Input field. Change the field Reference to JOOScript and in the following field Con-
tent enter the directive (e.g. "[#assign title='Mr.']"). Sample Open Document Template
Again this provides a nice way to insert processing instructions and keept them separate from the document layout.
The <output-document> is also an OpenDocument text and will be created as the result of the merge.
JOOReports uses FreeMarker as its template engine.
FILES
/usr/share/java/jodreports.jar
AUTHOR
jodreports was written by Mirko Nasato <mirko@artofsolving.com> and Terry Liang <terry@polonious.com.au>.
jodreports was packaged for the Debian project by Sascha Girrulat <sascha@girrulat.de>.
This manual page was written by Sascha Girrulat <sascha@girrulat.de>, for the Debian project (and may be used by others). Most of the used
information are reused from http://jodreports.sourceforge.net.
User Manuals January 30, 2011 JODREPORTS(1)