- Created by Former user on Oct 01, 2019
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
Version 1 Next »
This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial.
Arithmetic Op | |
---|---|
Performs various mathematical operations from simple addition/subtraction to complex date/time calculations |
Contents
EXAMPLE
[Left Value] [+] [Right Value] = [Result Value]
Parameters
Operators
Operator Meaning Example + Add two operands or unary plus x + y +2 - Subtract right operand from the left or unary minus x - y -2 * Multiply two opeands x * y / Divide left operand by the right one (always results into float) x / y % Modulus - remainder of the division of left operand by the right x % y (remainder of x/y) // Floor division - division that results into whole number adjusted to the left in the number line x // y ** Exponent - left operand raised to the power of right x**y (x to the power y)
1. When using User Variables, you can store the Result Value in one of the Left or Right values.
(you can use it as a counter!)
EXAMPLE When you want to user {{user.variable1}} as a counter for increment of 1
Left Value {{user.variable1}} Operator + Right Value 1 Result Value {{user.variable1}}
2. When calculating dates/times, here are the tips!
2-1. Left Value can take all the following formats.
YYYYMMDD YYYY-MM-DD YYYY/MM/DD MMDDYYYY MM-DD-YYYY MM/DD/YYYY B D YYYY B D, YYYY D B YYYY YYYYMMDD-HHMMSS.mmm YYYY-MM-DD HH:MM:SS.mmm YYYY/MM/DD HH:MM:SS.mmm MMDDYYYY-HHMMSS.mmm MM-DD-YYYY HH:MM:SS.mmm MM/DD/YYYY HH:MM:SS.mmm YYYYMMDD-HHMMSS YYYY-MM-DD HH:MM:SS YYYY/MM/DD HH:MM:SS MMDDYYYY-HHMMSS MM-DD-YYYY HH:MM:SS MM/DD/YYYY HH:MM:SS
2-2. You can use only [+] or [-] operator.
2-3. Right Value can take only the following “time-delta” notations. There is NO SPACE after [n].
[n]day[n]hour [n]min [n]sec [n]msec [n]usec [n]week [n]month [n]year
Note: [n] is an Integer.
2-4. You can use date or datetime for the Right Value only when operator is [-].
In this case, if Left Value is date, then the Right Value must be date. If the Left Value is datetime, then the Right Value must be datetime.
- ABBYY Download-3.713.900
- ABBYY Status-3.713.900
- ABBYY Upload-3.713.900
- AD LDAP-1.1124.2100
- Adv Send Email-2.820.114
- API Requests-2.1228.1332
- ARGOS API-3.906.3300
- ArithmeticOp-1.815.1042
- ASCII Converter-5.222.1500
- Attach Image-2.1007.1100
- AWS S3-3.517.1700
- AWS Textra Rekog-2.106.1600
- Base64-4.817.1238
- Basic Numerical Operations-4.420.1000
- Basic String Manipulation-3.1025.1130
- Bot Collabo-1.821.1020
- Box-3.618.1400
- Chatwork GetMessage-3.423.1100
- Chatwork Notification-2.730.1830
- Citizen Log-4.1031.1312
- Clipboard-1.1004.1010
- Codat API-2.127.1000
- Convert CharSet-2.326.2130
- Convert Image II-3.113.3300
- Convert Image-3.113.908
- Create Newfile-2.804.1620
- CSV2XLSX-3.223.842
- Data Plot I-3.416.1000
- DeepL Free-5.803.1200
- Detect CharSet-2.326.1130
- Dialog Calendar-3.316.1400
- Dialog Error-3.309.1300
- Dialog File Selection-3.304.1510
- Dialog Forms-3.316.1210
- Dialog Info-3.309.1100
- Dialog Password-3.316.1300
- Dialog Question-3.310.1530
- Dialog Text Entry-3.310.1210
- Dialog Text Entry-4.920.1832
- Dialog Text Info-3.309.1420
- Dialog Warning-3.309.1000
- DirectCloud API-5.508.1230
- Doc2TXT-3.623.1500
- DocDigitizer Get Doc-4.411.856
- DocDigitizer Tracking-4.411.858
- DocDigitizer Upload-4.411.850
- Drag and Drop-2.318.1125
- Dropbox-3.608.1430
- Dynamic Python-3.402.913
- Email IMAP ReadMon-2.313.1430
- Email Read Mon-1.620.938
- Env Check-2.713.2500.I
- Env Var-2.715.1307
- Excel2Image-4.327.1826
- Excel Advanced-1.910.1120
- Excel AdvII-2.413.1900
- Excel AdvIII-2.929.1000
- Excel AdvIV-5.904.1319
- Excel Copy Paste-2.1002.830
- Excel Formula-2.811.900
- Excel Large Files-5.1011.1108
- Excel Large Files-5.1102.1305
- Excel Macro-1.719.1838
- Excel Newfile-2.908.1040
- Excel Simple Read-3.419.1057
- Excel Simple Write-3.520.1000
- Excel Style-3.730.1300
- Excel Update-3.510.1331
- Fairy Devices mimi AI-2.302.2055
- File Conv-1.916.1335
- File Download-4.714.1657
- File Folder Exists-3.308.3300
- File Folder Op-1.620.1721
- File Monitor-1.424.1142
- File Status-2.1118.1059
- Fixed Form Processing-1.0.12
- Floating Form Processing-1.0.10
- Folder Monitor-2.1115.1247
- Folder Status-4.622.1657
- Folder Structure-2.907.1109
- FTP Server-4.612.1656
- Google Calendar-2.814.1100
- Google Cloud Vision API-1.1031.2002
- Google Drive-2.624.2000
- Google Search API-3.331.1000
- Google Sheets-2.625.1700
- Google Token-2.617.1830
- Google Translate-2.305.1930
- Google TTS-2.305.2000
- Html Extract-2.813.1247
- HTML Table-3.324.1630
- IBM Visual Recognition-2.305.2005
- JP Holiday-5.621.2100
- JSON Select-1.418.1631
- JSON to from CSV-3.303.1800
- Lazarus Forms-5.424.3300
- Lazarus Invoices-5.209.1650
- Lazarus RikAI-5.209.1700
- Lazarus Riky-5.515.2211
- LINE ID Card OCR-3.817.1100
- LINE Notify-2.305.1802
- LINE Receipt OCR-3.506.1400
- MongoDB-3.215.1300
- MQTT Publisher-4.422.3000
- MS Azure Text Analytics-2.323.1030
- MS Word Extract-2.509.1130
- NAVER OCR-2.327.1100
- Newuser-SFDC-2.521.1200
- OCI-4.406.1134
- OCR PreProcess-4.610.925
- OpenAI API-5.619.1050
- Oracle SQL-3.729.1100
- Outlook Email-3.913.1107
- Outlook-3.723.1100
- PANDAS I-2.409.1806
- pandas II-2.911.1008
- pandas III-2.915.1747
- PANDAS profiling-2.507.1215
- Parsehub-2.1222.1730
- Password Generate-2.530.1712
- Path Manipulation-3.615.914
- PDF2Doc-2.616.1130
- PDF2Table-3.811.1045
- PDF2TXT-3.623.1530
- PDF Miner-2.604.2100
- PDF SplitMerge-2.1202.900
- PostgreSQL-3.1205.2220
- PowerShell-2.906.2242
- PPTX Template-3.803.1930
- Print 2 Image-2.1113.1600
- Python Selenium-3.128.2400
- QR Generate-2.1028.1130
- QR Read-2.1028.1130
- RakurakuHanbai API-5.803.1200
- Regression-2.605.1100
- Rename File-3.429.1500
- REST API-1.709.2010
- Rossum-1.1205.2120
- Running GAS-3.901.1730
- Scrapy Basic-2.1011.2537
- Screen Capture-3.623.1440
- Screen Recording START-3.527.806
- Screen Recording STOP-3.526.1416
- Screen Snipping-2.1027.1300
- Seaborn Plot-3.1028.1003
- SharePoint-3.1105.1600
- Simple SFDC-2.504.730
- Slack-2.721.1100
- Sort CSV-3.709.1500
- Speech to Text-1.1115.1622
- Speed Test-2.713.2500.II
- SQL-1.509.2104
- SQLite-3.713.1749
- SSH Command-1.415.1930
- SSH Copy-2.412.2130
- String Manipulation-1.923.1818
- String Similarity-3.1116.1740
- Svc Check-2.515.3300
- Sys Info-3.303.3300
- Telegram-2.726.1300
- Tesseract-2.322.1540
- Text2PDF-5.829.2350
- Text2Word-5.920.2000
- Text Read-3.326.1730
- Text Write-3.319.1100
- Time Diff-3.429.853
- Time Stamp-1.722.1407
- Web Extract-1.930.1927
- Window Op-3.217.1000
- Windows Screen Lock-3.331.1635
- Word2PDF-3.1112.1600
- Word2TXT-3.1118.1338
- Work Calendar-1.830.2039
- XML Extract-2.507.1010
- XML Manipulation-3.826.1615
- Xtracta Get Doc-2.827.1430
- Xtracta Tracking-2.904.1400
- Xtracta Upload-2.827.1400
- YouTube Operation-5.725.1529
- ZipUnzip-2.819.1218
- No labels