Tag » 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 altre parole
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 altre parole

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 altre parole

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 altre parole

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 altre parole

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 altre parole

Gak Penting

図一覧をCSVファイルに出力するプラグイン – 0.9.3公開

shi-n様作「シーケンス図一覧CSV出力プラグイン」プラグイン0.9.3アップデートのお知らせです。

0.9.3では、出力元パッケージの指定が可能になりました。構造ツリーと同じパッケージ構造が表示され、出力対象をパッケージレベルで指定できます。0.9.3では、この他にもソート条件の改修が含まれています(第1条件:名前空間、第2条件:図名)。

インストール

Shi-n様のページより、プラグインファイルをダウンロードしてご利用ください。
使い方やご利用方法は、こちらのページも、どうぞご参照ください。

Diagram_list