Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Oct 17, 2024
Solved

TEXT PARSING

Dear Experts,                      In the Attached text file, each entry has a following structure:- Reference Signal can be SSB or TRS and Rx[] ports can go from 0~3,   In the output, I n...
BI & Data Analysis
excel
Formulas and Functions
power bi
  • Lorenzo's avatar
    Lorenzo
    Oct 18, 2024

    Hi anupambit1797 

     

    See PQ attached file. Not optimized for sure, just made sure it does the job...

    (don't forget to change the file path in query 'CSV', it's currently mine)

anupambit1797's avatar
anupambit1797
Iron Contributor
Oct 18, 2024

Thanks Lorenzo , meanwhile do you know if and how I can bring all the SNR entry's in the same line as

their respective RX[] ports? I tried to play something replace etc "   " with "", but nothing worked out.

In notepad++ how to achieve this?

Something like below:-

Thanks in Advance,

Br,

Anupam

 

Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 19, 2024

anupambit1797 

If this is what you meant (query output):

In attached file function query:

// fxAlignRxSnr
(InputTable as table) as table =>
let
    Source = InputTable,
    KeptColumn1 = Table.SelectColumns( Source, "Column1"),
    AddedIndex = Table.AddIndexColumn( KeptColumn1, "Index", 0, 1),

    FindRx = Table.FindText( AddedIndex, "RX["),
      Rx_FirstPosition = Table.First( FindRx )[Index],
      Rx_ToColumn = FindRx[Column1],

    Find_Snr = Table.FindText( AddedIndex, "SNR = "),
      Snr_ToColumn = Find_Snr[Column1],

    TableFromColumns = Table.FromColumns(
      { Rx_ToColumn, Snr_ToColumn },
      {"RX", "SNR"}
    ),
    MergedColumns = Table.CombineColumns( TableFromColumns,
        {"RX", "SNR"}, Combiner.CombineTextByDelimiter("", QuoteStyle.None),
        "Column1"
    ),

    CombinedTables = Table.Combine(
        { Table.FirstN( AddedIndex, Rx_FirstPosition),  MergedColumns }
    ),
    RemovedIndex = Table.RemoveColumns( CombinedTables, {"Index"} )
in
    // This prevents the function query to result as error if no "RX[" was found
    if Table.IsEmpty( FindRx ) then Source else RemovedIndex

 

Resources