Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
scripting help (awk or sed)
Hello... Currently I'm trying to run a sed routine to change to | if there is a double space. Problem being that I found one record (could be more) that have a double space in the address line other then between the city/state. sed -e 's/,/|/g' -e 's/ CT 0/|CT|0/g' -e 's/ /|/g' -e 1,5d... -
scripting help (awk or sed)
Hello, I have a file that has something like this: 1245|123 CHURCH CT STRATFORD CT 02323|$1234.56|MORE INFO 1246|234 GREEN ST SALEM OR 97305|$11223.43|MORE INFO 1247|12 DAYLIGHT LN ALBANY OR 97321|$23.00|MORE INFO I'm trying to format as follows so I can use awk to pull fields and place in... -
sed replacement between characters
olded, thanks for your response. I attempted to get that example to work. I just left it as is so it would changed the , to a - but didn't have any luck. Here is what I had with results. This is way over my head in regards to understanding what each character is doing (or what it causes... -
sed replacement between characters
Howdy... new to sed/awk scripting so hopefully I can get some assistance here. I have multiple lines of data in a file that are comma delimited. Here is an example: Advantage 12,5650,01/03/2011,Refinancing,4.24,144,"Conventional (Any loan other than GHA, VA, FSA, or RHS...
