Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

akumar_c
Contributor

Character Removing from field.

Hi

I have a field Database Name, There is some unwanted character is there. Now I want to pick the character after Backslace (\). For example : TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40

Output : NAV_PRD_01 NAV_PROD_AFRICA_CS40

For ref. please find the xls.

Thanks & Regards,

Kumar

9 Replies
arulsettu
Honored Contributor III

Re: Character Removing from field.

hi try this

SubField('TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40','\',2)

Siva_Sankar
Honored Contributor

Re: Character Removing from field.

You can use subfiled, purgechar, or some other strign function. Find the attached document for your data.

Siva_Sankar
Honored Contributor

Re: Character Removing from field.

Load SubField( [Database Name  ],'\') as DatabaseName

FROM Your table;

mov
Esteemed Contributor III

Re: Character Removing from field.

One more version:

TextBetween('TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40','\','')

Highlighted
anbu1984
Honored Contributor III

Re: Character Removing from field.

SubField('TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40','\',-1)

akumar_c
Contributor

Re: Character Removing from field.

Now There is one more challenge :

1 . TPUMALOY2K05\NAVBELIZE NAV_PROD_BELIZE - After \ there is Server Name and then DB Name is there That DB Name required. NAV_PROD_BELIZE

For Ex : TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40 -  NAV_PROD_AFRICA_CS40

Re: Character Removing from field.

LOAD TextBetween([Database Name  ],' ','') as [Server Name]

FROM

C:\Users\mikro01\Desktop\DB.xls

(biff, embedded labels, table is [Sheet1$]);

12-Jun-15 7-06-53 AM.jpg

pratap6699
Contributor

Re: Character Removing from field.

TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40

=subfield(fieldname,'TPUMLONCL1SQL01\',-1)

Siva_Sankar
Honored Contributor

Re: Character Removing from field.

find the attached qvw also

Subfileld.bmp