Arithmetic Op
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.
There is NO SPACE after [n].
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.
2-5. You can customize date or datetime with Custom date format.
YYYY|YY(Year) MM|M(Month) DD|D(Day) hh|h(Hour) mm|m(Minute) ss|s(Second)
You can combine then in various orders like shown in examples below.
EXAMPLE1
June 03, 2019
YYYY.MM.DD => 2019.06.03
YY.MM.DD => 19.06.03
M/D => 6/3
EXAMPLE2
Jun 03, 2019 13: 02: 03
M/D hhmmss=> 6/3 130203
M/D h:m=> 6/3 13:2
If you input data to ‘Custom Date Format’ field, regardless of ‘Out Date Format’, or ‘Out Date Time Format’ settings, only the custom date is applied.
Latest Update 2021.11.15
New! The Arithmetic Op plugin can now handle data and datetime format from Europe.
You will find a new menu to explicitly specify the formats in the advanced menu.
Return Code
Code | Meaning |
---|---|
0 | Operation Successful |
99 | All Errors and Exceptions |
- ABBYY Download
- ABBYY Status
- ABBYY Upload
- AD LDAP
- Adv Send Email
- API Requests
- ARGOS API
- Arithmetic Op
- ASCII Converter
- Attach Image
- AWS S3
- AWS Textra Rekog
- Base64
- Basic Numerical Operations
- Basic String Manipulation
- Bot Collabo
- Box
- Box II
- Chatwork GetMessage
- Chatwork Notification
- Citizen Log
- Clipboard
- Codat API
- Convert CharSet
- Convert Image
- Convert Image II
- Create Newfile
- CSV2XLSX
- Dashboard Api
- DashBord Api
- Data Plot I
- Date OP
- DeepL Free
- Detect CharSet
- Dialog Calendar
- Dialog Error
- Dialog File Selection
- Dialog Forms
- Dialog Info
- Dialog Password
- Dialog Question
- Dialog Text Entry
- Dialog Text Info
- Dialog Warning
- DirectCloud API
- Doc2TXT
- DocDigitizer Get Doc
- DocDigitizer Tracking
- DocDigitizer Upload
- Drag and Drop
- Dropbox
- Dynamic Python
- Email IMAP ReadMon
- Email Read Mon
- Env Check
- Env Var
- Excel2Image
- Excel Advanced
- Excel Advance IV
- Excel AdvII
- Excel AdvIII
- Excel Copy Paste
- Excel Formula
- Excel Large Files
- Excel Macro
- Excel Newfile
- Excel Simple Read
- Excel Simple Write
- Excel Style
- Excel Update
- Fairy Devices mimi AI
- File Conv
- File Downloader
- File Folder Exists
- File Folder Op
- File Status
- Fixed Form Processing
- Floating Form Processing
- Folder Monitor
- Folder Status
- Folder Structure
- FTP Server
- Git HTML Extract
- Google Calendar
- Google Cloud Vision API
- Google Drive
- Google Search API
- Google Sheets
- Google Token
- Google Translate
- Google TTS
- GraphQL API
- Html Extract
- HTML Table
- IBM Speech to Text
- IBM Visual Recognition
- Java UI Automation
- JP Holiday
- JSON Select
- JSON to from CSV
- Lazarus Forms
- Lazarus Grid
- Lazarus Invoices
- Lazarus RikAI
- Lazarus RikAI2
- Lazarus RikAI2 Async
- Lazarus Riky
- Lazarus VKG
- LINE ID Card OCR
- LINE Notify
- LINE Receipt OCR
- Mangdoc AI Docs
- Microsoft Teams
- MongoDB
- MQTT Publisher
- MS Azure Text Analytics
- MS Word Extract
- NAVER OCR
- Newuser-SFDC
- OCI
- OCR PreProcess
- OpenAI API
- Oracle SQL
- Outlook
- Outlook Email
- PANDAS I
- pandas II
- pandas III
- PANDAS profiling
- Parsehub
- Password Generate
- Path Manipulation
- PDF2Doc
- PDF2Table
- PDF2TXT
- PDF Miner
- PDF SplitMerge
- PDF Viewer(Start/Stop)
- PostgreSQL
- PowerShell
- PPTX Template
- Print 2 Image
- Python Selenium
- QR Generate
- QR Read
- RakurakuHanbai API
- Regression
- Rename File
- REST API
- Rossum
- Running GAS
- Scrapy Basic
- Screen Capture
- Screen Recording START
- Screen Recording STOP
- Screen Snipping
- Seaborn Plot
- SharePoint
- Simple Counter
- Simple SFDC
- Slack
- Sort CSV
- Speed Test
- SQL
- SQLite
- SSH Command
- SSH Copy
- String Manipulation
- String Similarity
- Svc Check
- Sys Info
- Telegram
- Tesseract
- Text2PDF
- Text2Word
- Text Read
- Text Write
- Time Diff
- Time Stamp
- Web Extract
- Windows Op
- Windows Screen Lock
- Win UI Control
- Win UI Text
- Word2PDF
- Word2TXT
- Word Editor
- Work Calendar
- XML Extract
- XML Manipulation
- Xtracta Get Doc
- Xtracta Tracking
- Xtracta Upload
- YouTube Operation
- ZipUnzip