SOLVED
Parse String with Letters and Numbers
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jatienza
8 - Asteroid
‎02-22-2023
01:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Need help in parsing the raw data below. Output is also given below.
Raw Data
add |
England EC2A 4 |
London N1 9QS |
South Yorkshire S60 1DL |
NORTHUMBERLAND |
Tyne and Wear CH45 4JL |
Kent BR6 8NL |
England |
Wales 89B |
England DN5 0 |
Output
add1 | add2 |
England | EC2A 4 |
London | N1 9QS |
South Yorkshire | S60 1DL |
NORTHUMBERLAND | |
Tyne and Wear | CH45 4JL |
Kent | BR6 8NL |
England | |
Wales | 89B |
England | DN5 0 |
Solved! Go to Solution.
4 REPLIES 4
14 - Magnetar
‎02-22-2023
01:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-22-2023
01:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BS_THE_ANALYST it's working but doesn't work if it is in Uppercase like this one:
add | add1 | add2 |
WEST YORKSHIRE BD5 7HF | WEST | YORKSHIRE BD5 7HF |
14 - Magnetar
‎02-22-2023
02:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-22-2023
02:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BS_THE_ANALYST it is working now. Thanks a lot.
