Forum Discussion

adoalan's avatar
adoalan
Icon for Helper III rankHelper III
3 years ago

Help with formula

Hi All,   I need some help in removing -UK from both columns Source Code and Allocation and also everything was is after / in the Source Code     Any help please?   Thanks
Need Help
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Ah okay, 

 

for the -uk part you could create a column in report view:

 

Column = SUBSTITUTE('Table (2)'[Column1],"-uk","")
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

For the part after the /  you could use the search function to count the starting character using wildcards in the search e.g 

SEARCH("???-uk",'Table (2)'[Source Code], 1, 0)
 
then use a Left function to get the left value of the string up to 1 character before the start:
 
full column: 
left('Table (2)'[Source Code],SEARCH("???-uk",'Table (2)'[Source Code], 1, 0)-1 )