I often make a list of measurements in feet and inch. Then have to pull my calculator to add them all up. Is there a way to build the workflow to do this for me?
Input:
5' 6"
3' 8"
Output:
9' 2"
Discussion started with RV: Forums New Discussion workflow
Here's a fairly simple regex-based Python script/workflow:
For simplicity's sake, it only supports integers, but extending it to handle floating-point values wouldn't be very difficult (wasn't sure if you'd actually need it).
Thank you that's almost exactly what I was looking for.
What would it take to add fractions to the script and what would it have to be 8.5" or 8 1/2".
Thanks
feet_and_inches() can be expressed in just a few lines of code for floating point values. I will have to think a bit more to deal with fractions.
# coding: utf-8
def feet_and_inches(s='''5.5' 6.5" 3.6' 8.6"'''):
inches = sum(float(x.replace("'", '')) * 12 if "'" in x
else float(x.replace('"', '')) for x in s.split())
return '{:g}\' {:g}"'.format(inches // 12, inches % 12)
if __name__ == '__main__':
test_data = '''5' 6"
5' 6" 3' 8"
5' 6.5" 3' 8.5"
5.5' 6" 3.5' 8"
5.5' 6.5" 3.5' 8.5"
5.5' 6.5" 3.5' 8.6"
5.5' 6.5" 3.6' 8.6"'''.splitlines()
print('=' * 20)
for line in test_data:
print('{:>19} ==> {}'.format(line.strip(), feet_and_inches(line)))
I believe that this version deals with all the cases but I would not be shocked if there were problems...
#!/usr/bin/env python
# coding: utf-8
from __future__ import (absolute_import, division, print_function, unicode_literals)
def fractions_to_floats(s):
frac_part = ''
output = []
for x in reversed(s.split()): # processing terms from right to left
a, _, b = x.partition('/')
if b:
frac_part = '{}{}'.format(int(a) / int(b.strip('\'"')), b[-1])
else:
if x[-1] in '\'"':
output += [x, frac_part]
else:
output.append(x + frac_part.lstrip('0'))
frac_part = ''
output.append(frac_part)
return ' '.join(output)
def feet_and_inches(s='''5.5' 6.5" 3.6' 8.6"'''):
if '/' in s:
s = fractions_to_floats(s)
assert '/' not in s, 'fractions_to_floats() failed: ' + s
inches = sum(float(x.replace("'", '')) * 12 if "'" in x
else float(x.replace('"', '')) for x in s.split())
return '{:g}\' {:g}"'.format(inches // 12, inches % 12)
if __name__ == '__main__':
test_data = '''
0
1
6"
13
14"
5'
4' 1' "4
4' 5" 1'
5' 6"
5' 6" 1"
5' 6" 3' 8"
5' 6.5" 3' 8.5"
5.5' 6" 3.5' 8"
5.5' 6.5" 3.5' 8.5"
5.5' 6.5" 3.5' 8.6"
5.5' 6.5" 3.6' 8.6"
15 1/64"
15 1/32"
15 1/16"
15 1/8"
15 1/4"
15 1/2"
0' 1" 2' 3" 4' 5" 6 7/8"
15 1/16'
15 1/8'
15 1/4'
15 1/2'
16' 2 1/16"
16' 2 1/8"
16' 2 1/4"
16' 2 1/2"
16 1/2' 2 1/16"
16 1/2' 2 1/8"
16 1/2' 2 1/4"
16 1/2' 2 1/2"
16' 1' 2 1/16"
16' 1' 2 1/8"
16' 1' 2 1/4"
16' 1' 2 1/2"
16.5' 1' 2 1/16"
16.5' 1' 2 1/8"
16.5' 1' 2 1/4"
16.5' 1' 2 1/2"'''.splitlines()
print('=' * 20)
for line in test_data:
print('{:>24} ==> {}'.format(line.strip(), feet_and_inches(line)))
Thank you for your time. How would you add that first code to this code?
import editor
import re
def main():
text = editor.get_selected_text()
feet = sum(int(x) for x in re.findall(r"(\d+)'", text))
inches = sum(int(x) for x in re.findall(r'(\d+)"', text))
if not (feet or inches):
return
feet += (inches / 12)
inches %= 12
replacement = '%i\' %i"' % (feet, inches)
start, end = editor.get_selection()
editor.replace_text(start, end, replacement)
main()
from __future__ import division
import editor
# <put the fractions_to_floats() and feet_and_inches() code here>
def main():
text = editor.get_selected_text()
if text:
start, end = editor.get_selection()
editor.replace_text(start, end, feet_and_inches(text))
main()