Sponsored Content
Top Forums Shell Programming and Scripting How Select numbers from a line of text, and remove leading spaces? Post 302844262 by kcpoole on Sunday 18th of August 2013 02:43:35 AM
Old 08-18-2013
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
Code:
"C 56","Home athletics center","LAC"
"D001","50M Run","50M"
"D003","100M Run","100M"

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

Code:
#!/bin/bash
#set initial variables
file="FILE.EXT"     # input filename

while read line
 do centnum=${line:2:3}                    # find 3 Chars in line
      centnam=$(echo $line | cut -d '"' -f4)    #Extract the Center Name from the file 

done <"$file"
echo D';'$centnum';'$centnam';;M;;' > MM_file.txt

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.

TIA
Ken
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove leading spaces from a line

Hi friends I need some help, I have a file which looks as follows TEMP 014637065 014637065 517502 517502 RTE 517502 517502 RTE AWATER_TEST 12325 23563 588323 2323 5656 32385 23235635 ANOTHER_TEST 12 5433 FTHH 5653 833 TEST 123 123 3235 5353 353 53 35 353 535 3 YTERS GJK JKLS ... (6 Replies)
Discussion started by: lijojoseph
6 Replies

2. Shell Programming and Scripting

sed over writes my original file (using sed to remove leading spaces)

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)
Discussion started by: laser
6 Replies

3. Shell Programming and Scripting

remove trailing and leading spaces using tr command

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)
Discussion started by: sureshg_sampat
5 Replies

4. Shell Programming and Scripting

Not able to remove leading spaces

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)
Discussion started by: panyam
5 Replies

5. OS X (Apple)

Remove leading spaces from file names and folders

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)
Discussion started by: prometheon123
1 Replies

6. UNIX for Beginners Questions & Answers

How do I remove leading spaces in UNIX when count of space character is not fixed? Example below-

Script showStreamsGLIS$reg.$env.ksh gives me output as below- Job Stime Etime Status ExitCode GLIS-AS-S-EFL-LOCK-B ----- ----- OI 103313880/0 GLIS-ALL-Q-EOD-FX-UPDT-1730-B ----- ----- TE 0/0 GLIS-TK-S-BWSOD-B ... (8 Replies)
Discussion started by: Tanu
8 Replies

7. Shell Programming and Scripting

Remove leading and trailing spaces from a file

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)
Discussion started by: svajhala
9 Replies

8. Shell Programming and Scripting

Trying to remove leading spaces

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)
Discussion started by: John K
2 Replies

9. Shell Programming and Scripting

How to remove leading and trailing spaces for variable in shell script?

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)
Discussion started by: pottic
10 Replies

10. UNIX for Beginners Questions & Answers

Tip to remove line endings and spaces on a pre-formatted text file?

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)
Discussion started by: newbie_01
1 Replies
ppmlabel(1)						      General Commands Manual						       ppmlabel(1)

NAME
ppmlabel - add text to a portable pixmap SYNOPSIS
ppmlabel [-angle angle] [-background transparent | colour] [-colour colour] [-file filename] [-size textsize] [-text 'text string'] [-x column] [-y row] ... [ppmfile] DESCRIPTION
ppmlabel uses the text drawing facilities of ppmdraw to add text to a portable pixmap. The location, size, baseline angle, colour of the text and background colour (if any) are controlled by command line arguments. The text can be specified on the command line or read from files. Any number of separate text strings can be added by one invocation of ppmlabel, limited only by the maximum length of the command line. If no ppmfile is specified, ppmdraw reads its input pixmap from standard input. OPTIONS
The arguments on the ppmlabel command line are not options in the strict sense; they are commands which control the placement and appear- ance of the text being added to the input pixmap. They are executed left to right, and any number of arguments may appear. All flags can be abbreviated to their shortest unique prefix. -angle angle Sets the angle of the baseline of subsequent text. angle is specified as an integral number of degrees, measured counterclock- wise from the row axis of the pixmap. -background transparent | colour If the argument is ``transparent'', text is drawn over the existing pixels in the pixmap. If a colour is given (see the -colour switch below for information on how to specify colours), rectangles enclosing subsequent text are filled with that colour. -colour colour Sets the colour for subsequent text. The colour can be specified in five ways: o A name, assuming that a pointer to an X11-style colour names file was compiled in. o An X11-style hexadecimal specifier: rgb:r/g/b, where r g and b are each 1- to 4-digit hexadecimal numbers. o An X11-style decimal specifier: rgbi:r/g/b, where r g and b are floating point numbers between 0 and 1. o For backwards compatibility, an old-X11-style hexadecimal number: #rgb, #rrggbb, #rrrgggbbb, or #rrrrggggbbbb. o For backwards compatibility, a triplet of numbers separated by commas: r,g,b, where r g and b are floating point numbers between 0 and 1. (This style was added before MIT came up with the similar rgbi style.) -file filename Reads text from the file filename and draws it on successive lines. -size textsize Sets the height of the tallest characters above the baseline to textsize pixels. -text 'text string' Draws the given text string (which must be quoted if it contains spaces). The location for subsequent text is advanced by 1.75 times the current textsize, which allows drawing multiple lines of text in a reasonable manner without specifying the position of each line. -x column Sets the column at which subsequent text will be left justified. Depending on the shape of the first character, the actual text may begin a few pixels to the right of this point. -y row Sets the row which will form the baseline of subsequent text. Characters with descenders, such as ``y'', will extend below this line. BUGS
Text strings are restricted to 7 bit ASCII. The text font used by ppmdraw doesn't include definitions for 8 bit ISO 8859/1 characters. When drawing multiple lines of text with a non-transparent background, it should probably fill the space between the lines with the back- ground colour. This is tricky to get right when the text is rotated to a non-orthogonal angle. SEE ALSO
ppmmake(1), ppm(5) AUTHOR
Copyright (C) 1995 by John Walker (kelvin@fourmilab.ch) WWW home page: http://www.fourmilab.ch/ Permission to use, copy, modify, and distribute this software and its documentation for any purpose and without fee is hereby granted, without any conditions or restrictions. This software is provided ``as is'' without express or implied warranty. 14 June 1995 ppmlabel(1)
All times are GMT -4. The time now is 09:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy