.csv files

[dragonrider]

over time i have collected poi's in one file.i want to look at it in mapsource but i cant convert to gpx. i think the reason i cant convert is because i have two file types in one file. One lot of files has the info in four columns(ABCD) and the others have three columns(ABC)
Does anybody know how i can split the files(there is over a 1000)or maybe moving column D into C without losing the info in C or splitting the info in C into C an D, I know i could do this by selecting the individual rows but hopefully there is a quicker way

 

[GSmonkey]

Just do it in MS Excel....

 

[dragonrider]

maybe i didnt explain but can someone tell me how to do it, i realise i will have to use xl because thats where .csv files are(not used xl before) been pokin around tho so is there a format or should i use data sort...if so how

 

[Clive]

maybe moving column D into C without losing the info in C or splitting the info in C into C an D,

I think I follow this

- can you give a couple of examples of what values are in D and C that you want to end up in C and similarly a couple of examples for the "split"

 

[HMR]

First, be careful when you import/export the data to Excel. Open/Save will typically not result in something readable by Mapsource. Use import/export.

Second, sort all rows according to 4:th column. Now you will have all 3-data rows separated from the 4-data rows.

Third, just do the required copy/paste operations on a group of rows.

OK?

 

[dragonrider]

HMR thanks alot just what i was after,, it does leave me with another problem now, the file with 3columns has converted and opened in mapsource but the file with four columns wont...is it possible to merge D with C keeping the info in C and adding D to it...thanks again

 

[dragonrider]

hi clive only reading your request for examples now, my csv files contain geocache locations and descriptions
example1; logtitude, latitude, code , description....whats required for mapsource is longtitude , latitude , code and description... i think what i have done when collating these is entered some as example1 and some of what it should be... i think its a case of removing the comma in example1 but logic an computers and xl are a world apart

 

[HMR]

Do like this:

Assume that you have two colums (C & D) of type Text.

In the fifth colum (E) of row 1 write =CONCATENATE(C1;D1)

Duplicate the fifth column downwards. Now you have
in column E what you want to have in column C. OK?

Highlite column E. Copy.

Highlite column C. Paste Special > Values only

Delete column D and E.

OK?

 

[Bumpkin]

In the fifth colum (E) of row 1 write =CONCATENATE(C1;D1)

Or I believe that, if you need a hyphen or other character separating the values, you can do the following:

=(C1 & " - " & D1)

 

[dragonrider]

brilliant, brilliant a genious HMR .. job done thanks..file converted had two corrupt poi that only came to light when adding the rows
thanks for the extra info bumpkin