Hello,
Is it possible to remove empty lines from a source file Metadata ?
You can delete these empty lines in reading by using "Transformation Scripting" and a filter on the metadata.
First in the properties of the metadata you can apply the following Rhino script which replaces all empty lines with the value "empty":
Script :
ret=new Array(); if (__string__==""){ ret[0]="empty"; } else { ret[0] = __string__; } ret;
Then you would have to add a new filter in the metadata:
which will return only rows that don't have the string "empty" at the beginning of the row
Audric FREY
Hello,
Is it possible to remove empty lines from a source file Metadata ?
Hello,
You can delete these empty lines in reading by using "Transformation Scripting" and a filter on the metadata.
First in the properties of the metadata you can apply the following Rhino script which replaces all empty lines with the value "empty":
Script :
Then you would have to add a new filter in the metadata:
which will return only rows that don't have the string "empty" at the beginning of the row
Audric FREY
Hello,
You can delete these empty lines in reading by using "Transformation Scripting" and a filter on the metadata.
First in the properties of the metadata you can apply the following Rhino script which replaces all empty lines with the value "empty":
Script :
Then you would have to add a new filter in the metadata:
which will return only rows that don't have the string "empty" at the beginning of the row
-
File external resolver with encrypted value
-
Timeout on Mapping/Webservice call
-
UNIQUE TEMP TABLE NAMES
-
Previous step name from a sub-process of execute delivery
-
Dropping multiple tables at once in XDI
-
Freeze Designer and corrupted workspace
-
FileWait/Move/Copy: FileInclude with space
-
Loop excel files
-
Change SVN user in the Designer
-
How to Specify the JVM used by the Designer?
See all 64 topics