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 :
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 :
-
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