0

How to Extract part of data in string within Incorta

Question:

I'm trying to determine if there is a solution within incorta (ideally a formula column in my schema) to split up a string value and extract part of it to its own column.

Here is some sample data from the source column.

72005-31127077 -0242 -V-CUC-VI 
72005-31121274 -0242 -V-CUC-VI 
72005-6075 -1 -V-CUC-VI 
72005-6075 -1 -V-CUC-VI 
72005-31129469 -0242 -V-CUC-VI 
72005-31080969-356 -0242 -V-CUC-VI 
72005-31032261 -1 -S-MV-MS 
72005-31127089 -1 -S-MV-MS 
75010-CUC-MV-MS -1 -S-MV-MS

What is needed is the string after the first dash and before the trailing white space.

Example of what i want to keep using the same example data.

31127077 
31121274 
6075 
6075 
31129469 
31080969-356 
31032261 
31127089 
CUC-MV-MS

Is there anything you can suggest in Incorta to achieve this?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • The Answer:

     

    Please try the following formula:

    splitPart(Value,'-',2)
    

    The output as below:

    Value Output
    72005-31127077 -0242 -V-CUC-VI  31127077
    72005-31121274 -0242 -V-CUC-VI  31121274
    72005-6075 -1 -V-CUC-VI  6075
    72005-6075 -1 -V-CUC-VI  6075
    72005-31129469 -0242 -V-CUC-VI  31129469
    72005-31080969-356 -0242 -V-CUC-VI  31080969
    72005-31032261 -1 -S-MV-MS  31032261
    72005-31127089 -1 -S-MV-MS  31127089
    75010-CUC-MV-MS -1 -S-MV-MS CUC
    Like 3
Like Follow
  • 5 mths agoLast active
  • 1Replies
  • 21Views
  • 1 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!