Read text in a row until the special character found

[#1]

I have a data field which consists of delay reason and department name in an one data row.

Eg:

Long Text
Shade Issue * Dying
No Greige * Aw Greige

I want to read above data field and need to load data in to two columns as below.

Long Text	Delay Reason	Department
Shade Issue * Dying	Shade Issue	Dying
No Greige * Aw Greige	No Greige	Aw Greige

Please help on this..

[tresesco · Accepted solution]

If your special character is always '*', you can try like:

Load

          SubField([Long Text], '*' , 1) as [Delay Reason],

          SubField([Long Text], '*', 2) as Department

[rohit214]

use below code

For Delay reason:- subfield([Long Text],'*')

for Department:-(subfield([Long Text],'*',2)

thanks

rohit

[#4]

It works !!  Thanks alot