[Solved] String manipulation trial using functions

[Nicholas59]

Good Morning,

I was wondering whether it would have been possible peeking simple words in a cell to rearrange them in plain text.
For this reason, i have attached a "french cuisine" simple spreadsheet.
Your comments would be really appreciated.
Regards

[karolus]

Libreoffice:

Code: Select all

=REGEX(C3;"^(\w+)\b.*?\b(\w+)$";"$2 de $1")

[Nicholas59]

I beg your pardon, karolus, but it seems there are troubles with brackets. (Error #NAME).

Could however be the fact that my version is 7.3.7...

Thanks

[robleyd]

#NAME error has nothing to do with brackets.

525 #NAME?

Invalid names

An identifier could not be evaluated, for example, no valid reference, no valid function name, no column/row label, no macro, incorrect decimal separator, add-in not found.

See column I in the attached file where Karolus' formula functions as expected.
REGEX function was introduced in LO 6.2

Of course this is a specific solution for a specific case as per your sample. Doubtless your real life situation will be more varied; in which case you'll need to provide more detail on exactly what you are trying to achieve.

[karolus]

I beg your pardon, karolus, but it seems there are troubles with brackets. (Error #NAME).

I would guess you have trouble wth copy & paste, so far I can see the localized Function-name for »REGEX« is in french also »REGEX« !!

btw. it seems the topic is inspired by https://ask.libreoffice.org/t/tableau-d ... ion/112848

[Nicholas59]

Thank you karolus and robleyd. You help was precious. REGEX in italian would be ESPR.REG().

[Lupp]

Possibly even a bit simpler and easier to understand:

Code: Select all

=REGEX(C3;"(.*), (.*)";"$2 de $1";1)

for the first example.

[Nicholas59]

Bedanke mich, Lupp. Das war sehr nett.