PDA

View Full Version : Urgent - Splitting text from numbers in a column, please help



hafiz_asim@hotmail.com
2016-12-17, 12:28 PM
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

Comfy
2016-12-19, 10:28 AM
Here you go:



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.