Search Results

Hi All,
I have a file separated by , and each line end with ".If the line doesnt end with " then i need to join the current line and the next one and put them in another file

a, b, c,d"...

i'm directing output to another file will that be problem
tail +1 test.csv|sed '/[^"]$/N; s/\n/ /'>test2.csv

not only that, if you see the output 2nd and 3rd line are merged

Name comment value
"A","EMP","58.s
; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s
; NO EMP"

Output got is
Name...

Attaching you correct file

Name comment value
"A","EMP","58.s
; NO EMP"
"B","EMP","56.s; NO EMPL"
"C","EMP","54.s
; NO EMP"
output to be
Name comment value
"A","EMP","58.s; NO EMP"...

A EMP 58
; NO EMP"
NO EMPL"
TXN 58
; NO EMPL"
output to be
A EMP 58 ; NO EMP"
NO EMPL" -- No change as it ends with double quotes
TXN 58 ; NO EMPL"

Hi All,

I have a file , delimited by |
Last column of the file has a extra enter causing error in my program
Eg:
firstworld <enter>; NO EMP
i want data to be firstworld; NO EMP

Is there a...

thanks Michael
Will that be possible to skip the first line
Because first line will be header

---------- Post updated at 06:15 AM ---------- Previous update was at 06:09 AM ----------

sed...

if the end of the line is not " then we need to append the current line and the next line

---------- Post updated at 04:59 AM ---------- Previous update was at 04:57 AM ----------

first line ...

Hi All,
We have a csv file.
We need to read end character , if the end character is not " we need to append that line and the next one
Kindly help me to write a script

Thanks

Hi All,

I'm installation a server
we have client -server architecture
I need to configure a port for client to communicate with the server
and server to communicate with the clients
Pls let...

thanks franklin

Hi Experts,
I need to list the files in a directory which have more than one lines
Please help

Thanks

Hi Experts,
I need to list the files in a directory which have more than one lines
All the files are csv format
Please help

Thanks

bsnithin thanks for the code
i need to send the content of the non empty file as attachment

thanks for the response
but again this will send separate mail for each of the non empty files
i need to send one consolidated mail with non empty files as attachment

Hi All,
I have a requirement to check all the files in a directory and mail non empty files
Files are in csv format , i need to skip header while checking
pls help

Thanks

thanks a lot

Hi All,
I need to check if a csv file is empty, leaving the first line as the first line is header
pls help

Thanks

thanks for the response
but i'm not able to introduce new line

Input:- comes from a sql statement, so i cannot predict the number of rows, but the no of column is constant (4)
eg:

1, sun, 2, 3
2, earth,3, 4
3, moon, 4, 5
Output should be:
********...

thanks for the response
but again i will have no of rows as dynamic

Hi All,
I have output of sql saved in comma separated file.
Now i need to read line by line this file
and assign word to a unix variable for further processing

Eg:

Test file
world, 1, 3,...

Hi All,
I'm using uuencode to send out mail from unix to lotus notes,but i dont have any attachment to send out, I'm getting this message in the body of the mail
"Usage: uuencode [ source ]...

Hi All,
i need a script to select record from oracle and send mail
there are multiple records in the table i need to read row by row and send mail
pls help

Hi scottn
Thanks for the reply
the script i posted already has closing pling !, I'm not so sure wat you are refering to

lcd localdir
cd /remote dir
mget *.*
close
bye
!

...