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

[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"
}
]

[Anke]

@kopernikus

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.

Needlessly complicated, but if you have to, like this:

[kopernikus]

Thank you very much.
The easiest, because I do not want the whole list but only his selection for example only from

city New York country Usa id NY

I want the view only country USA

The result is USA is what I wanted !!
Thanks an all