Text& numeric Data

[qlikview979]

Hi Experts,

I have Data column data like this.in this column having 1000's of records.

Input:-

Data

123Art Johnson,III

Dustin Graves

!!!$%VALMONT INDUSTRIES, INC.

PACCAR####

CTC-Suite Renovation Program-1x4

&&&*****Unknown****

****CRM****####

12345 JCI project. 57 Luxor 300 156 Luxor 600

AAP !!!####%%%%&&&

****AAMCOR ***

123134343424542sasdsfpoi*******

Ashish

423165 Amit1234

Output:-

Ashish

Amit1234

Dustin Graves

How can i achieve this ?

[qlikview979]

Hi Experts

Help me on this

jagan‌vinieme12‌loveisfail‌avinashelite‌

[sunny_talwar]

What is the logic behind the expected output?

[swuehl]

Is there anything that qualifies the records you want to include for the output or that disqualifies the other records?

For example, if you want only records that contain no space, '#', '!', '*', you can use a WHERE clause with a FindOneof():

LOAD Data

From YourSource

WHERE FindOneOf(Data,' !*#') = 0;

[qlikview979]

Hi Brother,

This is previous thread, what you given answer last week

How to use PurgeChar along with string function

[sunny_talwar · Accepted solution]

May be this

Table:

LOAD * INLINE [

    Data

    "123Art Johnson,III"

    Dustin Graves

    "!!!$%VALMONT INDUSTRIES, INC."

    PACCAR####

    CTC-Suite Renovation Program-1x4

    &&&*****Unknown****

    ****CRM****####

    12345 JCI project. 57 Luxor 300 156 Luxor 600

    AAP !!!####%%%%&&&

    ****AAMCOR ***

    123134343424542sasdsfpoi*******

    Ashish

    423165

    Amit1234

] Where Len(Trim(KeepChar(Data, '~!@#$%^&*().,-'))) = 0 and not IsNum(Data);

[Anil_Babu_Samineni]

When you want Amit1234, Why don't you need '123Art Johnson'??

[qlikview979]

Hi Anil,

Here i  want what are records starting with alphabets(A to Z, a to z)  with numbers.

Regards

[qlikview979]

Hi Brother,

I tried with your where condition its not giving name like"Dustin Graves" in listbox.

Regards

[qlikview979]

Hi Brother,

Excellent