Query question

[tamer64]

Hi all,

I have query that exports data. one of my fields is called "lockerAssign". Within that column it looks like this: Locker B| Lock101|Radio49

Is there a way to break out each one of these into three different fields ?

Field1:Locker B
Field2:Lock101
Field3:Radio49

 

[genomon]

Take a look at the SPLIT function; looks like the data is already delimited with the | character.

The early bird may get the worm, but the second mouse gets the cheese in the trap.

 

[tamer64]

Thank You genomon for pointing me in the right direction. Split Function worked perfectly.

 

[genomon]

Glad it worked!


The early bird may get the worm, but the second mouse gets the cheese in the trap.