How do you split two string values joined in one field?

[mdmaala]

hi!

Under the field Username, I have two lists, Machine1 and Machine2

I want to split this into two separate columns Machine 1 and Machine2

how can I do this? Thanks!

I tried using my search...| rex field=Username "(?Machine1)(?Machine2)", but it's not working.

[woodcock]

Like this:

... | eval Machine1 = mvindex(Username, 0), Machine2 = mvindex(Username, 1)

[spavin]

Can you give us a sample field to work with? Does it look like: Machine 1 Machine 2?

[mdmaala]

the table looks like this:

| Username |
Machine 1
Machine 2

I want to separate the username field into Machine1 and Machine2