topic Re: Truncate Text in QlikView

Truncate Text

jumiprado — Wed, 14 Dec 2016 12:12:12 GMT

Hey guys! I need your help again!

I have a field with string with numbers and letters and I need take only a part of the string

for example:

001024110672 SILVA VERONICA FERNANDA 01OT2407197405000

001048562116 BARRERA SOFIA MORENA 02HO0203200805000

I need to take the text in bold font, i try with this UPPER(replace(keepChar(NAME,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ '),' ','')) as NAME but i have 2 letters in the alphanumeric string.

001024110672 SILVA VERONICA FERNANDA 01OT2407197405000

001048562116 BARRERA SOFIA MORENA 02HO0203200805000

How can i do for take only SILVA VERONICA FERNANDA and BARRERA SOFIA MORENA

Thanks You!

Re: Truncate Text

sunny_talwar — Wed, 14 Dec 2016 12:15:08 GMT

May be TextBetween()

Trim(TextBetween(NAME, ' ', ' ')) as NAME

UPDATE: May be this:

Trim(Mid(NAME, FindOneOf(NAME, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'), FindOneOf(NAME, ' ', -1) - FindOneOf(NAME, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) as NAME;

Re: Truncate Text

Chanty4u — Wed, 14 Dec 2016 12:16:07 GMT

try this

LOAD * INLINE [

Field

001024110672 SILVA VERONICA FERNANDA 01OT2407197405000

001048562116 BARRERA SOFIA MORENA 02HO0203200805000

];

Result:

LOAD *,

PurgeChar(Field,'0123456789') as new

Resident a;

Re: Truncate Text

Anonymous — Wed, 14 Dec 2016 12:37:57 GMT

This works for me....

data:
LOAD
trim(SubField(input,' ',2)) as new_input;
LOAD * INLINE [
input
001024110672 SILVA VERONICA FERNANDA 01OT2407197405000
001048562116 BARRERA SOFIA MORENA 02HO0203200805000
];

Re: Truncate Text

swuehl — Wed, 14 Dec 2016 13:13:32 GMT

Are the first part and the last part of fixed length? Looking at your sample, it could be 12 and 17 chars.

This could help in filtering your names:

Trim(Mid(NAME, 13, Len(NAME)-(12+17))) as NAME