How to get a word into a text string field

[#1]

Hello Everybody! Could guide to me in this question please?

The case is:

I have a field with the number and description of the department.
But I require only show the first word of the department without their number.
The issue is when the departmet has 1 word, it solution can't do it, because the delimiter isn't a space or any other.

I tried it with the following function:

MID(Departamento,4,Index(Departamento,' ',2)-4) as TestMidIndex

Also attach an excel and qvd examples.

I will appreciate your support.
Thanks for advance

[MarcoWedel]

Subfield(MID(Departamento,5),' ',1) as TestMidIndex

regards

Marco

[MarcoWedel · Accepted solution]

or

Subfield(Departamento,' ',2) as TestMidIndex

?

[#4]

Dear Marco,

It is fixing good!

Thanks a lot for your quik answear, i appreciate it.

Best Regards!

[MarcoWedel]

You're welcome

glad it helped

regards

Marco