How can I isolate a word or words from a sentence?

[kopernikus]

Hello
How can I isolate a word or words from a sentence? (Without character numbering). Examble
city New York country usa id NY
How can give in a Label only New York

(that is, that which exists between city and coyntry) and a other Label only usa and a third Label ony NY

[dora_paz]

Maybe something like this

[kopernikus]

@dora_paz

Maybe something like this

Thanks
And how can i view only the last word NY ?

[Anke]

@kopernikus

And how can i view only the last word NY ?

[dora_paz]

Or

[Anke]

[kopernikus]

The last word NY from Anke Block code dosn't work, i view only Y and no NY.
For this it works the dora_paz Block
Thanks!

[Anke]

@kopernikus

The last word NY from Anke Block code dosn't work, i view only Y and no NY .

Show your blocks.

[TIMAI2]

Do all three in one go:

It would be much easier if you sorted out your original data in the first place so that you had a well formatted csv file:

New York,USA,NY
Miami,USA,FL
Richmond,USA,VA

[dora_paz]

He is not using empty space

[Anke]

@kopernikus

For this it works the dora_paz Block

No, because of this:
Riverside state_id CA county_name Riverside

Split at one space:

[dora_paz]

@Anke is right. I didn't consider the case that a city might contain id as Riverside

[SteveJG]

@TIMAI2

It would be much easier if you sorted out your original data in the first place so that you had a well formatted csv file:

New York,USA,NY
Miami,USA,FL
Richmond,USA,VA

You can segregate using a List like this @kopernikus :

You can uses spaces to separate if no 'items' are composed of two 'words' ... New York > New_York

[Anke]

[kopernikus]

Hello again
I noticed the following problem. I can not display only the word York
I applied the above but it does not work

The result is city York and no only York

[Anke]

@kopernikus

The result is city York and no only York

What is the purpose / goal?

[kopernikus]

@Anke

What is the purpose / goal?

There is no want. York was a bad example. Better to isolate the word usa
without typing in segment "city New York country" because instead of New York he can write another city. The fixed words that do not change are city , country id.

[Anke]

I've already shown you a way to do it:

@Anke

@kopernikus

York was a bad example.

Then show us a good example, next time.

[kopernikus]

For example I have the following list.

    city New York country Usa id NY
    city Athens country Greece id ATH
    city Rome country Italy id ROM

From the list the fixed words are city,country,id
Depending on what will be selected from the list, I want to isolate only the country, that is USA,Greece,Italy.

[Peter]

Why do you want to keep using this format. It makes things much to complicated. Why not use a CSV format?

city,country,id
New York,USA,NY

or use JSON

[
{
"city": "New York",
"country": "Usa",
"id": "NY"
}
]