Skip to content
techfura

All about Tech and Data Engineering

  • Home
  • About Us
  • Courses
  • Blog
  • Contact
  • Services

Category: Excel

Split huge CSV files – Open in Excel

January 28, 2021January 28, 2021 Kenneth_pro_

One of Microsoft Excel’s shortcomings is the limited size of a spreadsheet. Excel has a spreadsheet row limit of 1,048,576. If you need to open in Excel, make your Excel file smaller or split a large CSV file. To get Read More …

Excel, Split csv FilesLeave a comment

How to Coalesce Excel Data

October 26, 2020October 26, 2020 Kenneth_pro_

The Coalesce function evaluates its arguments in order and returns the first value that isn’t blank or an empty string. Use this function to replace a blank value or empty string with a different value but leave non-blank and non-empty string values unchanged. If all of the Read More …

Excel, Functions1 Comment

Categories

  • Azure (22)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • MSSQL (3)
    • TDE (3)
  • Programming (35)
    • C# (5)
    • C++ (4)
    • HTML/CSS (3)
    • JavaScript (6)
    • TSQL (15)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (3)
  • Reporting (2)
    • SSRS (2)
April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Mar    

Recent Posts

  • Part 5: Switch case in C++
  • Part 4: Functions in C++
  • Part 3: Loops in C++
  • Part 2: If statements in C++
  • Part 1: Introduction to the C++ Language

Traffic Counts

PHP Hits Count
© 2021 Techfura All rights reserved.