Column transformation removal of extra numbers

[SK28]

Hi

I have sample data as show below

Parent

ABC-1013.V2-24187

ABC-1013.V2

ABC-1046.V2-24428

ABC-1046.V2

ABC-1178.V2-25465

ABC-1178.V2

ABC-1229.V2-25925

ABC-1229.V2

ABC-1250.V2-26366

ABC-1250.V2

ABC-1323.V2-27096

ABC-1323.V2

ABC-1365.V2-24243

ABC-1365.V2

ABC-1597.V2-19167

ABC-1597.V2

ABC-1631.V2-25265

ABC-1631.V2

ABC-1701.V2-21053

Output should for above table:

parent

ABC-1013.V2

ABC-1013.V2

ABC-1046.V2

ABC-1046.V2

ABC-1178.V2

ABC-1178.V2

ABC-1229.V2

ABC-1229.V2

ABC-1250.V2

ABC-1250.V2

ABC-1323.V2

ABC-1323.V2

ABC-1365.V2

ABC-1365.V2

ABC-1597.V2

ABC-1597.V2

ABC-1631.V2

ABC-1631.V2

and I have 2nd Requirement:

Table 2:

Column A, "Requirement is the data set", I want to get the Column B "Expected Output"

These two requirements, Can anyone please help me on this

Requirement	Expected Output
ABC-1046.V2 (3)	ABC-1046.V2
ABC-1178.V2 (3)	ABC-1178.V2
ABC-1229.V2 (3)	ABC-1229.V2
ABC-1597.V2 (3)	ABC-1597.V2
ABC-1701.V2 (32)	ABC-1701.V2
ABC-5018.V1 (3)	ABC-5018.V1
ABC-5025.V1 (3)	ABC-5025.V1
ABC-5056.V1 (3)	ABC-5056.V1
ABC-5058.V1 (4)	ABC-5058.V1
ABC-5059.V1 (3)	ABC-5059.V1
ABC-5064.V1 (3)	ABC-5064.V1
ABC-5065.V1 (3)	ABC-5065.V1
ABC-5082.V1 (1)	ABC-5082.V1
ABC-5119.V1 (1)	ABC-5119.V1
ABC-1631.V2 (3)	ABC-1631.V2
ABC-5067.V1 (4)	ABC-5067.V1
ABC-5091.V1 (4)	ABC-5091.V1
ABC-5106.V1 (4)	ABC-5106.V1
ABC-5107.V1 (1)	ABC-5107.V1
ABC-994.V3 (3)	ABC-994.V3
ABC-5060.V1 (3)	ABC-5060.V1
ABC-5086.V1 (6)	ABC-5086.V1
ABC-5087.V1 (6)	ABC-5087.V1
ABC-5093.V1 (2)	ABC-5093.V1
ABC-5094.V1 (1)	ABC-5094.V1
ABC-5095.V1 (3)	ABC-5095.V1
ABC-5098.V1 (1)	ABC-5098.V1
ABC-5100.V1 (1)	ABC-5100.V1
ABC-5113.V1 (1)	ABC-5113.V1
ABC-5114.V1 (1)	ABC-5114.V1
ABC-5115.V1 (1)	ABC-5115.V1
ABC-5116.V1 (1)	ABC-5116.V1
ABC-5117.V1 (1)	ABC-5117.V1
ABC-5118.V1 (1)	ABC-5118.V1
ABC-975.V2 (3)	ABC-975.V2
ABC-976.V2 (3)	ABC-976.V2
ABC-1013.V2 (3)	ABC-1013.V2
ABC-1250.V2 (3)	ABC-1250.V2
ABC-1323.V2 (3)	ABC-1323.V2
ABC-1365.V2 (3)	ABC-1365.V2
ABC-28.V2 (3)	ABC-28.V2
ABC-417.V2 (3)	ABC-417.V2
ABC-419.V2 (6)	ABC-419.V2
ABC-5004.V1 (1)	ABC-5004.V1
ABC-5061.V1 (3)	ABC-5061.V1

[BrunPierre]

Hi, as below.

Left(Parent,11) as Parent

SubField(Requirement,' ',1) as "Expected Output"

[aveeeeeee7en · Accepted solution]

Hi @SK28,

Try this:

Requirement1 Solution:
Left(Parent,(Len(Subfield(Parent,'-',1))+Len(Subfield(Parent,'-',2))+1))

This solution will also work if you've multiple delimiters ('-') in your data.

Requirement2 Solution:
Trim(Subfield('ABC-1046.V2 (3)','(',1))

This solution will also work if your data doesn't have space between values & bracket.

Regards,

Av7eN

[SK28]

Thank you @aveeeeeee7en