Forum Discussion
Split to values
Dear Experts, I have a txt file m whose structure is like this:- tci-StateId x, qcl-Type1 { bwp-Id 0, referenceSignal Signal: y, (Signal can be ssb or csi-rs) qcl-Type typ...
Thanks peiyezhu , but as mentioned earlier, I am not a coder , looking for something in Power Query, with the Power Editor steps to achieve this.
Thanks,
Br,
Anupam
Thanks for your response.
Yes,I see.
As part of brain storm in this forum,I just provide it for reference rather than standard answer.
I guess PQ here may need regular expression too.
So,maybe help to some PQ expert.
On the other hand,here I guess you also need codes with M language (https://powerquery.how/#:~:text=The%20M%20language%20Power%20Query%20M%2C%20a%20language,the%20Power%20BI%2C%20Excel%2C%20and%20other%20Microsoft%20products.) rather than only click and drag drop.
Yes,I see.
As part of brain storm in this forum,I just provide it for reference rather than standard answer.
I guess PQ here may need regular expression too.
So,maybe help to some PQ expert.
On the other hand,here I guess you also need codes with M language (https://powerquery.how/#:~:text=The%20M%20language%20Power%20Query%20M%2C%20a%20language,the%20Power%20BI%2C%20Excel%2C%20and%20other%20Microsoft%20products.) rather than only click and drag drop.
Thankspeiyezhu , in general if I have to learn only one Language for Data-manipulation and cleaning(ETL), then what it should be python or php? I heard python is more easier and lesser code lines than other languages..
Br,
Anupam
Yes. Python is a great option which has many resources.
If you use the codes for yourself,I recommend Python.
Go,C# and php also great.
php is easy to start and good at web program.
Go,C# dotnet for desktop and can be compiled to Exe.
