Home HowTo Blog TalkingData eBook Q&A Download Documentation Talking Data Official Website Official Website
  • SCUDATA
  • RAQSOFT
  • Login Register
    Desktop  •  360 Reference  •  166 Reply  •  0 Follow
    HowTo
    Follow
    Default Hot Nice Preferred Recent reply Post
    excel(115) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) word extraction(5) csv(4) inter-row calculation(4) join(4) transposition(4) expand one row to multiple rows(3) distinct(3) align(2) row-to-column transposition(2) get maximum/minimum(2) conditional grouping(2) intersection(1) regular expression matching(1) inter-row(1) more>>> order-based grouping(1) date handling(1) concatenation by row number(1) record deletion(1) batch search(1)
    «1 ... 2 3 4 5 6 7 8 9 10 11 ... 15»
    • blackduckie •    Desktop   •    423 View 423 View    •   2021-07-28 17:38:23

      Get Common Words of Comma-separated Word Strings 

    • blackduckie •    Desktop   •    435 View 435 View    •   2021-07-28 17:17:36

      Delete Records Meeting a Specified Condition from a CSV File and Store Them into a New File 

    • blackduckie •    Desktop   •    342 View 342 View    •   2021-07-27 15:23:55

      Get the First Friday of the Quarter Containing the Current Date 

    • blackduckie •    Desktop   •    406 View 406 View    •   2021-07-27 11:49:10

      Copy Each Row Multiple Times by the Value of a Specific Column 

    • blackduckie •    Desktop   •    401 View 401 View    •   2021-07-27 10:18:45

      Search for Each Comma-separated Value from Strings 

    • blackduckie •    Desktop   •    409 View 409 View    •   2021-07-26 17:40:19

      Find the Least Occurring Values 

    • blackduckie •    Desktop   •    401 View 401 View    •   2021-07-23 10:05:14

      How to Split a String Containing Different Separators and Enter the Parts to Cells by Column 

    • blackduckie •    Desktop   •    362 View 362 View    •   2021-07-23 09:50:07

      How to Get Detailed Data in Matched Records While Duplicates in a Specific Column Are Left Empty 

    • blackduckie •    Desktop   •    337 View 337 View    •   2021-07-22 17:51:11

      How to Delete Rows with Duplicates in a Specific Column 

    • blackduckie •    Desktop   •    435 View 435 View    •   2021-07-22 13:49:46

      How to Extract the First Two Words from a White-space-separated String 

    • blackduckie •    Desktop   •    382 View 382 View    •   2021-07-22 10:12:11

      How to Count Rows and Enter the Specified Result in the First Row for a Second Level Category 

    • blackduckie •    Desktop   •    315 View 315 View    •   2021-07-21 16:51:31

      How to Split Multiple Long Rows of Different Structures and Reorganize Them according to the Specified Format 

    • blackduckie •    Desktop   •    375 View 375 View    •   2021-07-20 17:49:28

      How to Find If the Specified Column Is the Maximum in the Corresponding Group and Fill the Result in a New Column 

    • blackduckie •    Desktop   •    1 Reply   575 View 575 View    •   2021-07-20 17:40:22

      How to Split a String by Delimiter and Populate Members to a Certain Area 

    • blackduckie •    Desktop   •    407 View 407 View    •   2021-07-20 16:35:19

      How to Calculate the Proportion of Specified Data in a Row 

    • blackduckie •    Desktop   •    388 View 388 View    •   2021-07-20 16:24:18

      How to Enter Combined Values in the Empty Row after Continuous Rows 

    • blackduckie •    Desktop   •    358 View 358 View    •   2021-07-20 14:33:15

      How to Extract a Substring of a Specified Format from a String 

    • blackduckie •    Desktop   •    438 View 438 View    •   2021-07-19 18:28:48

      Perform Inter-row Calculations within Each Category 

    • blackduckie •    Desktop   •    340 View 340 View    •   2021-07-19 16:40:14

      Align Two Excel Tables by Positions in Corresponding Groups 

    • blackduckie •    Desktop   •    587 View 587 View    •   2021-07-19 14:02:34

      Check Whether There Are Missing Time Points in a Certain Interval 

    • blackduckie •    Desktop   •    413 View 413 View    •   2021-07-16 16:15:46

      How to Get the Minimum Value in a Specific Column Among a Continuous Set of Rows with Same Values in Another Column 

    • blackduckie •    Desktop   •    404 View 404 View    •   2021-07-16 15:08:37

      How to Move a Cell Value and Delete the Empty Row 

    • blackduckie •    Desktop   •    380 View 380 View    •   2021-07-16 13:49:44

      How to Convert Every Column under Same Category Column into a Row 

    • blackduckie •    Desktop   •    391 View 391 View    •   2021-07-15 17:55:11

      How to Get Directory Names in the 6th level of a Specified Path String 

    • blackduckie •    Desktop   •    378 View 378 View    •   2021-07-15 17:18:37

      Add Count Result to Every Row in a Group 

    «1 ... 2 3 4 5 6 7 8 9 10 11 ... 15»

    Tips

    • 📝 Not familiar with typesetting, please browse the Markdown tutorial

    Recent hot

    • 2.2 Rate of change
    • 2.3 Dispersion
    • 2.4 Main line
    • 2.5 Fluctuation amplitude
    • 2.6 Fluctuation frequency

    New group

    • Application  
    • NOTE  
    • Promote  
    • Guide  
    • YModel  
    • Desktop  
    • eBook  
    • Performance  
    • InSQL  
    • InFiles  
    • InReport  
    • HowTos  
    • json&xml  
    • Excel  
    • text  
    • SQL  
    • Report  
    • DraftBoard  
    • Q&A  
    • TalkingData  
    • News  
    • Download  
    • esProc  

    Contribute open source GitHub

    • 【Solo】 GitHub 上 Star 数最多的 Java 博客
    • 【Sym】 现代化的社区论坛系统
    • 【Pipe】 小而美的博客平台
    • 【Wide】 Golang 黑科技之在线 IDE
    About esProc SPL esProc Statistic
    © 2025 esProc Community Data computing&representation