How Select numbers from a line of text, and remove leading spaces?
I have a text file with a line of text that contains numbers and text formatted into groups. I need to extract the number that can be either 1,2 or 3 digits long. Then write it to a variable, but i need to remove any leading spaces in the number first.
I can get the numbers out but how to remove the leading spaces?
My test file contents
My Script so far that will pull out the 3 digit number after the first C, and write it to a variable centnum
this is only part of the entire script as the rest will locate only the first line containing the neccessary value
the number in the output file needs to be just the significant digits and is a CSV so can be variable length.
I have tried using sed, but this just parses the entire file at once and I cannot process each line individually.
Thanks and that almost works. I get the 1, 2 or 3 numbers as desired but when I write them out to a resulting file using this line, I now get a space after the numbers.
You could also try something like:
This does all of the processing using shell built-ins (no need to invoke cut or awk) and will work even if $centnam expands to a string containing multiple adjacent whitespace characters.
Hi Don.. Interesting idea but The 2 variables will be written from data withing the text file, Specifically the first line.
Suppose some more context might help, but i was trying to keep it simple :-).
I will have many files to process and all are the same format, and I will need to extract this line out, and then read the Center Number and name, then write them out to another file.
Another part of the script will read the input file and this part only needs to extract the Number and name from this line. The number wil be any number between 1 and 999, and the leading zero is the problem.
Hi Don.. Interesting idea but The 2 variables will be written from data withing the text file, Specifically the first line.
Suppose some more context might help, but i was trying to keep it simple :-).
I will have many files to process and all are the same format, and I will need to extract this line out, and then read the Center Number and name, then write them out to another file.
Another part of the script will read the input file and this part only needs to extract the Number and name from this line. The number wil be any number between 1 and 999, and the leading zero is the problem.
Ken
Your script writes:
into the file MM_file.txt from the last (not first) line of your input file FILE.EXT which you said contains:
At various times you have said that the leading zeros are a problem and that the leading space is a problem. You have not shown us what output you want to be produced. My script processed each line in your input file, stripping off leading spaces and leading zeros and putting:
in MM_file.txtwhich is one line of output for each line of input. If this is not what you want, please explain clearly what output you do want in English and show us the output you want to have produced with the sample input file you provided. (Note that I see no way to get the output you showed in message #4 in this thread:
since 156 does not appear as a number on any of your sample input lines???)
Hi,
At the moment, using Notepad++ to do a search and replace, manually section by section which is real painful. Yeah, so copying each section of the line of text and putting into a file and then search and replace, need at least 3-operations in Notepad++.
Here's hoping I will be able to... (1 Reply)
Hi
I have variable named tablename. The value to tablename variable has leading and trailing white spaces. How to remove the leading and training white spaces and write the value of the tablename without space to a file using shell script. ( for e.g. tablename= yyy )
INPUT
... (10 Replies)
OS : RHEL 6.7
Shell : bash
I am trying to remove the leading the spaces in the below file
$ cat pattern2.txt
hello1
hello2
hello3
hello4
Expected output is shown below.
$ cat pattern2.txt
hello1
hello2
hello3
hello4 (2 Replies)
Hi,
I am trying to remove leading and trailing spaces from a file using awk but somehow I have not been able to do it.
Here is the data that I want to trim.
07/12/2017 15:55:00 |entinfdev |AD ping Time ms | .474| 1.41| .581|green |flat... (9 Replies)
Hi All,
I have a vexing issue with leading spaces in file names. Basically, we're moving tons of data from our ancient afp file share to Box.com and Box forbids leading spaces in files or folders. The HFS file system seems to be perfectly fine with this, but almost all other Unix file systems... (1 Reply)
Hi Experts,
In a file tht i copied from the web , i am not able to remove the leading white spaces. I tried the below , none of them working . I opened the file through vi to check for the special characters if any , but no such characters found.
Your advice will be greatly appreciated.
sed... (5 Replies)
Dear All,
can you please advice how do i remove trailing and leading spaces from a pipe-delimited file using "tr" command
the below cmd, i tried removed all spaces
tr -d ' '<s1.txt>s2.txt1
Many thx
Suresh (5 Replies)
Hello and thx for reading this
I'm using sed to remove only the leading spaces in a file
bash-280R# cat foofile
some text
some text
some text
some text
some text
bash-280R#
bash-280R# sed 's/^ *//' foofile > foofile.use
bash-280R# cat foofile.use
some text
some text
some text... (6 Replies)