How to clean up below messy txt file into structured excel for analysis

i googled and import the file into R, but then with below result, I am wondering what package or script that can clean them, and structure

[2] "\tDel/finish Planned quantity Withdrawal qty Allocated qty BUn\t\t\t"
[3] "\t\t\t\t"
[4] "\tHUCE HUCE 1074392 VSF IS\t\t\tX"
[5] "\t2020.06.02 467 0 0 PC\t\t\t"
[6] "\t2020.06.08 466 0 0 PC\t\t\t"
[7] "\t2020.06.15 467 0 0 PC\t\t\t"
[8] "\t2020.06.22 466 0 0 PC\t\t\t"
[9] "\t\t\t\t"
[10] "\tHUCE HUCE 1074393 VSF IS\t\t\tX"
[11] "\t2020.06.02 233 0 0 PC\t\t\t"
[12] "\t2020.06.08 233 0 0 PC\t\t\t"
[13] "\t2020.06.15 233 0 0 PC\t\t\t"
[14] "\t2020.06.22 233 0 0 PC\t\t\t"
[15] "\t\t\t\t"
[16] "\tHUCE HUCE 1074394 VSF IS\t\t\tX"
[17] "\t2020.06.02 233 0 0 PC\t\t\t"
[18] "\t2020.06.08 233 0 0 PC\t\t\t"
[19] "\t2020.06.15 233 0 0 PC\t\t\t"
[20] "\t2020.06.22 233 0 0 PC\t\t\t"
[21] "\t\t\t\t"
[22] "\tMX01 MX01 1074394 VSF IS\t\t\tX"
[23] "\t2020.06.22 5 0 0 PC\t\t\t"
[24] "\t\t\t\t"
[25] "\tHUCE HUCE 1074395 VSF IS\t\t\tX"
[26] "\t2020.06.02 233 0 0 PC\t\t\t"
[27] "\t2020.06.08 233 0 0 PC\t\t\t"
[28] "\t2020.06.15 233 0 0 PC\t\t\t"
[29] "\t2020.06.22 233 0 0 PC\t\t\t"
[30] "\t\t\t\t"
[31] "\tUK01 UK01 1074398 VSF IS\t\t\tX"
[32] "\t2020.06.22 1 6 0 PC\t\t\t"
[33] "\t\t\t\t"
[34] "\tUK01 UK01 1074399 VSF IS\t\t\tX"
[35] "\t2020.06.22 1 6 0 PC\t\t\t"
[36] "\t\t\t\t"
[37] "\tUK01 UK01 1074400 VSF IS\t\t\tX"
[38] "\t2020.06.22 1 6 0 PC\t\t\t"
[39] "\t\t\t\t"
[40] "\tUK01 UK01 1074405 VSF IS\t\t\tX"
[41] "\t2020.06.22 1 6 0 PC\t\t\t"
[42] "\t\t\t\t"
[43] "\tUK01 UK01 1074406 VSF IS\t\t\tX"
[44] "\t2020.06.22 1 6 0 PC\t\t\t"
[45] "\t\t\t\t"
[46] "\tUK01 UK01 1074407 VSF IS\t\t\tX"
[47] "\t2020.06.22 1 6 0 PC\t\t\t"
[48] "\t\t\t\t"
[49] "\tUK01 UK01 1074408 VSF IS\t\t\tX"
[50] "\t2020.06.22 1 6 0 PC\t\t\t"
[51] "\t\t\t\t"
[52] "\tHUCE HUCE 1074409 VSF IS\t\t\tX"
[53] "\t2020.06.02 1 0 0 PC\t\t\t"
[54] "\t\t\t\t"
[55] "\tMX01 MX01 1074410 VSF IS\t\t\tX"
[56] "\t2020.06.22 5 0 0 PC\t\t\t"
[57] "\t\t\t\t"
[58] "\tEUFR EUFR 1074421 VSF IS\t\t\tX"
[59] "\t2020.06.22 7 16 0 PC\t\t\t"
[60] "\t\t\t\t"
[61] "\tMX01 MX01 1074421 VSF IS\t\t\tX"
[62] "\t2020.06.22 96 0 0 PC\t\t\t"
[63] "\t\t\t\t"
[64] "\t\t\t\t"
[65] "\t\t\t\t"
[66] "\tMRP Area Plant Material RqType Version Active ReqmtsPlan Ex.Req.Pln Requirement Segment\t\t\t"
[67] "\tDel/finish Planned quantity Withdrawal qty Allocated qty BUn\t\t\t"
[68] "\t\t\t\t"
[69] "\tRU02 RU02 1074421 VSF IS\t\t\tX"
[70] "\t2020.06.22 36 0 0 PC\t\t\t"
[71] "\t\t\t\t"
[72] "\tHUCE HUCE 1074422 VSF IS\t\t\tX"
[73] "\t2020.06.08 18 0 0 PC\t\t\t"
[74] "\t2020.06.15 19 0 0 PC\t\t\t"
[75] "\t2020.06.22 6 12 0 PC\t\t\t"
[76] "\t\t\t\t"
[77] "\tRU02 RU02 1074422 VSF IS\t\t\tX"
[78] "\t2020.06.22 35 0 0 PC\t\t\t"
[79] "\t\t\t\t"
[80] "\tUK01 UK01 1074422 VSF IS\t\t\tX"
[81] "\t2020.06.22 10 18 0 PC\t\t\t"
[82] "\t\t\t\t"
[83] "\tHUAT HUAT 1074437 VSF IS\t\t\tX"
[84] "\t2020.06.02 74 0 0 PC\t\t\t"
[85] "\t\t\t\t"
[86] "\tUSK1 USK1 1074479 VSF IS\t\t\tX"
[87] "\t2020.04.27 8 0 0 PC\t\t\t"
[88] "\t\t\t\t"
[89] "\tUSK1 USK1 1074480 VSF IS\t\t\tX"
[90] "\t2020.04.27 8 1 0 PC\t\t\t"
[91] "\t2020.05.26 4 4 0 PC\t\t\t"
[92] "\t2020.06.01 66 47 0 PC\t\t\t"
[93] "\t2020.06.22 105 6 4 PC\t\t\t"
[94] "\t\t\t\t"
[95] "\tUSK1 USK1 1074481 VSF IS\t\t\tX"
[96] "\t2020.04.20 13 0 0 PC\t\t\t"
[97] "\t2020.04.27 3 1 0 PC\t\t\t"
[98] "\t2020.05.26 8 2 0 PC\t\t\t"
[99] "\t2020.06.01 35 46 0 PC\t\t\t"
[100] "\t2020.06.22 17 2 8 PC\t\t\t"
[101] "\t\t\t\t"
[102] "\tCA01 CA01 1074483 VSF IS\t\t\tX"
[103] "\t2020.06.22 5 0 0 PC\t\t\t"
[104] "\t\t\t\t"
[105] "\tUSK1 USK1 1074483 VSF IS\t\t\tX"
[106] "\t2020.05.26 6 39 0 PC\t\t\t"
[107] "\t\t\t\t"
[108] "\tUSK1 USK1 1074484 VSF IS\t\t\tX"
[109] "\t2020.04.27 16 18 0 PC\t\t\t"
[110] "\t\t\t\t"
[111] "\tUSK1 USK1 1074485 VSF IS\t\t\tX"
[112] "\t2020.04.20 3 1 0 PC\t\t\t"
[113] "\t2020.04.27 3 1 0 PC\t\t\t"
[114] "\t2020.05.18 6 0 0 PC\t\t\t"
[115] "\t\t\t\t"
[116] "\tUSK1 USK1 1074486 VSF IS\t\t\tX"
[117] "\t2020.04.20 5 0 0 PC\t\t\t"
[118] "\t2020.04.27 1 3 0 PC\t\t\t"
[119] "\t2020.05.18 6 1 0 PC\t\t\t"
[120] "\t\t\t\t"
[121] "\tUSK1 USK1 1074490 VSF IS\t\t\tX"
[122] "\t2020.06.01 564 0 0 PC\t\t\t"
[123] "\t2020.06.08 564 0 0 PC\t\t\t"
[124] "\t2020.06.15 566 0 0 PC\t\t\t"
[125] "\t2020.06.22 565 0 0 PC\t\t\t"
[126] "\t\t\t\t"
[127] "\t\t\t\t"
[128] "\t\t\t\t"
[129] "\t\t\t\t"
[130] "\t\t\t\t"
[131] "\tMRP Area Plant Material RqType Version Active ReqmtsPlan Ex.Req.Pln Requirement Segment\t\t\t"
[132] "\tDel/finish Planned quantity Withdrawal qty Allocated qty BUn\t\t\t"
[133] "\t\t\t\t"
[134] "\tCA01 CA01 1074492 VSF IS\t\t\tX"

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.