One of my column’s value look like this :

LinepositionAdditionalPositionPositionViewMaterialNumberDescriptionQuantityExtUnitCostExtUnitPriceTransferPriceExtNetPriceExtNetPriceFCDiscountLocalMarginNetMarginUnitPricePositionType1False001Industrial System 24V 80A Parallel System1730418285972012665126650234212665Normal1True001Industrial System 24V 80A Parallel System1730418285972012665126650234212665Normal2False001.1Protect RCS 24 V / 2 x100 A16118156098333109261092630244410926Normal2True001.1Protect RCS 24 V / 2 x100 A161181560983331092610926244510926Normal3False001.2Documentation1196500267325325351840325Normal3True001.2Documentation11965002673253251847325Normal4False001.3Packing1540102867066866835019668Normal4True001.3Packing15401028670668668047668Normal5False001.4Factory Acceptance Testing14501148450746746354040746Normal5True001.4Factory Acceptance Testing145011484507467464061746Normal

its packed into 1 row string while it should be list of material with all of details.
Each row have different size of elements in that string could be easily transformed into right shape ?

I have tried
WHEN size(SPLIT(SPLIT(QuoteOverview, ”)[0], ”)) >= 1 AND t.row_num > 1 THEN SPLIT(SPLIT(QuoteOverview, ”)[0], ”)[0]

for each of elements but of course this one dont maade new rows with right values and also do not put right information in specific column

based on top view expected output is more less this :

Lineposition AdditionalPosition PositionView MaterialNumber Description Quantity ExtUnitCost CostReduction ReducedCost ExtUnitPrice TransferPrice ExtNetPrice ExtNetPriceFC Discount LocalMargin NetMargin UnitPrice PositionType
1 False 001 Industrial System 24V 80A Parallel System 1 7304 0 7304 18285 9720 12665 12665 0 23 42 12665 Normal
1 True 001 Industrial System 24V 80A Parallel System 1 7304 0 7304 18285 9720 12665 12665 0 23 42 12665 Normal
1 False 001.1 Protect RCS 24 V / 2 x100 A 1 6118 0 6118 15609 8333 10926 10926 30 24 44 10926 Normal