Skip to content
Advertisement

How to remove the date from time data when it is separated by a space?

I have some data in a current .csv file that is space separated then ; separated. I get how to do the sep”;” but the problem is the spaces. It looks a little like this:

JavaScript

I need to get the date removed so that in “Time” there is only the variable of time (ie. I don’t need the system to look at the date at all as it is rather irrelevant).

How would I go about this? And is it reproducible for around 5000 bits of data?

Many thanks in advance!

Advertisement

Answer

after seperating the line with ‘;’, just split each part again after each ‘ ‘.

JavaScript
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement