AnsweredAssumed Answered

Help on a script

Question asked by thereddiespirit on Oct 10, 2017
Latest reply on Oct 13, 2017 by philmodjunk

I need to concatenate fields and separate by a pipe IF there is a major to follow it.

 

ID#

MAJOR1

MAJOR2

MAJOR3

1

English

Spanish

French

2

Business

Finance

 

3

Music

 

 

 

I need the result to be

English | Spanish | French

Business | Finance

Music

 

Thanks in advance!

 

jc

Outcomes