topic Re: Replacing characters in field in QlikView

Replacing characters in field

Mon, 10 Oct 2016 12:51:38 GMT

I understand the concept of using subfield to help showing or hiding characters.

I have a bit more tricky one

Say I have the follwing

1223867hrg.h345#IWantToSeeThisOnly#

what would be the best way to only see everything between the two # characters

sunny_talwar — Mon, 10 Oct 2016 12:54:52 GMT

May be try TextBetween() here:

TextBetween('1223867hrg.h345#IWantToSeeThisOnly#', '#', '#')

Mon, 10 Oct 2016 13:28:20 GMT

Thanks works well, but it you have 50 of these in a column, in one row the # is character 4, and in another its character 30 in the fields

sunny_talwar — Mon, 10 Oct 2016 13:31:12 GMT

I don't think distance between #s make any difference. Its just picking up everything between the two #s

sunny_talwar — Mon, 10 Oct 2016 13:37:50 GMT

If you want to do this on a field, you just need this:

TextBetween(FieldName, '#', '#') as NewFieldName

sunny_talwar — Mon, 10 Oct 2016 13:42:56 GMT

Have a look at this script:

Table:

LOAD *,

TextBetween(FieldName, '#', '#') as NewFieldName;

LOAD * Inline [

FieldName

1223867hrg.h345#IWantToSeeThisOnly#

1asadasfscvtgsdfsfsd223867hrg.h345#AndThis#

1223867hrg.h345#MaybeTHIS#aDASDFSADFASFASDAS

ADASDADASDAFASCFSFG1223867hrg.h345#Alrightletsgetthistoo#SFASFASFASFSA

ADADWEFRVjgsfshfgkjerghcuiahnuifajfgweuifbajksdfgasfhasklfhalscnuekdhjhf1223867hrg.h345#Justonelast#gdasjdgajfgakfga

];

Wed, 12 Oct 2016 07:57:06 GMT

Thanks. I will try this and let you know