![]() ![]() If the mask contains a percent symbol (%), the PercentGroupSizes and PercentGroupSeparator properties are used instead. If the mask contains the currency symbol ($), the CurrencyGroupSeparator and CurrencyGroupSizes properties are used instead. The character used as a group separator is specified by the NumberGroupSeparator property, and the number of digits in each group - by the property. The character used as a decimal point separator is specified by the property. ![]() The editor shows zeros for “0” placeholders that have no value.ĭecimal point. ![]() The editor shows nothing for “#” placeholders that have no value.Īny digit (0-9). Use the following placeholders and special characters to build custom numeric masks.Īny digit (0-9). If the precision specifier is omitted, the mask uses the culture’s property.Ģ500.00% (“P” or “P2”, editor value is “25”) The precision specifies the number of digits to the right of a decimal point. The mask matches the pattern specified by the culture’s and properties.Ģ5.00% (“P” or “P2”, editor value is “25”) If the precision specifier is omitted, the mask uses the culture’s property. The precision specifies the total number of digits. The fraction part is automatically discarded. If the precision is not set, the editor uses the number stored in the property. Precision specifies the number of digits after the decimal point. Users can change the regional format in the Windows Settings panel.Ĭurrency. The CultureInfo.NumberFormat property specifies the culture’s numeric format. and France (the currency symbol, the thousand separator, the precision, etc.). For example, the same input mask may specify different patterns in the U.S. Note that patterns depend on the current culture. The table below contains input masks that correspond to the standard patterns. The precision specifier ranges from 0 to 99 and sets the number of digits to the left or the right of a decimal point (depending on the mask specifier). Standard MasksĪ standard numeric mask consists of a mask and a precision specifier. Run this Demo Center module to test various input masks: Mask Box. ![]() This mask type supports the standard numeric. to filter for the entries that should go in each of the columns in the CoinTracker CSV format.The Numeric mask type allows users to enter numeric values (integer, float, currency, percentage, etc.). For this, we can take advantage of most transaction history formats using simple terms such as Sell, Buy, Deposit, Withdrawal, etc. Tips and tricks to convert Spreadsheet filtersįilters on spreadsheet software is super helpful for sorting out which transactions are send and receive transactions. The solution for them was uploading their file to Google Sheets, saving it to their computer as a CSV file, and then uploading the file to CoinTracker. □ Note: Some users have reported an issue when they edited their files using Excel or the built-in Numbers app on Mac. Importing transactions that already exist in your account will result in duplicate transactions Trades and transfers cannot have tagged values Receive transactions possible values include: fork, airdrop, mined, payment, staked, margin, margin rebate, interest Send transactions possible values include: gift, lost, donation, margin fee Should have values for the received quantity, received currency, sent quantity, and sent currency Received Quantity should *NOT* include fees Should have empty values for the sent quantity and sent currency Should have empty values for the received quantity and received currency Numbers can be up to eight decimal placesĬurrency symbols must match the ones available when adding manual transactions The required date format is MM/DD/YYYY HH:MM:SS (e.g. The first (header) row must exactly match the example Download the above sample CSV CSV Requirements ![]()
0 Comments
Leave a Reply. |