I am having a tough time reading data from an input text file.
The input file has lines of data which is comma seperated. Each line represents a record/row, but unfortunately the data in the individual column/fields have spaces and `cat filename`is not returning entire line ( to read individual records).
How can I read individual records from this file? Is there a way to do it?
Below is a sample of the input file and it is also attached with this post.
Content Type,Author,Initial Submit Date,Task Name,Task Start Date,Task End Date,Task Owner,Completion Date
Workflow Properties,wcm_master,,,Workflow Properties,Workflow Properties,Workflow Properties,Workflow Properties
Workflow Properties,wcm_master,,,Workflow Properties,Workflow Properties,Workflow Properties,Workflow Properties
Workflow Properties,wcm_master,1217361943,TaskAddFile,Workflow Properties,Workflow Properties,Workflow Properties,Workflow Properties
Workflow Properties,wcm_master,1217362058,TaskAddFile,Workflow Properties,Workflow Properties,Workflow Properties,Workflow Properties
Email Test Flow,wcm_master,1217971876,TaskAddFile,Email Test Flow,Email Test Flow,Email Test Flow,Email Test Flow
CGI Test,n1plomen,1219776115,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
CGI Test,n1plomen,1219776268,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
CGI Test,n1plomen,1219776333,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
CGI Test,n1plomen,1219776417,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
CGI Test,n1plomen,1219776470,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
CGI Test,n1plomen,1219787503,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
CGI Test,n1plomen,1219787605,TaskAddFile,CGI Test,CGI Test,CGI Test,CGI Test
Email Test Flow,wcm_author,1219865848,TaskAddFile,Email Test Flow,Email Test Flow,Email Test Flow,Email Test Flow
Email Test Flow,wcm_author,1219865871,TaskAddFile,Email Test Flow,Email Test Flow,Email Test Flow,Email Test Flow
Email Test Flow,wcm_author,1219865908,TaskAddFile,Email Test Flow,Email Test Flow,Email Test Flow,Email Test Flow
The "backtick" operators strip out the newlines and replace them with spaces, so yeah, that's a problem for you. You need to do something like this instead:
Code:
cat your-file | while read line; do
something... something to $line;
done
Hello Team,
I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file.
Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file
<sequence>
<Filename>aldorzum.doc</Filename>
<DivisionCode>US</DivisionCode>
<ContentType>Template</ContentType>
<ProductCode>VIMZIM</ProductCode>
</sequence>... (4 Replies)
Hi all,
I have a text file that has (4) columns. There are about 300 lines on this file. It is a plain text file. I am looking to write a simple script that will read each line from the file and generate another text file. The file looks something like this:
These are the columns:
... (4 Replies)
Hi All,
Need your help!!
I have particular host file with below format:
172.34.45.67 Host1 Host2
134.45.56.67 Host3 Host4 Host5
I need shell script snippet which read this file and change the format of the file to the below format
172.34.45.67 Host1
172.34.45.67 ... (9 Replies)
I am having a text file
best = 100
genre = 75
group = 53
.
.
and so on
I need to read those values (100,75,53,...) from my shell script. I have to do the same function for all the variables. So in my script i used for loop to do the same.
for {
a=best
b=100
}
Video tutorial on... (3 Replies)
hello all ,
im trying to read a text file and display its contents. While i got the code running and the output was displayed perfectly for sometime , i started getting Abort(core dump) error . Am i missing something here ? im using HP-UX.
#include <iostream.h>
#include <fstream.h>
#include... (1 Reply)
How can i have a while loop as follows
while read inputline
do
<task>
done < name_list
and also store the values (delimited) on each line to temp variables so as to print them on screen as follows
while read inputline
do
set name | cut -d "," -f1 name_list # #i know this is not... (1 Reply)
Hi
Im MZ.... please help me with my requirements.....
Requirement: I have a text file named information.txt which contains information about Oracle Instances, I want to fetch data's from that text file and want to display an output using shell script.
Explanation : i.e. when I execute that... (0 Replies)
Guys,
I am trying to read text from a file, into arrays.
The format of the file is:
@DATABASE
femotest
@PACKAGE_SPECS
/usr/home/oracle92/sosa/scripts/test.pks
/usr/home/oracle92/sosa/scripts/rep.pks
@PACKAGE_BODIES
... (12 Replies)
I have a text file with 50 munbers.
I wanna read these numbers and append "@yahoo.com" and send emails to them using shell scripting..........
How do i read the inetegres from the text file. (1 Reply)