It’s called a slice. From the python documentation under Common Sequence Operations: s[i:j] The slice of s from i to j is defined as the sequence of items with index k such that i <= k < j. If i or j is greater than len(s), use len(s). If i is omitted or None, use … Read more
def unicode_truncate(s, length, encoding=’utf-8′): encoded = s.encode(encoding)[:length] return encoded.decode(encoding, ‘ignore’) Here is an example for a Unicode string where each character is represented with 2 bytes in UTF-8 and that would’ve crashed if the split Unicode code point wasn’t ignored: >>> unicode_truncate(u’абвгд’, 5) u’\u0430\u0431′
No, you can only truncate a single table with TRUNCATE command. To truncate multiple tables you can use T-SQL and iterate through table names to truncate each at a time. DECLARE @delimiter CHAR(1), @tableList VARCHAR(MAX), @tableName VARCHAR(20), @currLen INT SET @delimiter=”,” SET @tableList=”table1,table2,table3″ WHILE LEN(@tableList) > 0 BEGIN SELECT @currLen = ( CASE charindex( @delimiter, … Read more
This is what java.time.temporal.TemporalAdjusters are for. date.with(TemporalAdjusters.firstDayOfMonth()).truncatedTo(ChronoUnit.DAYS);
unsigned int flags = NSCalendarUnitYear | NSCalendarUnitMonth | NSCalendarUnitDay; NSCalendar* calendar = [NSCalendar currentCalendar]; NSDateComponents* components = [calendar components:flags fromDate:date]; NSDate* dateOnly = [calendar dateFromComponents:components]; date is the date you want to remove the time from. This separates the date and time and creates a new date with the default time (00:00:00). EDIT To take … Read more
Wohoo, found it. Simple like everything in Joda once I traced down the calls. DateTime dt = new DateTime().hourOfDay().roundFloorCopy();
Answer, now this is reality with Linux kernel v3.15 (ext4/xfs) Read here http://man7.org/linux/man-pages/man2/fallocate.2.html Testing code #include <stdio.h> #include <stdlib.h> #include <string.h> #include <stdlib.h> #include <fcntl.h> #ifndef FALLOC_FL_COLLAPSE_RANGE #define FALLOC_FL_COLLAPSE_RANGE 0x08 #endif int main(int argc, const char * argv[]) { int ret; char * page = malloc(4096); int fd = open(“test.txt”, O_CREAT | O_TRUNC | O_RDWR, … Read more
function truncate(input) { if (input.length > 5) { return input.substring(0, 5) + ‘…’; } return input; }; or in ES6 const truncate = (input) => input.length > 5 ? `${input.substring(0, 5)}…` : input;
Calling DELETE FROM TableName will do the entire delete in one large transaction. This is expensive. Here is another option which will delete rows in batches : deleteMore: DELETE TOP(10000) Sales WHERE toDelete=”1″ IF @@ROWCOUNT != 0 goto deleteMore