Sponsored Content
Top Forums Shell Programming and Scripting Shell script to format a .CSV data Post 302163440 by rikxik on Friday 1st of February 2008 02:56:40 AM
Old 02-01-2008
Code:
$ cat in.txt
AcquiredMethod, AssetID, AssetLifecycleStatus, SC1, SC2, DC1, DC2
Vendor Owned, ATESTIMPORT10, Down, a, b, c, d
$
$
$ cat sply.sh
#!/usr/bin/ksh

nawk -F"," 'BEGIN{OFS=","}{ if (NR==1) {
                        print "AcquiredMethod, AssetID, AssetLifecycleStatus, C, S/D, 1or2"
                } else {
                        print $1,$2,$3,$4,"S",1
                        print $1,$2,$3,$5,"S",2
                        print $1,$2,$3,$6,"D",1
                        print $1,$2,$3,$7,"D",2
                }}' in.txt



$
$
$ ./sply.sh
AcquiredMethod, AssetID, AssetLifecycleStatus, C, S/D, 1or2
Vendor Owned, ATESTIMPORT10, Down, a,S,1
Vendor Owned, ATESTIMPORT10, Down, b,S,2
Vendor Owned, ATESTIMPORT10, Down, c,D,1
Vendor Owned, ATESTIMPORT10, Down, d,D,2

HTH
 

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

format csv file using shell script

i have a report.csv file from oracle datavase In that file data is like this with report heading and date SALES DAILY REPORT DATE: 06-26-2007 REPORT NAME: SALES DATA AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Discussion started by: raosurya
3 Replies

2. UNIX for Advanced & Expert Users

shell script to format .CSV data

Hi all, I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on? Thanks! cat... (1 Reply)
Discussion started by: tmcmurtr
1 Replies

3. Shell Programming and Scripting

Exporting data as a CSV file from Unix shell script

Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome. Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ? The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies

4. Shell Programming and Scripting

Reading the data from CSV and performing search through shell script

Hello, I am working on building a script that does the below actions together in my Linux server. 1) First, have to read the list of strings mentioned in CSV and store it in the shell script 2) Second, pick one by one from the string list, and search a particular folder for files that... (2 Replies)
Discussion started by: vikrams
2 Replies

5. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

6. Shell Programming and Scripting

Format CSV file from a shell script

I have a shell script which creates a CSV files. there are 3 fields, field1, field2 and comp. I will generates the values for field1 and field2 and Want to compare both. If field1>filed2 then comp should be success written in green in CSV file, else it should fail in red color. How can I change the... (5 Replies)
Discussion started by: sauravrout
5 Replies

7. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values. Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies

8. Shell Programming and Scripting

Shell script to extract data from csv file

Hi everyone, I have a csv file which has data with different heading and column names as below. Static Data Ingested ,,,,,,,,,,,,Known Explained Rejections Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Discussion started by: Vivekit82
14 Replies

9. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies
gnome-search-tool(1)						   User Commands					      gnome-search-tool(1)

NAME
gnome-search-tool - search for files SYNOPSIS
gnome-search-tool [--named=text] [--path=folder] [--sortby=order] [--descending] [--contains=string] [--user=user] [--nouser] [--allmounts] [--empty] [--follow] [--group=group] [--hidden] [--mtimeless=date] [--mtimemore=date] [--notnamed=filename] [--regex=pattern] [--size- less=size] [--sizemore=size] [--start] [gnome-std-options] DESCRIPTION
The Search for Files application enables you to search for files on your system. Search for Files uses the find(1) command. OPTIONS
The following options are supported: --allmounts Select the 'Search other filesystems' search constraint. --contains=string Select the 'Contains the text' search constraint and set the text of that entry. Use a full filename or a partial filename with wildcards. See find(1) for more details about using wildcards. --descending Set sort order to descending. The default sort order is ascending. --empty Select the 'File is empty' search constraint. --follow Select the 'Follow symbolic links' search constraint. --group=group Select the 'Owned by group' search constraint and set the text of that entry. --hidden Select the 'Show hidden and backup files' search option. --mtimeless=date Select the 'Date modified before (days)' search constraint and set the text of that entry. --mtimemore=date Select the 'Date modified after (days)' search constraint and set the text of that entry. --named=text Set the text of the 'Name contains' search option. --notnamed=filename Select the 'File is not named' search constraint and set the text of that entry. Use a full filename or a partial filename with wildcards. See find(1) for more details about using wildcards. --nouser Select the 'Owner is unrecognized' search constraint. --path=folder Set the text of the 'Look in folder' entry. Defaults to the current working directory. --start Automatically start a search. --regex=pattern Select the 'File matches regular expression' search constraint and set the text of that entry. See find(1) for more details about the regular expression patterns that can be used. --sizeless=size Select the 'Size is less than (kilobytes)' search constraint and set the text of that entry. --sizemore=size Select the 'Size is more than (kilobytes)' search constraint and set the text of that entry. --sortby=order Sort files by one of the following: name, folder, size, type, or date. --user=user Select the 'Owned by user' search constraint and set the text of that entry. gnome-std-options Standard options available for use with most GNOME applications. See gnome-std-options(5) for more information. EXAMPLES
Example 1: Performing a basic search automatically example% gnome-search-tool --name=a.out --path=$HOME --autostart Example 2: Performing an advanced search automatically example% gnome-search-tool --contains=unistd.h --mtimeless=3 --sortby=size --autostart EXIT STATUS
The following exit values are returned: 0 Application exited successfully >0 Application exited with failure FILES
The following files are used by this application: /usr/bin/gnome-search-tool Executable for Search for Files ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-search-tool | +-----------------------------+-----------------------------+ |Interface stability |Volatile | +-----------------------------+-----------------------------+ SEE ALSO
Search for Files Manual Latest version of the GNOME Desktop User Guide for your platform. find(1), gnome-std-options(5) NOTES
Written by Glynn Foster, Sun Microsystems Inc., 2003, 2006. SunOS 5.11 2 Oct 2003 gnome-search-tool(1)
All times are GMT -4. The time now is 04:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy