Break string into columns using Regular Expression

Question

I am new in regex, i want to break the give string into 6 parts using regular expression. I am using the Pentaho data integration tool (ETL tool)

Given string: 1x 3.5 mL SST. 1x 4.0 mL gray cap cryovial.

Note: There are many more string with same format

I want output as:

Thanks in advance !!

Even if you're new you must have tried something, right. What? And more input examples wouldn't hurt. — SamWhan, Mar 06 '18 at 12:27
Actually don't know the reasons, why people down vote this question ? — DHARMINDER, Mar 06 '18 at 12:29
Terrible to have only a single given string let alone asking for attempts. — Nae, Mar 06 '18 at 12:29
@DHARMINDER You can read the comments here for downvote(s) in this specific case. — Nae, Mar 06 '18 at 12:30
I was reading regular expression for while, but still confused how to solve this problem — DHARMINDER, Mar 06 '18 at 12:32

Srdjan M. · Answer 1 · 2018-03-06T13:10:06.120

1

Use split function and regex \. | mL |x

var text = '1x 3.5 mL SST. 1x 4.0 mL gray cap cryovial'
arr = text.split(/\. | mL |x /g)

var tb = document.getElementById("table")
//creat row
var tr = document.createElement("tr")

for (s of arr) {
  // create cell
  var td = document.createElement("td")
  var txt = document.createTextNode(s);
  td.appendChild(txt)
  tr.appendChild(td)
}

tb.appendChild(tr);

<table id='table' border="1">
  <tr>
    <th>Par_Count</th>
    <th>Par_Qty</th> 
    <th>Par_Tube</th>
    <th>Child_Count</th>
    <th>Child_Qty</th>
    <th>Child_Tube</th>
  </tr>
</table>

edited Mar 06 '18 at 13:10

answered Mar 06 '18 at 12:29

Srdjan M.

3,310
3
13
34

Thanks for ur response, the code is breaking the string as expected. But can we make it in one row? as shown in output ? – DHARMINDER Mar 06 '18 at 12:37
@DHARMINDER You mean as one string? – Srdjan M. Mar 06 '18 at 12:40
Can we make it in separate columns ? with column headings – DHARMINDER Mar 06 '18 at 12:41
@ S.Jovan Can we make the output separate columns headings ? – DHARMINDER Mar 06 '18 at 12:48
@DHARMINDER You question was asking about regex, and splitting. This is what this does. RegEx has no concept of column headings. So in this context your now asking a different question. – Keith Mar 06 '18 at 12:50
@ S.Jovan Sorry for the confusion, almost got the output. – DHARMINDER Mar 06 '18 at 13:05

Nae · Accepted Answer · 2018-03-06T13:36:10.980

1

The single string datum you've given looks like it should match the regex pattern:

(\d*)x\s(\d*\.\d*)\smL\s(.*)\.\s(\d*)x\s(\d*\.\d*)\smL\s(.*)\.

You can use it with Regex Evaluation step:

edited Mar 06 '18 at 13:36

answered Mar 06 '18 at 13:19

Nae

14,209
7
52
79

Break string into columns using Regular Expression

2 Answers2

Linked