Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi. Newbie user of PowerQuery, so please excuse me is there is an obvious answer in the documentation, which I did not fully read before asking.
GS1-128 is a barcode encoding where the data are strings of characters prefixed with a 2-digit application identifier (AI), strings which are then concanated.
I got readings from a barcode scanners which are packed, i.e. the example from the wikipedia page would show as
00123456780000000001
2112345 1109010117100101
11090101171001012112345
(let's ignore for a moment 4-digit AIs, or the encoding of [FNC1] since I cannot write "character" GS on the board.)
I would like to transform those readings into a number of columns, one for each AI.
I believe it should be possible to extract several columns in M.
But what I am not easy with is to "consume" the input and how to "slice" it.
In traditional programming languages, it would use an index/pointer initialised to the begining of the string, a do{}until(end-of-string) loop and a select/case based on next two characters then advance pointer. But I do not know how to translate that logic into M...
Hi @antoineL ,
If all fields in the coumn have the same length and format, you can use split columns in power query directly, please refer:
If not, I think need to group them first which have the same length and format and then use split columns by number of characters.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @antoineL
Please show clearly the initial data and the expected result
Share it in text-tabular format so that the contents can be copied
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. Cheers |