Forum Discussion
Text Extract - 2
- Jun 06, 2025
Perhaps like this
I know you're looking for a PQ or legacy solution but I'd handle this with a Lambda. The Lambda created is portable and can be moved to any workbook where needed.
SignalSplitλ = LAMBDA(table_col,
LET(
//Assign header
header, {
"MeasQuantityResults-CellIdentity","rsrp","rsrq","sinr","",
"ssbIndex","rsrp","rsrq","sinr"},
//Wrap vector - 1 record = 19 rows
wrapped, WRAPROWS(table_col, 19, ""),
//Concat and covert back to vector
joined, BYROW(wrapped, CONCAT),
//Remove double quotes to simplify extraction
cleaned, SUBSTITUTE(joined, """", ""),
//Function to extract text between two delimiters
TextBetweenλ, LAMBDA(texts, after_delim, before_delim,
TEXTBEFORE(TEXTAFTER(texts, after_delim, , , , ""), before_delim, , , , "")
),
//Extract text between delimiters:
cell_identity, TextBetweenλ(cleaned, "310/260-", ","),
rsrp, TextBetweenλ(cleaned, "rsrp: ", ","),
rsrq, TextBetweenλ(cleaned, "rsrq: ", ","),
sinr, TextBetweenλ(cleaned, "sinr: ", " }"),
ssb_index, TextBetweenλ(cleaned, "ssbIndex: ", ","),
//"Space" vector to be added in middle of return matrix
space, EXPAND("", ROWS(rsrp), , ""),
//Stack columns
return, VSTACK(
header,
HSTACK(cell_identity, rsrp, rsrq, sinr, space, ssb_index, rsrp, rsrq, sinr)
),
return
)
);
At the sheet level the formula is:
Thanks Patrick2788 , but seems some data is missing, example the rsrp,rsrq and sinr measurements for the ssbindex 3,2,1,0 for this CellIdentity 833748994 is missing:-
Br,
Anupam
- Patrick2788Jun 06, 2025Silver Contributor
I think I have what you're looking for with the extraction. The return can be polished a bit more if needed but I think the ssbindex is there. Please see revised workbook.
- anupambit1797Jun 06, 2025Iron Contributor
As you see in each line(entry) for the Signals, we have below ssbindexes
Br,
Anupam
- SergeiBaklanJun 06, 2025Diamond Contributor
Perhaps like this
- anupambit1797Jun 09, 2025Iron Contributor
Thanks SergeiBaklan exactly what I wanted... can you please also enable the Time-stamp against each entry?
Br,
Anupam