12-04-2013
The goal would be that I can load all lines in the file and that each column/field is delimited by a pipe and each row has exactly 70 col/fields. The data has embedded cr/lf/eol in it. It came from an xls.
Thanks,
Tim
---------- Post updated at 04:50 PM ---------- Previous update was at 04:46 PM ----------
and from the original xls, there are 4688 rows.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file namely 'inputs' The values inside the file are like this and seperated by a '|'.
mani|21|CSE
How can I extract the values from this file without the '|' symbol.
Thanks in advance. (1 Reply)
Discussion started by: sendhilmani123
1 Replies
2. Shell Programming and Scripting
I need some assistance, I am writing a script in bash.
I want to do two things:
1/. I want to replace the LF at the end of the RFH Ø ¸MQSTR ¸ so I can process the file record by record using a while loop.
2/. I want to extract two fields from each record, they are identified with... (1 Reply)
Discussion started by: gugs
1 Replies
3. Shell Programming and Scripting
Dear All
I have a file like this
112534554
446538656
444695656
225696966
226569744
228787874
113536566
443533535
222564552
115464656
225445345
225533234
I want to cut the file into different parts where the first two columns are '11' . The first two columns will be either... (3 Replies)
Discussion started by: anoopvraj
3 Replies
4. Shell Programming and Scripting
Is there any way to print all the string till we get a space and a number and store it a variable
for eg we have string java.io.IOException: An existing connection was forcibly closed by the remote host 12
All I want is to store "java.io.IOException: An existing connection was forcibly closed... (13 Replies)
Discussion started by: villain41
13 Replies
5. Shell Programming and Scripting
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959
4 Replies
6. Shell Programming and Scripting
Hi Gurus,
Have a file seperated by "~" and no of fields is 104. When i try to run awk, it erros out.
awk: record `B~A31~T24_STF~~~2009...' has too many fields
Any idea how can i extract a specific filed with this many fields in a row.
Kindly help (3 Replies)
Discussion started by: srivat79
3 Replies
7. Shell Programming and Scripting
Hi
I was going through the below thread
https://www.unix.com/shell-programming-scripting/48535-how-count-number-fields-record.html
I too have something similar requirement as specified in this thread but the number of columns in my case can be very high, so I am getting following error.
... (3 Replies)
Discussion started by: shekharjchandra
3 Replies
8. Shell Programming and Scripting
Hi All,
I have a file as below:
abc.txt
******************************
* HEADER DESCRIPTION
******************************
*Supplier: Prism
Customer: MNI -NIGERIA
Quantity: 2
Type: PLUG-IN
Profile: 70.00
*Subscription: Generic... (5 Replies)
Discussion started by: arunshankar.c
5 Replies
9. Shell Programming and Scripting
Hi,
How to print the number of fields in each record with the line number?
Lets saw I have
3212|shipped|received|
3213|shipped|undelivered|
3214|shipped|received|delivered
I tried the code
awk -F '|' '{print NF}'
This gives me ouput as
3
3
4 (5 Replies)
Discussion started by: machomaddy
5 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
TEST01 APP_USER_PROFILE
USER03 APP_USER_PROFILE
TEST02 APP_USER_EXP_PROFILE
TEST04 APP_USER_PROFILE
USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies
GSF(1) GNOME GSF(1)
NAME
gsf - archiving utility using the G Structured File library
SYNOPSIS
gsf [OPTION...] SUBCOMMAND ARCHIVE...
DESCRIPTION
This manual page briefly documents the gsf command.
gsf is a simple archive utility, somewhat similar to tar(1). It operates on files following one of the structured file formats understood
by the G Structured File library, for example, Microsoft Excel(TM) files.
OPTIONS
Options
-?, --help
Show help options
-v, --version
Display gsf's version
Subcommands
cat Output one or more files in archive
dump Dump one or more files in archive as formatted hexadecimal
help List subcommands
list List files in archive
props Archive list of property names
EXAMPLES
To list the content structure of a Microsoft Excel(TM) file arrays.xls:
gsf list arrays.xls
To dump Workbook, an individual data stream in arrays.xls:
gsf dump arrays.xls Workbook
AUTHORS
gsf's primary authors are Morten Welinder <terra@gnome.org> and Jody Goldberg <jody@gnome.org>.
The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.
SEE ALSO
gnumeric(1)
The Gnumeric homepage <http://www.gnome.org/projects/gnumeric/>
The GNOME project page <http://www.gnome.org/>
gsf 29 November 2009 GSF(1)