I have a text file im trying to parse out information after a certain line with a keyword. After this keyword all the information
below it is important to me, but for some reason its stripping all the escape characters or line characters that im needing
to process the information with another script. The other script I run takes this information and makes it delimited so I can
import into mysql. While peeking at the file with cat -vet I need it to look like this:
awk '/../&&d{print}/QUANTITY/{
d=1}' test1.txt > test2.txt
FILE: test1.txt ORIGINAL FILE
--------------------------
----------
----------
----------
----------
---
TABULATION^M$
QUANTITY^M$
^M$
^M$
11111111 GIANTS 222.000 TON^M$
7777 Acme Inc. 6.5000 3,425.50 3,425.50^M$
8888 Pipe Ind, Inc. 1.0000 527.00 527.00^M$
^M$
22222222 BEARS 324.000 TON^M$
7777 Acme, Inc. 148.3800 2,522.46 2,522.46^M$
8888 Pipe Ind, Inc.. 120.0000 2,040.00 2,040.00^M$
--------------------------
----------
----------
----------
----------
-----
With awk it leaves in ^M$ after every line like the following and my other script wont read it right.
test2.txt comes out like this:
FILE: test2.txt
--------------------------
----------
----------
----------
----------
---
11111111 GIANTS 222.000 TON^M$
7777 Acme Inc. 6.5000 3,425.50 3,425.50^M$
8888 Pipe Ind, Inc. 1.0000 527.00 527.00^M$
22222222 BEARS 324.000 TON^M$
7777 Acme, Inc. 148.3800 2,522.46 2,522.46^M$
8888 Pipe Ind, Inc.. 120.0000 2,040.00 2,040.00^M$
--------------------------
----------
----------
----------
----------
-----
What I need test2.txt to look like is the following, I need to remove the ^M but leave the $ at the end of each line, ALSO!
very important for me to process I need to remove the 2 blank lines before the information like you see in the original
file after the word QUANTITY. It must look like this for my other script to work properly.
FILE: test2.txt
--------------------------
----------
----------
----------
----------
---
11111111 GIANTS 222.000 TON$
7777 Acme Inc. 6.5000 3,425.50 3,425.50$
8888 Pipe Ind, Inc. 1.0000 527.00 527.00$
$
22222222 BEARS 324.000 TON$
7777 Acme, Inc. 148.3800 2,522.46 2,522.46$
8888 Pipe Ind, Inc.. 120.0000 2,040.00 2,040.00$
--------------------------
----------
----------
----------
----------
-----
Thanks in advance for any help you can offer.
Start Free Trial
