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.
Text from Image
- AD LDAP
- Adv Send Email
- Arithmetic Op
- Attach Image
- AWS Textra Rekog
- Bot Collabo
- Chatwork Notification
- Clipboard
- Convert CharSet
- Convert Image
- Create Newfile
- Detect CharSet
- Drag and Drop
- Email IMAP ReadMon
- Email Read Mon
- Env Check
- Env Var
- Excel Advanced
- Excel AdvII
- Excel AdvIII
- Excel Copy Paste
- Excel Formula
- Excel Macro
- Excel Newfile
- Fairy Devices mimi AI
- File Conv
- File Folder Op
- File Status
- Folder Monitor
- Folder Structure
- Google Calendar
- Google Cloud Vision API
- Google Drive
- Google Sheets
- Google Token
- Google Translate
- Google TTS
- Html Extract
- IBM Speech to Text
- IBM Visual Recognition
- JSON Select
- LINE Notify
- MS Azure Text Analytics
- MS Word Extract
- NAVER OCR
- Newuser-SFDC
- PANDAS I
- pandas II
- pandas III
- PANDAS profiling
- Parsehub
- Password Generate
- PDF2Doc
- PDF Miner
- PDF SplitMerge
- PowerShell
- Print 2 Image
- QR Generate
- QR Read
- Regression
- REST API
- Rossum
- Scrapy Basic
- Screen Snipping
- Simple SFDC
- Slack
- Speed Test
- SQL
- SSH Command
- SSH Copy
- String Manipulation
- Telegram
- Tesseract
- Time Stamp
- Web Extract
- Work Calendar
- XML Extract
- Xtracta Get Doc
- Xtracta Tracking
- Xtracta Upload
- ZipUnzip