Sponsored Content
Top Forums Shell Programming and Scripting Finding a text in files & replacing it with unique strings Post 302761521 by gordom on Friday 25th of January 2013 07:43:11 PM
Old 01-25-2013
Finding a text in files & replacing it with unique strings

Hallo Everyone.
I have to admit I'm shell scripting illiterate . I need to find certain strings in several text files and replace each of the string by unique & corresponding text.
I prepared a csv file with 3 columns: <filename>;<old_pattern>;<new_pattern>

Code:
dominik@dominik-VirtualBox:~/Pulpit/test/1$ cat file.csv
 file1.txt;abc;123
 file2.txt;XYZ;6789

A very kind guy (much more skilled than me) helped me with the script:

Code:
dominik@dominik-VirtualBox:~/Pulpit/test/1$ cat script.sh
 for i in `cat file.csv`; do
 file=`echo $i | cut -d ";" -f1`;
 pattern1=`echo $i | cut -d ";" -f2`;
 pattern2=`echo $i | cut -d ";" -f3`;
 sed -i "s/$pattern1/$pattern2/" $file;
 done

To find & replace text I run the script and grep:

Code:
dominik@dominik-VirtualBox:~/Pulpit/test/1$ bash script.sh
dominik@dominik-VirtualBox:~/Pulpit/test/1$ grep . file{1,2}*

With the above file.csv example the script works fine and do what's intended. The problem starts if <old_pattern> and <new_pattern> text have white spaces:

Code:
dominik@dominik-VirtualBox:~/Pulpit/test/1$ cat file.csv
 file1.txt;abc jkl nm;1 2 3
 file2.txt;XYZ rt;67 89

In that case script returns errors.I tried to modify file.csv by putting text between quotation marks but it didn't help. How the script should be adjusted to work with text consisting of white spaces? I would appreciate any help from you. Thank you very much in advance. Regards,
gordom

Last edited by gordom; 01-28-2013 at 09:20 AM.. Reason: deleting text formatting
 

10 More Discussions You Might Find Interesting

1. Solaris

finding & replacing blank rows/spaces in a file

Can anyone help me find and replace blank rows in a file with a numeric value (ie blankrow=someTxtOrNumValue), the file is over 500,000 rows long so it would need to be the quickest way as I'll need to do this for multiple files...I would be greatfull for any suggestions....thanks sample file:... (2 Replies)
Discussion started by: Gerry405
2 Replies

2. Shell Programming and Scripting

replacing strings with text from other file

Hi, Im trying to update some properties files with text from another file: file1 user=xyz file2 user= after script file2 user=xyz Im using this reading the $QUARTZURL,ETC... from quartz.properties: echo... (1 Reply)
Discussion started by: mc1392
1 Replies

3. Shell Programming and Scripting

help with finding & replacing pattern in a file

Hi everyone. Could u be so kind and help me with on "simple" shell script? 1. i need to search a file line by line for a pattern. example of a lines in that file 2947 domain = feD,id = 00 0A 02 48 17 1E 1D 39 DE 00 0E 00,Name Values:snNo = f10 Add AttFlag = 0 2. i need to find... (0 Replies)
Discussion started by: dusoo
0 Replies

4. UNIX for Dummies Questions & Answers

Finding & Replacing specific Fields

All I have a very large file (aproximately 150,000) as shown below separated by pipe "|". I need to replace data in 2, 16, 17, 23 fields that are of time stamp format. My goal is to look in those fields and it ends with "000000|" then replace it with "000|". In other words, make it as 6 digit... (2 Replies)
Discussion started by: ddraj2015
2 Replies

5. UNIX for Dummies Questions & Answers

Finding Unique strings which match pattern

I need to grep for a pattern in a file. Files are huge and have several repeated occurances of the strings which match pattern. I just need the strings which contain the pattern in the output. For eg. The contents of my file are as follows. The pattern I want to match by is ABCD ... (5 Replies)
Discussion started by: tektips
5 Replies

