Splitting DFF column after first blank
I am still struggling with advanced edits in OTBI so this post for a (seemingly) easy task came up:
Due to a rushed implementation we have cost centers to which our employees are assigned not from the general booking key setup (cross pillar) but solemly in HR core via a DFF. The DFF is setup in a way that makes its data unusable for any further analysis/export - it combines the cost center ID and its name in the same field:
eg: 00-00-000 HQ - CostCenter
This should be divided into CostCenterID column (00-00-000) and CostCenterName column (HQ - Cost Center). So delimitated by the first blank a split has to occur.