topic Text& numeric Data in QlikView

Text& numeric Data

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Text& numeric Data

qlikview979 — Fri, 16 Jun 2017 08:55:29 GMT

Hi Experts

Help me on this

jagan‌vinieme12‌loveisfail‌avinashelite‌

Re: Text& numeric Data

sunny_talwar — Fri, 16 Jun 2017 08:58:13 GMT

What is the logic behind the expected output?

Re: Text& numeric Data

swuehl — Fri, 16 Jun 2017 09:01:07 GMT

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;

Re: Text& numeric Data

qlikview979 — Fri, 16 Jun 2017 09:01:44 GMT

Hi Brother,

This is previous thread, what you given answer last week

How to use PurgeChar along with string function

Re: Text& numeric Data

sunny_talwar — Fri, 16 Jun 2017 09:01:58 GMT

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);

Re: Text& numeric Data

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:17:11 GMT

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

Re: Text& numeric Data

qlikview979 — Fri, 16 Jun 2017 09:35:15 GMT

Hi Anil,

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

Regards

Re: Text& numeric Data

qlikview979 — Fri, 16 Jun 2017 09:36:17 GMT

Hi Brother,

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

Regards

Re: Text& numeric Data

qlikview979 — Fri, 16 Jun 2017 09:37:04 GMT

Hi Brother,

Excellent