Text to csv Post: 302311062

Sponsored Content

Top Forums Shell Programming and Scripting Text to csv Post 302311062 by lawstudent on Monday 27th of April 2009 08:17:32 PM

04-27-2009

Registered User

Text to csv

Hi,

I have a document with a lot of data, it is structured like this,

Code:

UNIQUESTRING


To be acquited of a crime is to be deemed to be innocent of
the charges after a court hearing. This is different from a
<a href=lawglos_Discharge.html>Discharge</a>, where the case is never heard. In
general, a defendant who is acquited can not be tried again
for the same offence. If more than one defendant is on
trial for the same offence (see: <a href=lawglos_Accomplice.html>Accomplice</a>),
the acquital of one of them is not admissible as evidence
in favour of the others. A conviction, however, is
admissible against the other defendants. This is because an
acquital is not `proof' of innocence, it is merely an
indication that the prosecution did not establish a case
strong enough for a conviction. In other words, `innocent
until proven guilty' does not mean that `all are innocent
until all are proven guilty'. 
<p>
<a href=lawglos_CriminalLaw.html>CriminalLaw</a>


UNIQUESTRING


`blameworthy act'; it is used to denote the event on which a criminal offence
is based. In many
cases the <i>actus reus</i> will be an explicit act (theft, 
assault, etc). In others it will be a prohibited state
of affairs (e.g., having an offensive 
weapon (see: <a href=lawglos_OffensiveWeapon.html>OffensiveWeapon</a>) 
in a public place). In some cases the <i>actus</i> can be
an omission to act (see: <a href=lawglos_Omission.html>Omission</a>), but usually only when the
those offences the prosecution has no duty to show
a <i>mens rea</i> (see: <a href=lawglos_MensRea.html>MensRea</a>); thus an offence cannot
be defended on the basis that there was no intention to
comment the offence, but it can be defended on the basis
that no offence was committed.
<p>
<p>
This defence will only be available if the defendant truly
had <i>no</i> choice; for example, he was physically 
pushed by someone else. A defendant who makes a choice
between two equally dreadful alternatives (`help us rob
this bank or we'll shoot your wife') is not acting
involuntarily in this sense, but he may have a 
<a href=lawglos_GeneralDefence.html>GeneralDefence</a> of <a href=lawglos_Duress.html>Duress</a>.
<p>
<a href=lawglos_CriminalLaw.html>CriminalLaw</a>


UNIQUESTRING


As defined in the <a href=lawglos_TheftAct1968.html>TheftAct1968</a>, a <a href=lawglos_Burglary.html>Burglary</a> in which 
the perpetrator has an offensive weapon (see: <a href=lawglos_OffensiveWeapon.html>OffensiveWeapon</a>).
This Act defines an offensive weapon as something that is
<i>intended</i> to cause harm.
<p>
<a href=lawglos_CriminalLaw.html>CriminalLaw</a>


UNIQUESTRING

And it goes on forever, I need to put all these short definitions into a database, in excel I have all keywords in a long list in one column A1,A2,A3 etc and now I like to place these definitions next to them B1,B2,B3 etc

Can someone please tel me how to make that happen? I tried to import using excel and do table to column but that doesn't work, I am sure with unix it is easier..

lawstudent

View Public Profile for lawstudent

Find all posts by lawstudent

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

converting text to csv format

I am trying to check each line and based on first two digits, the comma needs to be place. I checked in the earlier post where the text is converted to csv with a tab delimited. Here is the test file that needs to be changed to csv 11 051701 22 051701 330123405170105170112345...

2. UNIX for Advanced & Expert Users

how to convert text/csv to excel

Hello All, I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH. Thanks, Sateesh

3. Shell Programming and Scripting

Text to CSV

Hi, My access log looks like this... 192.168.50.184 - - "GET /ATIM_LATEST/ABC/ HTTP/1.1" 200 522 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.13) Gecko/2009073022 Firefox/3.0.13" 192.168.50.184 - - "GET /ATIM_LATEST/ABC/ATIM/syncdepot.php HTTP/1.1" 200 1463...

4. Shell Programming and Scripting

Can't use Text::CSV... any sample code out there?

I was looking at a library that lets me parse comma delimited csv files without a problem, but unfortunately, I'm not allowed to make use of that library. I understand that the library probably does something similar to a string split(), but I don't quite know what kind of regular expression is...

5. Shell Programming and Scripting

text to csv conversion

