|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Change text at a variable position
Post 302732757 by KobusE on Monday 19th of November 2012 05:57:16 AM
11-19-2012
Change text at a variable position
Hi there script guru's
I have an input file /tmp/in.txt of which the data is seperated by a : (example of the data)
test1:zz:2000:2000:zzz
te:a:2000:3333:bbb
testabs:x:2004:3000:cccc
I would like to run a scrip (bash) changing the data after the second ":"
example
Test for the value of 2000. If the value is 2000 do
Change the 2000 on line one(after the second ":" to 5000 - but do not change the 2000 after the third
The second line's 2000 must also changed to 5000
The 3rd line must not change (value ne 2000)
The data may vary, but the only changes that must be made to the text file will be between the second and 3rd ":"
Any help would be appreciated
Thx
I have an input file /tmp/in.txt of which the data is seperated by a : (example of the data)
test1:zz:2000:2000:zzz
te:a:2000:3333:bbb
testabs:x:2004:3000:cccc
I would like to run a scrip (bash) changing the data after the second ":"
example
Test for the value of 2000. If the value is 2000 do
Change the 2000 on line one(after the second ":" to 5000 - but do not change the 2000 after the third
The second line's 2000 must also changed to 5000
The 3rd line must not change (value ne 2000)
The data may vary, but the only changes that must be made to the text file will be between the second and 3rd ":"
Any help would be appreciated
Thx
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have following format in file aaa with content below, and would like to seek help from forumer about how to change and swap the position on 2nd field.
5874957|901125|
95874960|650614|
95874966|870308|
901125 to be changed as 25-11-1990 for eg
Can someone help please ?? :)
... (6 Replies)
Discussion started by: cedrichiu
6 Replies
2. Shell Programming and Scripting
Hi All,
I wish to cut an input by using the below command but i would want to have the cut position as a variable.
For eg, the position number is 11 now and i wish that this number is being assigned to a variable before putting into the cut function.
Can this be done ?
Can any expert help?... (1 Reply)
Discussion started by: Raynon
1 Replies
3. Shell Programming and Scripting
I need help in removing a leading zero in a particular position.
For eg.: XYZ*04567472*0099*020091231*0123*0.12
In the above line, I want to replace "*0123" with "123" and "0.12" with ".12". I want to remove the leading zero only in position number 4 and 5 (the bolded segments)
I was able... (10 Replies)
Discussion started by: ananthmm
10 Replies
4. Shell Programming and Scripting
Hi everyone,
Please some help over here. (I´m using cygwing)
I have files with 40 columns and 2000 lines in average. I´m trying to change the order position as follow.
Original columns position:... (3 Replies)
Discussion started by: cgkmal
3 Replies
5. Shell Programming and Scripting
I want to remove text from nth position to nth position couple of times in same line
my line is
"hello is there anyone can help me with this question"
I need like this
ello is there anyone can help me with question
'h' is removed and 'this' removed from the line. I want to do this... (5 Replies)
Discussion started by: elamurugu
5 Replies
6. Shell Programming and Scripting
Hi all
let's say i have a file named 1234_v2_abcd
i need to find the position of the character located after _v, in above case this would be character number 2
the count of the characters before _v can change, but i always have a number after _v
can anybody help :) (4 Replies)
Discussion started by: gigagigosu
4 Replies
7. Shell Programming and Scripting
Hi All,
input file:
echo "a|b|c|d|test|123|same" | awk 'BEGIN {FS=OFS="|"} {print $1,$2,$7,$4,$5,$6}'
Got Output :
a|b|same|d|test|123
This is the sample input file with less fields. But my original file contains more field values. How to replace last value to 3rd postion value. Because... (8 Replies)
Discussion started by: Jairaj
8 Replies
8. UNIX for Dummies Questions & Answers
Hi I have a text file that I want to change some of the characters based on their position. My file contain multiple lines and characters should be counted continuously line by line. For example, I want to convert the 150th T to C. What can I do? Here is a portion of my file:... (10 Replies)
Discussion started by: a_bahreini
10 Replies
9. UNIX for Beginners Questions & Answers
Goodmorning,
I know how to cut a string and a column, and how to find a word.
I have a file with over 100 columns. All columns have a title in the first line. I have to delete all columns with the XXX title.
I can't use cut -f because the position of XXX columns change in each file, and in... (14 Replies)
Discussion started by: echo manolis
14 Replies
10. Programming
I have a file which records banking transactions say like below.
user1 has deposited 10,000$ in his account
user2 has deposited 11,000$ in his account
user1 has withdraw today 5000$ from his account.
Lets say i read this file and convert each line as a list.
username= word
action=... (1 Reply)
Discussion started by: sahil_shine
1 Replies
LEARN ABOUT REDHAT
unix2dos
unix2dos(1) General Commands Manual unix2dos(1) NAME
unix2dos - UNIX to DOS text file format converter SYNOPSYS
unix2dos [options] [-c convmode] [-o file ...] [-n infile outfile ...] Options: [-hkqV] [--help] [--keepdate] [--quiet] [--version] DESCRIPTION
This manual page documents unix2dos, the program that converts text files in UNIX format to DOS format. OPTIONS
The following options are available: -h --help Print online help. -k --keepdate Keep the date stamp of output file same as input file. -q --quiet Quiet mode. Suppress all warning and messages. -V --version Prints version information. -c --convmode convmode Sets conversion mode. Simulates unix2dos under SunOS. -o --oldfile file ... Old file mode. Convert the file and write output to it. The program default to run in this mode. Wildcard names may be used. -n --newfile infile outfile ... New file mode. Convert the infile and write output to outfile. File names must be given in pairs and wildcard names should NOT be used or you WILL lost your files. EXAMPLES
Get input from stdin and write output to stdout. unix2dos Convert and replace a.txt. Convert and replace b.txt. unix2dos a.txt b.txt unix2dos -o a.txt b.txt Convert and replace a.txt in ASCII conversion mode. Convert and replace b.txt in ISO conversion mode. unix2dos a.txt -c iso b.txt unix2dos -c ascii a.txt -c iso b.txt Convert and replace a.txt while keeping original date stamp. unix2dos -k a.txt unix2dos -k -o a.txt Convert a.txt and write to e.txt. unix2dos -n a.txt e.txt Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt. unix2dos -k -n a.txt e.txt Convert and replace a.txt. Convert b.txt and write to e.txt. unix2dos a.txt -n b.txt e.txt unix2dos -o a.txt -n b.txt e.txt Convert c.txt and write to e.txt. Convert and replace a.txt. Convert and replace b.txt. Convert d.txt and write to f.txt. unix2dos -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt DIAGNOSTICS
BUGS
The program does not work properly under MSDOS in stdio processing mode. If you know why is that so, please tell me. AUTHOR
Benjamin Lin - ( blin@socs.uts.edu.au ) MISCELLANY
Tested environment: Linux 1.2.0 with GNU C 2.5.8 SunOS 4.1.3 with GNU C 2.6.3 MS-DOS 6.20 with Borland C++ 4.02 Suggestions and bug reports are welcome. SEE ALSO
dos2unix(1) 1995.03.31 unix2dos v2.2 unix2dos(1)