id | date | title | type | hits |

1465 | 2022-03-31 | How to calculate each number in a line with different formula? | Text **data** calculation | 2702 |

1464 | 2022-01-22 | How to calculate one column base on value of another column? | Text **data** calculation | 2760 |

1427 | 2018-11-09 | How to multiply the fifth column by 10 in a text file? | Text **data** calculation | 1998 |

1425 | 2018-11-09 | How to batch extract A1~A5 from txt file to a single file? | Text file parser | 2976 |

1423 | 2018-10-07 | How to fit template file with specified html in same folder? | Advanced search and replace | 1928 |

1346 | 2016-02-21 | How to calculate time difference of two adjacent and matched lines? | Text **data** calculation | 2521 |

1342 | 2016-02-16 | How to make a subtraction of the specified time string? | Text **data** calculation | 2466 |

1332 | 2015-12-17 | How to compare and get the difference between numbers of two file? | Text **data** calculation | 2818 |

1327 | 2015-12-01 | How to set column N according to some words in column A in csv file? | Advanced search and replace | 2728 |

1326 | 2015-11-21 | How to substract one csv file from another according to value of column A? | Advanced search and replace | 2734 |

1325 | 2015-11-18 | How to set column N according to content of column A in csv file? | Advanced search and replace | 2663 |

1301 | 2015-04-25 | How to extract from a file according to content of another file? | Advanced search and replace | 2915 |

1291 | 2015-04-01 | How to convert a duration of seconds to a time format? | Text **data** calculation | 2642 |

1287 | 2015-03-18 | How to multiply by 1.5 for all numbers with xr suffix? | Text **data** calculation | 2512 |

1274 | 2014-12-16 | How to decrease the first 4 digits in the beginning of each line by 1000? | Text **data** calculation | 3159 |

1271 | 2014-12-09 | How to merge text by first column and calculate average for rest columns? | Text **data** calculation | 2977 |

1260 | 2014-10-12 | How to divide by 10 for all numbers not less than 40? | Text **data** calculation | 2922 |

1257 | 2014-10-01 | How to use the dictionary to do english words regex search and replace? | Advanced search and replace | 2865 |

1252 | 2014-09-21 | How to use the dictionary to do multiple Regex search and replace? | Advanced search and replace | 2484 |

1244 | 2014-09-06 | How to batch calculate numbers and make the result divisible by 5? | Text **data** calculation | 3209 |

1231 | 2014-08-12 | How to add or subtract a value to a number in a line with a particular word? | Text **data** calculation | 2860 |

1230 | 2014-08-09 | How to fill in one xml file with elements from another xml file? | Advanced search and replace | 2802 |

1227 | 2014-08-05 | How to calculate the total energy consumption in group? | Text **data** calculation | 2864 |

1226 | 2014-08-05 | How to calculate the average of the numbers in the same column? | Text **data** calculation | 3044 |

1213 | 2014-07-04 | How to calculate the average of numbers of one column? | Text **data** calculation | 3106 |