0 ×

URL to File Path

StreamableKNIME File Handling Nodes version 4.0.1.v201908131226 by KNIME AG, Zurich, Switzerland

Converts the url strings of the specified string column into file path strings. Four columns will be appended on the input data table. One, containing the complete file paths, one containing the parent folder of the files, one containing the file names (without extensions), and one containing the file extensions.
It can be specified whether the node will fail if an invalid url string occurs or a file location does not exist. If failing is switched off (default) missing values will be inserted as file paths, parent folders, file names, as well as file extensions.

Options

Column containing URLs: The column containing the url strings.
Fail if URL has invalid syntax: If checked, node will fail if an invalid url string occurs, otherwise a missing value will be inserted as file path, parent folder, file name, and file extension.
Fail if file does not exist: If checked, node will fail if a file location does not exist, otherwise a missing value will be inserted as file path, parent folder, file name, and file extension.

Input Ports

: The input table containing URL strings to convert.

Output Ports

: The output table with appended file paths, parent folders, file names, and file extensions of converted urls.

Best Friends (Incoming)

List Files (30 %)
String to URI (9 %)
Variable to Table Row (4 %)
List Remote Files (3 %)
Extract URI Info (3 %)
Row Filter (3 %) Streamable
Download (2 %)
Port to URI (2 %)
Unzip Files (2 %)
File Reader (2 %) Streamable
Table Creator (2 %)
URI to String (2 %)
Column Filter (1 %) Streamable
File Meta Info (1 %)
Variable to Table Column (1 %) Streamable
GroupBy (1 %)
String Manipulation (1 %) Streamable
Table Row To Variable Loop Start (< 1 %)
Loop End (< 1 %)
Concatenate (< 1 %) Streamable
Joiner (< 1 %)
Sorter (< 1 %)
Rule-based Row Filter (< 1 %) Streamable
Excel Reader (XLS) (< 1 %) Streamable
Tika Parser URL Input (< 1 %) Streamable
Tika Parser (< 1 %) Streamable
Binary Objects to Files (< 1 %)
~~File Meta Info~~ (< 1 %) Deprecated
Table Reader (< 1 %) Streamable
Java Snippet (< 1 %) Streamable
Chunk Loop Start (< 1 %)
Column Combiner (< 1 %) Streamable
Column Rename (< 1 %) Streamable
GET Request (< 1 %) Streamable
Explorer Browser (< 1 %)
List Folders (< 1 %)
String to Table (< 1 %)
Copy/Move Files (< 1 %)
Delete Files (< 1 %)
Files to Binary Objects (< 1 %)
URL to File Path (< 1 %) Streamable
Catch Errors (Data Ports) (< 1 %)
Extract Variables (Data) (< 1 %)
Table Row to Variable (< 1 %)
Image Writer (Table Column) (< 1 %)
Read Images (< 1 %)
ARFF Reader (< 1 %)
CSV Reader (< 1 %)
CSV Writer (< 1 %) Streamable
Database Connection Table Reader (legacy) (< 1 %)
Line Reader (< 1 %)
Table Writer (< 1 %)
Generic Loop Start (< 1 %)
Group Loop Start (< 1 %)
Concatenate (Optional in) (< 1 %) Streamable
Case Converter (< 1 %) Streamable
~~Cell Splitter~~ (< 1 %) Deprecated
~~String To Number~~ (< 1 %) StreamableDeprecated
Constant Value Column (< 1 %) Streamable
Cross Joiner (< 1 %) Streamable
Row Splitter (< 1 %) Streamable
Partitioning (< 1 %)
Pivoting (< 1 %)
RowID (< 1 %) Streamable
Column Splitter (< 1 %) Streamable
String Manipulation (Variable) (< 1 %)
String Replacer (< 1 %) Streamable
Ungroup (< 1 %) Streamable
Rule Engine (< 1 %) Streamable
Empty Table Switch (< 1 %)
CASE Switch Data (End) (< 1 %)
End IF (< 1 %)
IF Switch (< 1 %)
SDF Extractor (< 1 %)
Empty Table Creator (< 1 %)
Math Formula (< 1 %) Streamable
~~XLS Reader~~ (< 1 %) Deprecated
Read Excel Sheet Names (XLS) (< 1 %)
Java IF (Table) (< 1 %)
Flat File Document Parser (< 1 %)
Word Parser (< 1 %)
~~Document Data Extractor~~ (< 1 %) Deprecated
File Chooser (< 1 %)
String Input (< 1 %)
JSON Path (< 1 %) Streamable
Columns to JSON (< 1 %) Streamable
JSON to Table (< 1 %)
Image Reader (< 1 %) Streamable
Image Reader (Table) (< 1 %) Streamable
~~Python Script (1⇒1)~~ (< 1 %) Deprecated
~~File Upload (legacy)~~ (< 1 %) Deprecated
PUT Request (< 1 %) Streamable
Modify Time (< 1 %) Streamable
Window Loop Start (< 1 %)
Mask Date/Time (legacy) (< 1 %)
String to Date/Time (legacy) (< 1 %) Streamable
XPath (< 1 %) Streamable
URL Extractor (< 1 %)
OAuth (< 1 %)
Show all 99 recommendations