Thank u every body ......just need a help so that a text file needs to be converted into CSV............. my log file is as follows Host scsi3: usb-storage Vendor: Maxtor Product: OneTouch III Serial Number: 044303E5 Protocol: Transparent SCSI Transport: Bulk ...

6. Shell Programming and Scripting

Convert text to CSV

Hi Gurus I need urgent help to convert a flat log file into csv format to load into database. Log looks like: a=1 b=2 c=3 a=4 b=5 c=6 Only the values at right side of = will come into csv and it should create a new line once it receives "a" field.

7. Shell Programming and Scripting

TEXT to CSV using Perl

Hi Folks Need some help with this and my Perl isnt the hottest I also have text::csv installed on my perl install The large text with a few million entries is in a format below example text file Fig Leafs Cake No: 0000001 Author: King s. Record No: 995-34343-232-232...

8. Shell Programming and Scripting

Create csv from text file

Gents, I am trying to create a csv file using the file attached. I have a problem to get all information required because the rows are not continues. Here is my code till now. awk ' /"ffid"/{if(s){print s;s=$NF}else{s=$NF}} /"LineNumber"/{s=s $NF} /"PointNumber"/{s=s $NF}...

9. Shell Programming and Scripting

CSV from Text file

Gents, Attached there is a input.txt and code.txt file. I use that code to create a csv file from txt file. Is there the possibility to generate other code more faster to generate the CVS file using the input file. I have deleted many data in the input file to avoid load a lot data. ...

10. Shell Programming and Scripting

Convert text to csv

Hi, Is there somebody there to post an idea on how to convert this 5 liner row to 1 liner or tab delimiter to be import to database. Here the text file format: Description: Description1 Link: https://www.google.com Date: June 2, 2018 Time: 00:07:44 Age: 1 days ago Description:...

LEARN ABOUT CENTOS

qrencode

QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME

       qrencode - Encode input data in a QR Code and save as a PNG or EPS image.

SYNOPSIS

       qrencode [OPTION]...  [STRING]

DESCRIPTION

       Libqrencode  is	a  library  for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a
       mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness.

       Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image.

OPTIONS

       -h, --help
	      display help message.

       -o FILENAME, --output=FILENAME
	      write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured  symbols  are
	      written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified)

       -s NUMBER, --size=NUMBER
	      specify the size of dot (pixel). (default=3)

       -l {LMQH}, --level={LMQH}
	      specify error collectin level from L (lowest) to H (highest). (default=L)

       -v NUMBER, --symversion=NUMBER
	      specify the version of the symbol. (default=auto)

       -m NUMBER, --margin=NUMBER
	      specify the width of margin. (default=4)

       -d NUMBER, --dpi=NUMBER
	      specify the DPI of the generated PNG. (default=72)

       -t {PNG,EPS,SVG,ANSI,ANSI256,ASCII,ASCIIi,UTF8,ANSIUTF8}
       --type={PNG,EPS,SVG,ANSI,ANSI256,ASCII,ASCIIi,UTF8,ANSIUTF8}
	      specify the type of the generated image. (default=PNG)

       -S, --structured
	      make structured symbols. Version must be specified.

       -k, --kanji
	      assume that the input text contains kanji (shift-jis).

       -c, --casesensitive
	      encode lower-case alphabet characters in 8-bit mode. (default)

       -i, --ignorecase
	      ignore case distinctions and use only upper-case characters.

       -8, --8bit
	      encode entire data in 8-bit mode. -k, -c and -i will be ignored.

       -M, --micro
	      encode in a Micro QR Code. (experimental)

       --foreground=RRGGBB[AA]
       --background=RRGGBB[AA]
	      specify foreground/background color in hexadecimal notation.  6-digit (RGB) or 8-digit (RGBA) form are supported.  Color output sup-
	      port available only in PNG and SVG.

       -V, --version
	      display the version number and copyrights of the qrencode.

       [STRING]
	      input data. If it is not specified, data will be taken from standard input.

EXAMPLES

       qrencode -l L -v 1 -o output.png 'Hello, world!'
	      encode into a symbol version 1, level L.

       qrencode -iSv 1 --output=output.png
	      read standard input and encode it into a structured-appended symbols in case-insensitive mode.

AUTHOR

       Written by Kentaro Fukuchi.

RESOURCES

       Main Web Site: http://fukuchi.org/works/qrencode/

       Source code repository: https://github.com/fukuchi/libqrencode/

COPYRIGHT

       Copyright (C) 2006-2012 Kentaro Fukuchi.

qrencode 3.4.1							   Oct. 9, 2012 						       QRENCODE(1)