🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-31-2018 08:44 AM
(1588 views)
Mountain Continent Country
Aconcagua South America Argentina
Everest Asia Nepal
Elbrus Europe Russia
Denali North America United States
Kilimanjaro Africa Tanzania
Kosciuszko Australia Australia
kindly provide an input method such that mountain continent and country will be allocated in correct columns
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You will have to base your solution on the fact that there are small number of possible continents. One rudimentary approach is read in entire lines to replace each occurrence of each continent name with a delimited string .
For example replace "North America" with ", North America , "
Then read the resulting strings as a delimited file.
For example replace "North America" with ", North America , "
Then read the resulting strings as a delimited file.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You will have to base your solution on the fact that there are small number of possible continents. One rudimentary approach is read in entire lines to replace each occurrence of each continent name with a delimited string .
For example replace "North America" with ", North America , "
Then read the resulting strings as a delimited file.
For example replace "North America" with ", North America , "
Then read the resulting strings as a delimited file.