Best Friends (Outgoing)

Table Row To Variable Loop Start (13 %)
Column Filter (7 %) Streamable
String Manipulation (7 %) Streamable
Table Row to Variable (5 %)
String to URI (4 %)
Row Filter (4 %) Streamable
Joiner (3 %)
Java Snippet (2 %) Streamable
~~Cell Splitter~~ (2 %) Deprecated
GroupBy (2 %)
Regex Split (2 %) Streamable
Copy/Move Files (2 %)
File Meta Info (2 %)
Table Column to Variable (2 %)
Row Splitter (2 %) Streamable
Reference Row Filter (2 %)
Column Rename (2 %) Streamable
Sorter (2 %)
Extract URI Info (1 %)
Constant Value Column (1 %) Streamable
URL Extractor (1 %)
Loop End (1 %)
Rule-based Row Splitter (1 %) Streamable
Load text-based files (< 1 %) Streamable
Delete Files (< 1 %)
Upload (< 1 %)
Read Images (< 1 %)
CSV Writer (< 1 %) Streamable
Reference Row Splitter (< 1 %)
XML To PMML (< 1 %)
Rule-based Row Filter (< 1 %) Streamable
URL Domain Extractor (< 1 %)
~~File Meta Info~~ (< 1 %) Deprecated
URL to File Path (Variable) (< 1 %)
CSV Reader (< 1 %)
Chunk Loop Start (< 1 %)
Group Loop Start (< 1 %)
Rank (< 1 %)
Row Sampling (< 1 %)
String Replacer (< 1 %) Streamable
Rule Engine (< 1 %) Streamable
Excel Writer (XLS) (< 1 %)
RegEx Filter (< 1 %) Streamable
Document Data Extractor (< 1 %)
Column Filter (< 1 %)
XPath (< 1 %) Streamable
HTTP Retriever (< 1 %)
ZipLoopStart (< 1 %)
Shapefile Polygon Reader (< 1 %)
PIA Compiler (< 1 %)
~~Expand Well Position~~ (< 1 %) Deprecated
R Snippet (< 1 %)
Download Files with Authentication (< 1 %)
Binary Objects to Files (< 1 %)
Download (< 1 %)
Download / Upload from List (< 1 %)
Files to Binary Objects (< 1 %)
URI to Port (< 1 %)
URI to String (< 1 %)
URL to File Path (< 1 %) Streamable
Zip Files (< 1 %)
Try (Data Ports) (< 1 %)
Variable to Table Column (< 1 %) Streamable
Variable to Table Row (< 1 %)
Image Writer (Port) (< 1 %)
Database SQL Executor (legacy) (< 1 %)
Database Writer (legacy) (< 1 %) Streamable
File Reader (< 1 %) Streamable
Table Creator (< 1 %)
Loop End (2 ports) (< 1 %)
Column List Loop Start (< 1 %)
Concatenate (< 1 %) Streamable
Cell Splitter (< 1 %)
Column Combiner (< 1 %) Streamable
Column Aggregator (< 1 %) Streamable
Column Appender (< 1 %) Streamable
Cross Joiner (< 1 %) Streamable
Filter Apply (< 1 %) Streamable
Nominal Value Row Filter (< 1 %) Streamable
Partitioning (< 1 %)
Missing Value (< 1 %)
Transpose (< 1 %)
Value Counter (< 1 %)
End IF (< 1 %)
Send Email (< 1 %)
Interactive Table (local) (< 1 %)
SDF Writer (< 1 %)
Azure Blob Store File Picker (< 1 %)
WrappedNode Output (< 1 %)
OpenBabel (< 1 %)
Math Formula (< 1 %) Streamable
Excel Reader (XLS) (< 1 %) Streamable
Read Excel Sheet Names (XLS) (< 1 %)
Excel Sheet Appender (XLS) (< 1 %)
Java Snippet (simple) (< 1 %)
Java IF (Table) (< 1 %)
Tika Parser URL Input (< 1 %) Streamable
~~Stop Word Filter~~ (< 1 %) StreamableDeprecated
External Tool (Labs) (< 1 %)
Column Selection (< 1 %)
Container Input (Table) (< 1 %)
Table to JSON (< 1 %)
Image Reader (Table) (< 1 %) Streamable
~~Python Script (1⇒1)~~ (< 1 %) Deprecated
~~Python Script (1⇒1)~~ (< 1 %) Deprecated
R View (Table) (< 1 %)
Table to R (< 1 %)
POST Request (< 1 %) Streamable
PUT Request (< 1 %) Streamable
Date&Time Shift (< 1 %) Streamable
String to Date/Time (legacy) (< 1 %) Streamable
URL Resolver (< 1 %)
HTML Parser (< 1 %)
Show all 113 recommendations

Workflows

Installation

To use this node in KNIME, install KNIME File Handling Nodes from the following update site:

KNIME 4.0

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.