Character Removing from field.

[sona_sa]

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

[arulsettu]

hi try this

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

[Siva_Sankar]

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

[Siva_Sankar]

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

FROM Your table;

[Anonymous]

One more version:

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

[anbu1984]

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

[sona_sa]

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

[robert_mika]

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

FROM

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

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

[pratap6699]

TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40

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

[Siva_Sankar]

find the attached qvw also