topic Re: Character Removing from field. in QlikView

Character Removing from field.

sona_sa — Fri, 12 Jun 2015 03:44:25 GMT

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

Re: Character Removing from field.

arulsettu — Fri, 12 Jun 2015 03:58:09 GMT

hi try this

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

Re: Character Removing from field.

Siva_Sankar — Fri, 12 Jun 2015 04:03:38 GMT

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

Re: Character Removing from field.

Siva_Sankar — Fri, 12 Jun 2015 04:05:51 GMT

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

FROM Your table;

Re: Character Removing from field.

Anonymous — Fri, 12 Jun 2015 04:12:22 GMT

One more version:

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

Re: Character Removing from field.

anbu1984 — Fri, 12 Jun 2015 04:16:23 GMT

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

Re: Character Removing from field.

sona_sa — Fri, 12 Jun 2015 05:36:42 GMT

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.

robert_mika — Fri, 12 Jun 2015 06:07:42 GMT

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

FROM

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

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

Re: Character Removing from field.

pratap6699 — Fri, 12 Jun 2015 06:11:04 GMT

TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40

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

Re: Character Removing from field.

Siva_Sankar — Fri, 12 Jun 2015 06:43:05 GMT

find the attached qvw also