Forum Discussion
Vinma7
Jun 24, 2022Copper Contributor
Two Questions, please help
I really need some guidance about these two situation please help. My data looks something like this: 3.50 Earth 3.75 Sezer 4.33 Cottami Lane 1.67 I am Courageous Knight 6.00 Ezaji 8.00 Qu...
mathetes
Jun 24, 2022Silver Contributor
You wrote:
- My data looks something like this:
So presumably there are other instances where the "something like" has multiple words to be put together, sometimes two words, sometimes three, sometimes four....
A first question back to you would be "What's the source of this data?" Followed by "Can that source be directed to provide the data in the manner you desire?"
The inconsistencies here are the biggest part of the challenge. That's why I suggest first seeing if the source could be modified.