I needed to write a Unix shell script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
Currently I am in the proess of Data Import to "Remedy System" (A one kind of incident mangement Application) and this application accepts the Data in a particular format, Hence I want to accomplish this task with the Script without manual intervension.
My Original data loooks some what like this,
AcquiredMethod, AssetID, AssetLifecycleStatus, SC1, SC2, DC1, DC2
Vendor Owned, ATESTIMPORT10, Down, a, b, c, d
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT SUSE
gnome-search-tool
gnome-search-tool(1) General Commands Manual gnome-search-tool(1)NAME
gnome-search-tool - the GNOME Search Tool
SYNOPSIS
gnome-search-tool [options]
or select Search for Files... from a Main Menu or from the Places menu in a Menu Bar
DESCRIPTION
GNOME Search Tool is a utility for finding files on your system. To perform a basic search, you can type a filename or a partial filename,
with or without wildcards. To refine your search, you can apply additional search options.
GNOME Search Tool uses the find, grep, and locate UNIX commands. The case sensitivity of the search depends on your operating system. For
example, on Linux, the find, grep, and locate commands support the -i option, so all searches are case-insensitive.
For full documentation see the GNOME Search Tool online help.
OPTIONS --help Show help message
--named=STRING
Set the text of "Name contains" search option
--path=PATH
Set the text of "Look in folder" search option
--sortby=VALUE
Sort files by one of the following: name, folder, size, type, or date
--descending
Set sort order to descending, the default is ascending
--start
Automatically start a search
--contains=STRING
Select and set the "Contains the text" search option
--mtimeless=DAYS
Select and set the "Date modified less than" search option
--mtimemore=DAYS
Select and set the "Date modified more than" search option
--sizemore=KILOBYTES
Select and set the "Size at least" search option
--sizeless=KILOBYTES
Select and set the "Size at most" search option
--empty
Select the "File is empty" search option
--user=USER
Select and set the "Owned by user" search option
--group=GROUP
Select and set the "Owned by group" search option
--nouser
Select the "Owner is unrecognized" search option
--notnamed=STRING
Select and set the "Name does not contain" search option
--regex=PATTERN
Select and set the "Name matches regular expression" search option
--hidden
Select the "Show hidden and backup files" search option
--follow
Select the "Follow symbolic links" search option
--mounts
Select the "Exclude other filesystems" search option
AUTHOR
GNOME Search Tool was originally written by George Lebl (<jirka@5z.com>). Version 2 was written by Dennis M. Cranston (<den-
nis_cranston@yahoo.com>).
This manual page was originally written by Jochen Voss <voss@mathematik.uni-kl.de>. Version 2 was written by Dennis M. Cranston (<den-
nis_cranston@yahoo.com>).
SEE ALSO find(1), locate(1), grep(1)gnome-utils 2.27.1 March 16 2009 gnome-search-tool(1)