Parsing table-like string into JavaScript object-CodePudding

This string is structured in a human-readable table-like way. It contains three columns. However, the only information I need is a list of all of the values from the first column.

app115                                115.115                              winget
app225                                115.115Chrome                        winget
Knotes                                1MHz.Knotes                          winget
BPMN-RPA Studio                       1ic.BPMN-RPAstudio                   winget
Fishing Funds                         1zilc.FishingFunds                   winget
3601                                  360.360Chrome                        winget
3602                                  360.360Chrome.X                      winget
3603                                  360.360CleanMaster                   winget
3604                                  360.360se                            winget
3CX Call Flow Designer (.exe edition) 3CX.3CXCallFlowDesigner              winget

Using javascript, how would I parse this string to get a result of something like:

['app115', 'app225', 'Knotes', 'BPMN-RPA Studio', 'Fishing Funds', '360', '360', '360', '360', '3CX Call Flow Designer (.exe edition)']

Here are some of my ideas that I couldn't get to work:

step 1, since the second two columns are not necessary, we can start by replacing 'winget' with blank text string1.replaceAll("winget", "") this removes the whole left column because all values in that column are 'winget'.

step 2, remove all occurrences of multiple characters that are surrounded by 2 or more spaces on each side. This should get rid of the whole second column because each value has at least two spaces on each side. -- will not work because if the value in the first column is too long, the value in the second column may only have one space next to it. Check the last row of the original string.

last step, once string now looks something like: "app115 app225 Knotes BPMN-RPA Studio Fishing Funds...", make into an array using string.split(" ")

Hope my question makes sense. Thanks for any help

CodePudding user response：

This one works for me

Assuming any kind of whitespace including tabs between the columns

\s \w \. is the leading whitespace BEFORE a string with a fullstop

const lines = table.split(/\r?\n/)
const column1 = lines.map(line => line.split(/\s \w \./)[0])
console.log(column1)

<script>
const table = `app115                                115.115                              winget
app225                                115.115Chrome                        winget
Knotes                                1MHz.Knotes                          winget
BPMN-RPA Studio                       1ic.BPMN-RPAstudio                   winget
Fishing Funds                         1zilc.FishingFunds                   winget
3601                                  360.360Chrome                        winget
3602                                  360.360Chrome.X                      winget
3603                                  360.360CleanMaster                   winget
3604                                  360.360se                            winget
3CX Call Flow Designer (.exe edition) 3CX.3CXCallFlowDesigner              winget`
</script>

If column1 is always 38 chars long, then

const lines = table.split(/\r?\n/)
const column1 = lines.map(line => line.slice(0,38).trim())
console.log(column1)

<script>
const table = `app115                                115.115                              winget
app225                                115.115Chrome                        winget
Knotes                                1MHz.Knotes                          winget
BPMN-RPA Studio                       1ic.BPMN-RPAstudio                   winget
Fishing Funds                         1zilc.FishingFunds                   winget
3601                                  360.360Chrome                        winget
3602                                  360.360Chrome.X                      winget
3603                                  360.360CleanMaster                   winget
3604                                  360.360se                            winget
3CX Call Flow Designer (.exe edition) 3CX.3CXCallFlowDesigner              winget`
</script>