Viz Channel Branding User Guide
Version 5.0 | Published July 10, 2023 ©
Splitting Fields
The ability to split fields is to be able to right in the Mapping Table for an import module be able to store info and instantly re-use it to another mapped variable.
The notation for splitting a field is like this: &(FIELD_NAME,”DELIMITER”,FROM,COUNT). If the delimiter is empty, it will split into characters.
Example
Splitting begin_date in Excel Import Type
We can create a custom field named begin_date_temp, mapping it as $L.
-
begin_date_temp = $L
If $L is '31.12.2006', set begin_date as:
&(begin_date_temp,"",1,2) => "31" &(begin_date_temp,"",11,2) => "" &(begin_date_temp,"",10,2) => "6" &(begin_date_temp,".",1,2) => "31.12" &(begin_date_temp,".",2,2) => "12.2006" &(begin_date_temp,".",2,3) => "12.2006" &(begin_date_temp,".",4,1) => "" &(begin_date_temp,".",3,2) => "2006" &(begin_date_temp,"/",2,1) => "" &(begin_date_temp,"/",1,1) => "31.12.2006"