Tags » Csv

Import CSV or any delimited text file in Excel using VBA

This post demonstrates how to import CSV or any delimited text file in Excel using VBA code.

Each line in the text file is written into one row in a worksheet.

363 more words
Vba

Oracle Form 6i - Create File (.CSV)

DECLARE
l_out_file text_io.file_type;
l_linebuff VARCHAR2(4000);
l_path_full VARCHAR2(2048);
l_filename VARCHAR2(2048);
l_dash VARCHAR(4);
l_delimiter VARCHAR(1) := ‘,';

BEGIN
IF SUBSTR(, -1) ‘\’ THEN
l_dash := ‘\';
END IF; 67 more words

Create File

Checking how clean your CSV file is? CSV fingerprints (from @vicapow ) shows it visually

Now "unfortunately" the files I tried were all clean so showed up nicely with a full yellow screen and a two-colour version, but I can see where this can help quickly seeing if you have missed anything, especially when files get bigger. 43 more words

DATA

How to Open/ Export capture file as CSV from TCPDUMP in Wireshark

This is a short clip that demonstrates how to use a script that will run TCPDUMP, save the capture file and then open this file in Wireshark which then can be exported as CSV. 57 more words

How to build pyspark,maven and Apache Spark from github sources using a bash script in Ubuntu 14.04 LTS 64-bit

Run following bash script in a bash Terminal in Ubuntu 14.04 LTS 64-bit:

 #!/bin/bash
 # Based on: https://spark.apache.org/docs/1.1.0/building-with-maven.html
 # Purpose: this script will automatically compile and install
 # the newest version of maven and Apache Spark via the github sources
 # Software requirements: Ubuntu 14.04 LTS 64-bit, git, build-essential,
 # ant, unp, python2.7, java 1.7.0 or higher
 # Minimum RAM requirements for this script: 2 Gigabytes of RAM (maybe even more)
 # Please make sure to close any web browser windows and any other
 # memory hogging applications before running this memory intensive bash script. 597 more words
Ubuntu

Collection Data

The collection is tiny. Ten objects. It’s liberating to have such a small collection, because our work can be not related to understanding the scope and scale of it, but to quickly dive into stories about each object. 711 more words

V1

The Simplest Way to Generate CSV Output From Hive in Linux Shell

If you are wondering the easiest way (at least IMHO) how to generate data output in HIVE in Excel-like CSV compatible format without modifying any table or using 3rd party java plugin is: 77 more words

Gak Penting