Divide numbers in a line with sed

Michael M. Published at Dev

Michael M.

I have a line :

CITY;+41119;-754831

I want to divide the two numbers by 10000 to get this line :

CITY;4.1119;-75.4831

I've tried the following sed command but it does nothing, what's wrong ?

sed 's/(.*;.*)([0-9]{4};.*)([0-9]{4})/\1\.\2\.\3/g'

anubhava

awk is better tool for performing floating point arithmetic:

x='CITY;+41119;754831'
awk -F';' -v d=10000 '{print $1,($2/d),($3/d)}' OFS=';' <<< "$x"
CITY;4.1119;75.4831

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-3

Comments

0 comments

From Dev

Removing line numbers with sed

From Dev

How to print line numbers changed by sed / awk

From Dev

Perform sed operations on given line numbers

From Dev

How can I write a sed script to delete numbers from a line?

From Dev

How can I write a sed script to delete numbers from a line?

From Dev

Is it possible to match multiple specific line numbers (not range) with sed?

From Dev

Awk/sed: add line numbers to text from within a range

From Dev

sed/awk: replace numbers in a line after last occurance of '.'

From Dev

grep and sed only the numbers from a text file's line

From Dev

Remove lines are between two line numbers (or patterns) with sed [no duplicate]

From Dev

Generate numbers that divide evenly

From Dev

Sed or AWK: Add line after each ocurrance of pattern between a range of line numbers

From Dev

Apply sed line by line

From Dev

Precision of numbers, multiply and divide by 100

From Dev

Divide byte into two smaller numbers

From Dev

R - Divide numbers between rows

From Dev

Divide Huge Array of Numbers in Buckets

From Dev

Print lines using line-numbers stored in shell variable, using sed

From Dev

Sed: Scraping a Range of Numbers

From Dev

Numbers, parentheses and sed

From Dev

Replace a block of numbers in sed

From Dev

Piping Multiple Numbers into Sed

From Dev

Inserting numbers with sed in Linux?

From Dev

Filtering a line with sed

From Dev

sed - match NOT beginning of line

From Dev

Multi line replace in SED

From Dev

Is sed line deletion atomic?

From Dev

Sed/Awk line double

From Dev

Omit the last line with sed

Related Related

Article