Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

searching the required string and appending string to it.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting searching the required string and appending string to it.
# 1  
Old 11-23-2010
searching the required string and appending string to it.
Hi all,

I have some data in the form of

adc|nvhs|nahssn|njadnk|nkfds

in the above data i need to write a script so thet it will append "|||" to the third occurnace in the string ..... the outout should look like

adc|nvhs|nahssn||||njadnk|nkfds


Thanks,
Firestar.
# 2  
Old 11-23-2010
Code:
sed 's/[^|]*|[^|]*|[^|]*|/&|||/'

# 3  
Old 11-23-2010
@jlliagre
Thank you so much for the quick reply ......

Here the solution which you gave works fine for me.... but i am sorry to cofuse you but my Data has not eaxctly 4 feilds it has ogt 74 feilds and i want to appeend the "|||" after 49th feild.......

thanks once again for the quick reply
# 4  
Old 11-23-2010
Code:
sed 's/'$(for i in $(seq 1 49); do printf "%s" '[^|]*|'; done)'/&|||/'

This User Gave Thanks to jlliagre For This Post:
firestar
# 5  
Old 11-23-2010
Quote:
Originally Posted by firestar
Thank you so much for the quick reply ......

Here the solution which you gave works fine for me.... but i am sorry to cofuse you but my Data has not eaxctly 4 feilds it has ogt 74 feilds and i want to appeend the "|||" after 49th feild.......

thanks once again for the quick reply
to replace at the 49th field/occurence of pipe symbol ( | )
Code:
 sed 's/|/|||/49' inputfile

These 2 Users Gave Thanks to michaelrozar17 For This Post:
firestar jlliagre
# 6  
Old 11-23-2010
Much simpler !
# 7  
Old 11-23-2010
@michaelrozar17
Thanks you so much

@jlliagre

thank you so much
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

How to add a new string at the end of line by searching a string on the same line?

Hi, I have a file which is an extract of jil codes of all autosys jobs in our server. Sample jil code: ************************** permission:gx,wx date_conditions:yes days_of_week:all start_times:"05:00" condition: notrunning(appDev#box#ProductLoad)... (1 Reply)
Discussion started by: raghavendra
1 Replies

2. Shell Programming and Scripting

Check file for string existence before appending it with string

I want to append file with a string but before doing that i want to check if this string already exist in that file.I tried with grep on Solaris 10 but unsuccessful.Man pages from grep seems to suggest if the string is found command status will be 0 and if not 1.But i am not finding it.May be i... (2 Replies)
Discussion started by: sahil_shine
2 Replies

3. Shell Programming and Scripting

searching a sub-string in a string

Im trying to download a file from a website. But i want to download only if the file version is latest than the same file I have. The file name is CTP-LATEST-5.3.0.37.iso I need to check the string "37" in the file name. So if the number 37 is greater than the version Im already... (14 Replies)
Discussion started by: srijith
14 Replies

4. Shell Programming and Scripting

Appending string, variable to file at the start and string at end

Hi , I have below file with 13 columns. I need 2-13 columns seperated by comma and I want to append each row with a string "INSERT INTO xxx" in the begining as 1st column and then a variable "$node" and then $2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13 and at the end another string " ; COMMIT;" ... (4 Replies)
Discussion started by: Vaddadi
4 Replies

5. Shell Programming and Scripting

Appending string at the end of the file

Hello, I wanted to append 'XYZ' at the end of the text file. How can i do this? I searched the forums and i am not getting what i want. Any help is highly appreciated. Thanks (2 Replies)
Discussion started by: govindts
2 Replies

6. Shell Programming and Scripting

Need help appending a string to a field

Hi, This is driving me nuts, can't think of any easy way to do it. I need to append a string ".00" only in the third field of a file, and only if it does NOT have a decimal point already Here is what the file looks like- 1400030846,2,17,POL GENERAL 1400030900,3,14.95,FIC GENERAL If... (7 Replies)
Discussion started by: sfisk
7 Replies

7. Shell Programming and Scripting

appending two string is not working

Dear Memebers appending string is not working in loop outside of loop itw working fine, but when i put in loop its not working. please look into this code and suggest me how to do this. supplierCode.txt --------------- UGEN SLAND CEL here is my script ------------------- ... (11 Replies)
Discussion started by: krishna9
11 Replies

8. Shell Programming and Scripting

Extracting a string from one file and searching the same string in other files

Hi, Need to extract a string from one file and search the same in other files. Ex: I have file1 of hundred lines with no delimiters not even space. I have 3 more files. I should get 1 to 10 characters say substring from each line of file1 and search that string in rest of the files and get... (1 Reply)
Discussion started by: mohancrr
1 Replies

9. Shell Programming and Scripting

Sed appending string using for loop?

Hi All, I have been trying to format a file using sed. I can't seem to get the syntax right. I want to append the string from file1.txt to file1.csv with the final output file being file2.csv, but before the string is appended to the end of each line, first insert a comma. Here is the sed... (2 Replies)
Discussion started by: cstovall
2 Replies

10. Shell Programming and Scripting

appending string to text file based on search string

Hi, I need to append string "Hi" to the beginning of the lines containing some specific string. How can I achieve that? Please help. Malay (1 Reply)
Discussion started by: malaymaru
1 Replies
Login or Register to Ask a Question