Shell script for .Txt to .csv conversion with data processing
Hi experts,
I want to convert a txt file having rows and columns (CNAI_DUMP_raw.txt) by comparing it with another text file (paramaters.txt) and generate a output in CSV which contains only 3rd column from CNAI_DUMP_raw.txt, and the columns mentioned in parameters.txt.
FYI: There are two columns in parameters.txt one containing some column name from CNAI_DUMP.txt and other with the ideal value against it.
The output should contain actual value of the cell and the ideal value mentioned in parameters.txt.
Hi There
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... (8 Replies)
Hi,
I have gps receiver, by using gpsd data i can read gps log data to my database(my sql).
Steps:
1. telenet localhost 2947 > gps.txt (press enter)
2. r (press enter) //then i will get the data like below in gps.txt file
Trying 127.0.0.1...
Connected to localhost.... (1 Reply)
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)
thanks for allowing me join your forum
i have an output of linux command "who"
which provides following details.....
CURRENT USER/ACCT INFO
17:31:36 up 4:49, 4 users, load average: 0.03, 0.04, 0.00
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root :0 - 12:59 ?xdm? 4:54 0.02s /bin/sh /usr/bi... (1 Reply)
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Hi Unix Gurus,
I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results:
Title ID Owner Priority Estimate Project Change Date Changed By
Complexity Create Date Created By Detail Estimate Total De tail... (6 Replies)
Hi Everyone ,
Below is output from a TL1 , I want just the NE Name: and beside that the Temperature and the voltages in a csv file , Is this possible?
> act-user:AB1S2a:ArshadFO:493::**********;
AB1S2a 2016-02-07 10:13:24
M 493 COMPLD
"ArshadFO:2016-02-07 10-04-55,0"
;... (11 Replies)
Hello Unix Shell Script Experts,
I have a script that would mask the columns in .csv file or .txt file.
First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder.
Two parameters are passed
... (5 Replies)
i have written my shell script in notepad however i am struggling to pass the data file to be read to the script the data file is of .txt format. My target is to run the shell script from the terminal and pass 3 arguments e.g. polg@DESKTOP-BVPDC5C:~/CS1420/coursework$ bash valsplit.sh input.txt... (11 Replies)
Discussion started by: Gurdza32
11 Replies
LEARN ABOUT DEBIAN
trcs
trcs(1) User Manuals trcs(1)NAME
trcs - convert text files from one codeset to other
SYNOPSIS
trcs -C | -l | -h
trcs [-s] [-f input-codeset ] [-t output-codeset ] [ file ]...
DESCRIPTION
trcs is a program for translation of text files from one codeset to other. When exact translation is impossible it tries to make approxi-
mations. For example pseudographic characters are approximated by ASCII characters in codesets that have no pseudographic characters and
characters with diacritical marks are approximated by existing characters.
If the option -s or --gen-script is given trcs will generate simple script that invokes tr(1) This is useful if you want to include this in
your script or for faster conversion of many files.
If none of -C, -s, -l, -h and their equivalents is given each file will be read assuming it is coded with codeset input-codeset On standard
output it will be recoded so to use codeset output-codeset If there is no file given trcs will act as filter. Both input-codeset and out-
put-codeset are case insensitive and default to `cp1251'.
OPTIONS -C, --copyright
Display copying conditions and warranty information.
-s, --gen-script
Generates conversion script for given input and output encodings instead to convert text files.
-l, --list
List all known codesets with their aliases.
-h, --help
Display this help and exit.
-f input-codeset, --from[=]input-codeset
Codeset of the source.
-f output-codeset, --to[=]output-codeset
Codeset of the output.
EXAMPLES
trcs -fcyrillic -t koi8-r letter.txt
Convert letter.txt from ISO-8859-5 (cyrillic) to KOI8-R and output the result on standard output.
trcs --from cp437 --to=mik --gen-script >ibm2mik
Generates script ibm2mik for converting from CP437 to MIK.
sh ibm2mik screen.txt
Convert screen.txt from CP437 to MIK. Output the result on standard output. Without parameters ibm2mik acts as filter.
AUTHOR
Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg>
SEE ALSO tr(1)Linux JUN 2000 trcs(1)