Format numbers using bash?

turtlegeek · 02-26-2011, 09:29 AM

My Mac sed does have an option similar to -r, it's -E:

This works for my PowerMac running Mac OS Tiger 10.4.11:

Code:

echo " 1234567890 " | \
sed -E '
: L
s=([0-9]+)([0-9]{3})=\1,\2=
t L'

But I must say that this version of sed does not accept semicolons (

in place of newlines.

Per archtoad's comments, 1,10,11: it's my pleasure. 2 can be answered above.
3. This will happen soon, hopefully.
4. Separate lines were necessary for me but you did improve the entry!
5. True but a good illustration of the use of \b.
6. My habit to put the -e option there is a mnemonic device to curb my zealousness!
7. I found the use of '=' as a delimiter to be original (to me) and instructive.
My use of / delimiters here is my custom derived from years of vi use and man reading.
I find slashes and vertical bars are visually helpful when reading replacement commands.
it's probably redundant here but the man page said it well:
"
Any character other
than backslash or newline can be used instead of a slash to
delimit the RE and the replacement. Within the RE and the
replacement, the RE delimiter itself can be used as a literal
character if it is preceded by a backslash.
"
8. "[0-9]+" is not allowed by my version of BRE. On impulse, I tried using the asterisk ("*")
but it caused sed to spin. "[0-9]{4,19}" leaves out the first comma in the example number.

9. "g", like my -e is unnecessary but did no damage either.

Reuti,

Good suggestion. I could not justify the trouble to learn the compile environment
until I saw the code from archtoad.

gnashley · 02-26-2011, 09:52 AM

"So I spent a few minutes" -from the date of the thead it seems more like a couple of years...

archtoad6 · 02-26-2011, 10:51 AM

turtlegeek,

Nice post, I'll give you rep for it when I'm allowed to again.

Quote:

Originally Posted by gnashley

"So I spent a few minutes" -from the date of the thead it seems more like a couple of years...

Ho :-], HO

, HO

Reuti · 02-26-2011, 11:26 AM

Quote:

Originally Posted by turtlegeek

Reuti,

Good suggestion. I could not justify the trouble to learn the compile environment
until I saw the code from archtoad.

When you install Xcode, you also get the gcc installed. To compile sed then in a different version is like:

Code:

$ wget ftp://ftp.gnu.org/gnu/sed/sed-4.2.1.tar.gz
--2011-02-26 18:07:39--  ftp://ftp.gnu.org/gnu/sed/sed-4.2.1.tar.gz
           => `sed-4.2.1.tar.gz'
...
$ tar -xf sed-4.2.1.tar.gz
$ cd sed-4.2.1
$ ./configure --prefix=$HOME/local/sed-4.2.1
...
$ make
...
$ make install
...
$ cd
$ export PATH=$HOME/local/sed-4.2.1/bin:$PATH

You can download also with the browser, as I installed wget also afterwards as it’s not included in the Mac by default

Nominal Animal · 02-27-2011, 03:38 PM

This Bash function also adds thousands separators. It is string-based, so it assumes the value is an integer. If the value contains an odd number of negative signs "-" (anywhere), it will be output as negative.

Code:

# Usage: printnum [-n] [-e] [-s,] value
printnum () {
    local separator=","
    local options=()
    while [ $# -gt 0 ]; do
        if [ "$1" == "-n" ]; then
            options=("${options[@]}" "-n")
            shift 1
        elif [ "$1" == "-e" ]; then
            options=("${options[@]}" "-e")
            shift 1
        elif [ "${1:0:2}" == "-s" ]; then
            separator="${1:2}"
            shift 1
        else
            break
        fi
    done
    local number="${1//[^0123456789]/}"
    local prefix="${1//[^-]/}"
    local prefix=$[ (${#prefix} -0) % 2]
    if [ $prefix -gt 0 ]; then
        local prefix="-"
    else
        local prefix=""
    fi
    local suffix=""
    shift 1
    while [ ${#number} -gt 3 ]; do
        local index=$[${#number} -3]
        if [ ${#suffix} -gt 0 ]; then
            suffix="${number:$index}$separator$suffix"
        else
            suffix="${number:$index}"
        fi
        number="${number:0:$index}"
    done
    if [ ${#number} -gt 0 ]; then
        if [ ${#suffix} -gt 0 ]; then
            suffix="$number$separator$suffix"
        else
            suffix="$number"
        fi
    fi
    echo "${options[@]}" "$prefix$suffix"    
}

This function can easily be extended to parse multiplier suffixes (k, M, G, T, P), and/or to output an optional decimal part from a separate argument, even with optional divisor suffixes (d,c,m,u/µ,n,p,f). It's not as good as locale conversion, but should suffice for shell scripts.

Quanswers · 03-29-2015, 10:44 AM

I'm using CrunchBang 11 "Waldorf" (derived from Debian 7 "Wheezy")
There's a BASH command called 'rev' that reverses characters in
a line, thus simplifying the work sed has to do.
(the last sed gets rid of any leading comma's that might occur)

$ echo 123456 | rev | sed -r 's/([0-9]{3})/\1,/g' | rev | sed 's/^,//'
123,456

$ echo 12345678901234567890 | rev | sed -r 's/([0-9]{3})/\1,/g' | rev | sed 's/^,//'
12,345,678,901,234,567,890

rtmistler · 03-30-2015, 06:47 AM

Quote:

Originally Posted by Quanswers

I'm using CrunchBang 11 "Waldorf" (derived from Debian 7 "Wheezy")
There's a BASH command called 'rev' that reverses characters in
a line, thus simplifying the work sed has to do.
(the last sed gets rid of any leading comma's that might occur)

$ echo 123456 | rev | sed -r 's/([0-9]{3})/\1,/g' | rev | sed 's/^,//'
123,456

$ echo 12345678901234567890 | rev | sed -r 's/([0-9]{3})/\1,/g' | rev | sed 's/^,//'
12,345,678,901,234,567,890

Just a heads up to note that you've resurrected a very old post, greater than 4 years since last prior post.

The forum should have warned you about that fact to alert you that maybe continuing the discussion is not too germane.

Looks like you were wishing to add to the answer. Genial enough, but I'm guessing that it might not benefit the original poster any longer.

In the event where you find a similar thread but have a continued question, I realize that's not the case here, but a style to consider would be to refer to the much older thread with an entirely new thread to present a current problem/question.