4

Replace char between chars - help nedeed

view full story
linux-howto

http://www.unix.com – Hello, I have a csv file with "^" as text delimiters and "|" as field delimiters. It's converted from a xls file. One record looks like this: Code: ^Tablete Internet^|Archos|501838|^Tableta Internet ARCHOS 80 G9 ...| ... (more lines) ... "501|838"^|330.00|USD|sl|12|0|Link|^router wireless 150 Mbps^|^5 ron^|more|^other info^| I have bolded the "|" which is delimiting the actual fields. I need to replace the "|" and newlines which can apear multiple times in the 4th field which is also delimited by the text delimiters "^". (HowTos)

robot1's picture
Submitted by robot1 on 07/07/2012 – Made popular on 07/07/2012

Stories similar to Replace char between chars - help nedeed

Hi All,

I need to create a script to process on 10 files.

I have a file which contains fields comma separated & with each field surrounded by quotes. The 4th field contains either a serial number, the text ABC, the text XYZ or it's blank. I want to only extract records which have a serial number.

Condition check using awk 18 weeks 5 days ago

Hi, I have a file in the following format

Code: "SYLVESTER,WILLARD G"|"S00633600"|"221052958A"|"H2256"|"015"|""|"00000042BASJ"|"665303"|"N"|"20100211"|"380.4"|""|""|""|"5400"|"20110218"|""|"20110218"|"FEESC&qu

Hi guys,i am trying to set up Vim as my C++ IDE since 2 days and no success so far.I have installed Vim pacman -Q vim vim 7.3.661-1I have downloaded vim-latex and clang tar balls,extract and place appropriate directorys in ~/.vim e.g.

Shell Scripting 2 years 44 weeks ago

I need a utility which will scan in a text file and search and replace strings. I also want to keep track of how many strings I've replaced. The following is an example paragraph and which text to replace.

"Bill Gates" with "Mr. Noodles", "Gates" with "Noodles",

Need help with sed and regexp 38 weeks 5 days ago

Hi everyone, I would really appreciate any help I could get on the following topic. I am not very familiar with reg expressions nor with sed, I just know the basic uses. What I am trying to do is the following: I have a huge text file where I would like to replace all occurnces of a certain pattern with another one.

I have a file1.txt

file1.txt

Code: F-120009210","Felix","U-M-F-F-F-","white","yes","no","U-M-F-F-F-","Bristol","RI","true" F-120009213","Fluffy","U-F-","white","yes","no","M-F-","Warwick","RI","true" U-12

I have the following data in a text file.

Code: "A",1,"MyTextfile.CSV","200","This is ,line one" "B","EFG",23,"MyTextfile1.csv","5621",562,"This is ,line two" I want to extract the fileNames MyTextfile.CSV and MyTextfile1.csv. The problem is not all the lines are delimited with "," There are

Help for File Modification 1 year 13 weeks ago

Hi All, I have a file. This file contain huge amount of data. I want to modify this file. I want enter new line when count of "~ character is 79.