Forum Discussion
Solved
Check column for similar values
Hi, I have a software report and on the report it has different versions on different lines eg: Microsoft Office OneDrive 21.220.1024.0005 Microsoft Office OneDrive 26.45.308.3 Its a full Software...
For your reference.
Step 1: I add a 'Software No Version' column below.
Step 2: I replaced Value,"Bit"-->"".
<After>
You could try splitting it at the first numeric character, something like
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hctLCoAgEADQqwyuaxhHk7aV2/AA4aKPgpuEks6fdIH27y2LGI68BRj2K29rATsBGySSyFJpI3zzI8Dodkzlg3Oq5s6xgIsx7QHcGeyVngBcNRNKYl0rdX/coO5QUY9KeP8C", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
SplitCol = Table.SplitColumn( #"Changed Type", "Column1",
Splitter.SplitTextByCharacterTransition( { "A".."Z", "a".."z", " ", "-"}, { "0".."9"}),
{"Name", "Version"}
),
#"Trimmed Text" = Table.TransformColumns(SplitCol,{{"Name", Text.Trim, type text}})
in
#"Trimmed Text"