Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi try this
SubField('TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40','\',2)
You can use subfiled, purgechar, or some other strign function. Find the attached document for your data.
Load SubField( [Database Name ],'\') as DatabaseName
FROM Your table;
One more version:
TextBetween('TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40','\','')
SubField('TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40','\',-1)
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
LOAD TextBetween([Database Name ],' ','') as [Server Name]
FROM
C:\Users\mikro01\Desktop\DB.xls
(biff, embedded labels, table is [Sheet1$]);
TPUMLONCL1SQL01\NAV_PRD_01 NAV_PROD_AFRICA_CS40
=subfield(fieldname,'TPUMLONCL1SQL01\',-1)
find the attached qvw also