Jump to content


Photo

Get & Transform - split columns by a number of different delimiters in a variable length text field

Get and Transform

  • Please log in to reply
No replies to this topic

#1 JEN

JEN

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 24 March 2019 - 03:30 PM

Hi 

 

Is it possible in the Get and Transform function to split columns by more than one delimiter in a variable length text string. For Example

 

PT1007 WE:  23-02-2017 Name: J Jones ST  25 Units 

PT1007 WE:  20-02-2017 Name: Tom E Westward ST 100 Units 

 

 

hence in the above example  split columns at the same time by the following 'different' delimiters 

 

WE:

Name:

ST

Units

 

Grateful for all your advice 

 

If you are able to assist can you reply with a screen shot please of the formula I need to enter so I can see what is needed 

 

Thankyou 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users