Subfield Function

[wassimharfoush]

Hi All ,

I am trying to Subfield field name State to get  state name only

The field State looks like

State

Alabama Department of rev

North Carolina Department of revenue

Georgia Stat tax Department

New Jersey Divisions of taxation

What I am trying to get is

State

Alabama

North Carolina

Georgia

New Jersey

Please advise.

Thanks

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be;

mapStates:
Mapping LOAD State, '@start@'&State&'@end@'
FROM [https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States] (html, codepage is 1252, embedded labels, table is [States of the United States In North America]);

tabDep:
LOAD *,
    TextBetween(MapSubString('mapStates',Department),'@start@','@end@') as State
INLINE [
    Department
    Alabama Department of rev
    North Carolina Department of revenue
    Georgia Stat tax Department
    New Jersey Divisions of taxation
];

hope this helps

regards

Marco

[wassimharfoush]

Thank you Marco !

[MarcoWedel]

you're welcome

regards

Marco