Sponsored Content
Top Forums Shell Programming and Scripting Excel related query for the code..need help.. Post 302223136 by Shahul on Friday 8th of August 2008 12:32:13 PM
Old 08-08-2008
Hope the below is the one which shamrock said...correct me if am wrong..


if your output looks like below.

columnA columnB
1233 aaaa
2345 bbbb
3455 cccc

the above output is present in file1.txt

then just use the below command to make it csv

sed 's/space/,/g' file1

it should give the output like below
1233,aaaa
2345,bbbb
3455,cccc

or if there are two different column in differnt files then you can use the below command

paste -d, file1 file2 > output.csv


thanks
Sha
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Query related to #!/bin/sh

hi All Why is #!/bin/sh being used in most of the ksh scripts......? I have seen this (#!/bin/sh) being used at the start of the script Regards Suresh (2 Replies)
Discussion started by: sureshg_sampat
2 Replies

2. Shell Programming and Scripting

sed related query

Hi I have a file which looks like this //string = "abcd"; //info //string = "*pqrs"; //add string = "#123"; //sub //string = "#1234567890" data = check(string) //string = "#1234567890" I want to modify this as string = "#987"; //mult data = check(string) How do i do that? (1 Reply)
Discussion started by: gopsman
1 Replies

3. UNIX for Dummies Questions & Answers

awk related query

hi, I have to extract a column from a file and then updated that column..?? Now i can use wak for extracting it and then how to update it.. $ awk' {print $5}' input_file Can i use sed command here piping it to the output from the awk command.. (2 Replies)
Discussion started by: abhisek.says
2 Replies

4. Shell Programming and Scripting

Print related query

i Am using the below query and printing the $8 and $9 filed.. find /A/B/C/{1,3,5,7} -name "*.txt" -o -name "*.csv" -o -name "*.TXT" -o -name "*.dat" |xargs ls -ltr |awk '{print $8 ,$9}' > result.xls this give me the rsult like below.. 2008/home/ADMIN/om/1.txt 2008/home/ADMIN/om/hi.txt ... (1 Reply)
Discussion started by: sapan123
1 Replies

5. Shell Programming and Scripting

query related to if

wht does below statement mean? if wht does dis -d option do?? TIA. (1 Reply)
Discussion started by: sainathdeg
1 Replies

6. Shell Programming and Scripting

datetimestamp related query!

Hi all, I have put a query in a thread but didn't get any reply. Hoping to get a reply here. I have a file in that one line resembles like below... Forwarded by Deepak on 11/15/2009 10:28 AM EST ofcourse AM can be PM also... so what i need is first i need to get only... (1 Reply)
Discussion started by: smarty86
1 Replies

7. Solaris

Query related to runlevels and milestones

Hi friends.. Please clarify my follg doubts: 1. I can easily switch from runlevel 1 to runlevel 2 or 3 by means of init 2 or init 3 commands. I can even get a gui login screen when i do an init 3 from runlevel1. 2.But suppose if I am in GUI and switched to single-user milestone by means of ... (3 Replies)
Discussion started by: saagar
3 Replies

8. UNIX for Dummies Questions & Answers

A query related to 'ls' command

I am executing the ls command to show the contents of a folder, it shows some number in front of word total as highlighted in blue color below quotes. Can anyone please share that what it is? (2 Replies)
Discussion started by: Zaib
2 Replies

9. UNIX for Dummies Questions & Answers

query related to grep

Hi All, The result for 'grep "cert_codes" /develop/sales/appl.srce/*.4gl' command will be saved at aa.txt grep "cert_codes" /develop/sales/appl.srce/*.4gl >aa.txt But I am not sure, whether, all result stored in .txt file in case of multi-line result. Please revert back if... (2 Replies)
Discussion started by: pbankar
2 Replies

10. Emergency UNIX and Linux Support

Interfaces related query

I need to list the interfaces that uses FTP instead of SFTP on my applications that are on AIX servers. How do I get that list of IP addresses that connect to my applications via FTP? (2 Replies)
Discussion started by: ggayathri
2 Replies
ARES_PARSE_TXT_REPLY(3) 				     Library Functions Manual					   ARES_PARSE_TXT_REPLY(3)

NAME
ares_parse_txt_reply - Parse a reply to a DNS query of type TXT SYNOPSIS
#include <ares.h> int ares_parse_txt_reply(const unsigned char* abuf, int alen, struct ares_txt_reply **txt_out); DESCRIPTION
The ares_parse_txt_reply function parses the response to a query of type TXT into a linked list of struct ares_txt_reply The parameters abuf and alen give the contents of the response. The result is stored in allocated memory and a pointer to it stored into the variable pointed to by txt_out. It is the caller's responsibility to free the resulting txt_out structure when it is no longer needed using the function ares_free_data The structure ares_txt_reply contains the following fields: struct ares_txt_reply { struct ares_txt_reply *next; unsigned int length; unsigned char *txt; }; RETURN VALUES
ares_parse_txt_reply can return any of the following values: ARES_SUCCESS The response was successfully parsed. ARES_EBADRESP The response was malformatted. ARES_ENODATA The response did not contain an answer to the query. ARES_ENOMEM Memory was exhausted. AVAILABILITY
This function was first introduced in c-ares version 1.7.0. SEE ALSO
ares_query(3) ares_free_data(3) AUTHOR
Written by Jakub Hrozek <jhrozek@redhat.com>, on behalf of Red Hat, Inc http://www.redhat.com 27 October 2009 ARES_PARSE_TXT_REPLY(3)
All times are GMT -4. The time now is 03:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy