Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Subfield(MID(Departamento,5),' ',1) as TestMidIndex
regards
Marco
or
Subfield(Departamento,' ',2) as TestMidIndex
?
Dear Marco,
It is fixing good!
Thanks a lot for your quik answear, i appreciate it.
Best Regards!
You're welcome
glad it helped
regards
Marco