Numeric character data in qlikview

[capriconuser]

I have this kind of data

Notes
-
B-3-I11 - Issue 
B-3-I12 -  Windows update
BI1-I190   internet speed issue
BI1-I191  Handed over 
backup server 
Installation  laptops
M Presentation
Meet Meti
Work on  documentation 

now I want only those data which start from B and have numeric characters.. i want both conditions in one field.. and I want this in script .. in load statement  like

Load

ID,

Name,

here I want condition ,

........

from table1

not in where statement.. .

[capriconuser]

any help 

[Anil_Babu_Samineni]

Do you mean this?

Load

ID,

Name,

If(WildMatch(FieldName, 'B*'), FieldName) as FiledName_OnlyB

........

from table1

[capriconuser]

yes I got data which starts from B .. but i want also which data have numeric characters.. like some data I have

B32-12-Test

so in this condition, I want only B32-12 but currently I got as B32-12-Test @Anil_Babu_Samineni 

[Anil_Babu_Samineni]

In your example I see that character  "I"

 Also please post sample inline and provide us output

[Lisa_P]

I'm not sure if this will always work, but I have used multiple preceding loads to first only include those descriptions that had a capital B, then removed the characters after the space.

Notes:
Load
LEft(Description, FindOneOf(Description, ' ')) as Code;
Load
If(FindOneOf(Description, 'B'), Description, null()) as Description;
Load * Inline [
Description
B-3-I11 - Issue
B-3-I12 - Windows update
BI1-I190 internet speed issue
BI1-I191 Handed over
backup server
Installation laptops
M Presentation
Meet Meti
Work on documentation
];