Urgent - Splitting text from numbers in a column, please help

H

hafiz_asim@hotmail.com

New member
Joined
Aug 10, 2016
Messages
9
Reaction score
0
Points
0
Dear support,

here is the data which i need to split please guide.

Regards,

Data is formatted as follows.

Job Id
9580
9581
MAINTENANCE
8008_ABC
8009_ABC
8011_ABC
8012_ABC
8403_ABC
8806_ABC
INTERDIVISION - DISKs
4511_DEF

Required Out put in one column should be and rest in another.

MAINTENANCE
INTERDIVISION - DISKs
 
Here you go:

Code: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Job ID", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "ContainsNum", each List.AnyTrue(List.Transform(List.Transform({48..57}, each Character.FromNumber(_)), (substring) => Text.Contains([Job ID], substring))))
in
    #"Added Custom"

Then Filter by FALSE to show Text only
Filter by TRUE to show Jobs containing numbers.
 
You must log in or register to reply here.
Back
Top