6. Homework & Coursework Questions

Finding/replacing text and redirection help

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: What command would rename "sequentialInsert", in ~cs252/Assignments/commandsAsst/project/arrayops.h, to... (2 Replies)
Discussion started by: lothwen
2 Replies

7. Shell Programming and Scripting

Replacing variable Text between fixed strings

Hello all, This is my first post and I hope you can help me out. I searched for quite some hours now and haven't found a simple solution to my problem. It is as following: I got this file: dl.dropbox.com/u/14586156/stuff/Bookmarks.plist and want to replace the Text between... (9 Replies)
Discussion started by: pasc
9 Replies

8. Shell Programming and Scripting

Extended replacing of nonspecific strings in text files [beware complicated !]

Well, to make another post at this helpful forum :b::D: I recently tried something like this, I want to replace all those numberings/letters that are located between <string>file://localhost/var/mobile/Applications/ and /Documents/</string> numberings =---- replace with: first... (6 Replies)
Discussion started by: pasc
6 Replies

9. Shell Programming and Scripting

Finding/replacing strings in some files based on a file

Hi, We have a file (e.g. a .csv file, but could be any other format), with 2 columns: the old value and the new value. We need to modify all the files within the current directory (including subdirectories), so find and replace the contents found in the first column within the file, with the... (9 Replies)
Discussion started by: Talkabout
9 Replies

10. Shell Programming and Scripting

Command to show unique strings in two files

how to display the unique strings in two files using shell script or commands. I tried diff and cmp but it shows the entire line, i need only the mismatched strings. File1: sat,sun,mon,tue rose,lilly,lotus white,red,blue,green,pink File2: sat,sun,mon,tue rose,sunflower,lotus... (4 Replies)
Discussion started by: Arun_Linux
4 Replies
xstr(1) 						      General Commands Manual							   xstr(1)

NAME
xstr - Extracts strings from C programs to implement shared strings SYNOPSIS
xstr [-c] [file | -] The xstr command maintains a file called strings into which strings in component parts of a large program are hashed. OPTIONS
Extracts strings from the specified file. DESCRIPTION
The strings extracted by xstr are replaced with references to this array. This serves to implement shared constant strings, most useful if they are also read-only. The following command extracts the strings from the C source in file, replacing string references by expressions of the form (&xstr[num- ber]) for some number. xstr -c file The xstr command uses file as input; the resulting C text is placed in the file x.c to then be compiled. The strings from this file are appended to the strings file if they are not there already. Repeated strings and strings that are suffixes of existing strings do not cause changes to the file. If a string is a suffix of another string in the file, but the shorter string is seen first by xstr, both strings are placed in the file strings. After all components of a large program are compiled, a file xs.c declaring the common xstr space can be created by a command of the fol- lowing form: xstr Compile and load this xs.c file with the rest of the program. Some C compilers may, by default, put strings in a read-only text section. The xstr command can also be used on a single file. The following command creates files x.c and xs.c as before, without using or affecting a strings file in the same directory. xstr file It may be useful to run xstr after the C preprocessor if any macro definitions yield strings or if there is conditional code that contains strings that may not be needed. The xstr command reads from its standard input when the argument - (dash) is given. An appropriate command sequence for running xstr after the C preprocessor is as follows: cc -E file.c | xstr -c - cc -c x.c mv x.o file.o The xstr command does not touch the file strings unless new items are added, thus make can avoid remaking xs.o unless truly necessary. EXAMPLES
To extract the strings from the C source in the file.c parameter, replacing string references by expressions of the form (&xstr[number]), enter: xstr -c file An appropriate declaration of the xstr array is prepended to file. The resulting C text is placed in the file x.c, to then be com- piled. To declare the common xstr array space in the xs.c file, enter: xstr FILES
File that contains the extracted strings. Modified C source. C source for definition of array xstr. Temporary file when the xstr command does not touch strings. SEE ALSO
Commands: mkstr(1) xstr(1)
All times are GMT -4. The time now is 10:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy