06-06-2016
Quote:
Originally Posted by
RudiC
Any preferences as to the tool to be used?
We can use awk or sed command.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
hi all...
i need your help, because i donīt know what to do...
i have a flat file like this:
B065200512312004123111010000061451 000021853
B065200512312004123111020000621907 000417802
B065200512312004123111030000005214 000005861
B065200512312004123111040000120133 000088448
and i need... (5 Replies)
Discussion started by: DebianJ
5 Replies
2. Shell Programming and Scripting
Hi All :),
I am very new to unix. I am requiring ur help in developing shell script for below problem.
I have to replace the second field of file with values of array sequentially where first field is ValidateKeepVar
<File>
UT-ExtractField 1 | &LogEntry &Keep(DatatoValidate)... (3 Replies)
Discussion started by: rohiiit.sharma
3 Replies
3. Shell Programming and Scripting
hello all,
I am new to shell scripting and to unix... so the following is my assignment..
here i am trying to insert a values into sqlplus database using shell script.
the following is my shell script
InsertDelete.sh
#! /bin/sh
echo "*********The MENU********
1.Insert The Values... (2 Replies)
Discussion started by: pradeept
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to insert Inverted Commas around all the numeric values within a comma seperated string / variable.
1111,2222,3333,4444
I would like it to be:
'1111','2222','3333','4444'
Note - This string could have a differing amount of numeric values each time the variable is... (4 Replies)
Discussion started by: RichZR
4 Replies
5. Shell Programming and Scripting
HI Guys,
I have a data in a file in the below format
45783
23457
23556
54584
Now i want to convert this data into the below format
reader='45783' or
reader='23457' or
reader='23556' or
reader='54584'
Please help how to convert as i am applying loop but not able to get the data... (6 Replies)
Discussion started by: jaituteja
6 Replies
6. Shell Programming and Scripting
Hey guys, i have a file a.txt and i need to insert a dummy data into it as per the below pattern..
bash: cat a.txt
1234,34
3434,45
4545,56
3434,56
Now i need the file in the below pattern
1234,34,a0001,C_01
3434,45,a0002,C_02
4545,56,a0003,C_03
3434,56,a0004,C_04
here the count of... (3 Replies)
Discussion started by: jaituteja
3 Replies
7. Shell Programming and Scripting
Hello Guru,
I'm trying to insert a value between 2 fields (between last and second last field) But end up the script actually replacing the value in the second last field. What should i put to fix the problem?
Input File:
apple,mango,grape,lemonExpected output:
apple,mango,grape,0,lemon
awk... (5 Replies)
Discussion started by: null7
5 Replies
8. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
9. Shell Programming and Scripting
Hi, please help with this, I need to insert missing values into a matrix for a regression analysis.
I have made up an example. The first three columns are variables with levels and the next 3 are values, the 4th column missing values should be replaced by 0s, and 5th and 6th column missing... (3 Replies)
Discussion started by: ritakadm
3 Replies
10. Shell Programming and Scripting
Hi
The file contains 12 months of date and less than 12 months of data I want to display if date filed less than 12 months of data I want to insert a value amount 1 to amount4 0 and dates as well.
12345|Date|cntry|amount1|amount2|amount3|amoun4... (2 Replies)
Discussion started by: jagu
2 Replies
PYP(1) General Commands Manual PYP(1)
NAME
pyp - The Pyed Piper: A Modern Python Alternative to awk, sed and Other Unix Text Manipulation Utilities
SYNOPSIS
pyp [options] files ...
DESCRIPTION
pyp, the Pyed Piper, is a command line tool for text manipulation. It is similar to awk and sed in functionality, but its subcommands are
Python based, and thus more familiar to many programmers.
It can operate both on a per-line base and on the complete input stream. Different features can be pipelined in a single command by using
the pipe character familiar from shell commands.
pyp backs up its input for reruns with modified commands, and can save commands as macros. On the downside, the rerun feature makes it
unsuitable for continuous pipe operation.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is
included below. For a complete description, use --manual.
-h, --help
Show this help message and exit.
-m, --manual
Prints out extended help.
-l, --macro_list
Lists all available macros.
-s MACRO_SAVE_NAME, --macro_save=MACRO_SAVE_NAME
Saves current command as macro. use "#" for adding
comments EXAMPLE:
pyp -s "great_macro # prints first letter" "p[1]".
-f MACRO_FIND_NAME, --macro_find=MACRO_FIND_NAME
Searches for macros with keyword or user name.
-d MACRO_DELETE_NAME, --macro_delete=MACRO_DELETE_NAME
Deletes specified public macro.
-g, --macro_group
Specify group macros for save and delete; default is user.
-t TEXT_FILE, --text_file=TEXT_FILE
Specify text file to load. For advanced users,
you should typically cat a file into pyp.
-x, --execute
Execute all commands.
-c, --turn_off_color
Prints raw, uncolored output.
-u, --unmodified_config
Prints out generic PypCustom.py config file.
-b BLANK_INPUTS, --blank_inputs=BLANK_INPUTS
Generate this number of blank input lines; useful for
generating numbered lists with variable 'n'.
-n, --no_input
Use with command that generates output with no input;
same as --dummy_input 1.
-k, --keep_false
Print blank lines for lines that test as False.
default is to filter out False lines from the output.
-r, --rerun
Rerun based on automatically cached data from the last run.
Use this after executing "pyp", pasting input into the shell,
and hitting CTRL-D.
SEE ALSO
awk(1), grep(1), sed(1).
AUTHOR
pyp was written by Toby Rosen <tobyrosen@gmail.com>.
This manual page was written by Khalid El Fathi <khalid@elfathi.fr>, for the Debian project (and may be used by others).
March 19, 2012 PYP(1)