• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MobileSheetsPro 1.3.1 and MobileSheetsPro Companion 2.2.3 Released
#11
(01-04-2016, 09:22 AM)Zuberman Wrote: I'm going to see if I can automatically determine what the delimiter is.  I'll search for tabs or other characters that appear to be used as the delimiter for all songs. I'm going to disregard commas, as I agree that those are used in titles and should not be considered.  I believe this should work reliably and in the case that I can't accurately determine what the delimiter is, I'll present the user with the list of possibilities found in the file.  I think I would prefer this over a setting as it should work most if not all of the time, and for those rare cases, the user can pick what they know to be correct.  If people don't like this idea, let me know.

Mike

I tend to find that either "@" or "#" are good as delimiters. Smile

And thank you very much for the update! Big Grin
Reply
#12
Sounds good Mike.

Since commas are out as general delimiters maybe you can let MS recognize them as separators for multiple items in fields other as title. (Like for composers, artists, collections and so on).
Reply
#13
I'm not sure it's a good idea to use comma as a delimiter for anything. Users may want to put commas in other fields, and it increases the complexity if I have to add special delimiting for one field but not others. If people would still prefer comma over |, then I will certainly consider it.
Reply
#14
Thanks for this update Mike. Happy 2016
Reply
#15
LibreOffice allows selecting the separator. Clicke "Save as" and select .csv. After clicking the "Save" button you can select delimiters and character set. I could not find such a selection possibility in Excel. Luckily I switched to LibreOffice a while ago.


Attached Files Thumbnail(s)
   
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1709
http://www.moonlightcrisis.de - http://www.basdjo.de - http://www.frankenbaend.de


Reply
#16
From Microsoft Access I remember a pretty convenient preview window for importing csv or xls files. It allows selecting the separator (with a good automatically detected default setting) and shows a preview of the first lines. Sorry, no screenshot attached. I don't have MSAccess in the moment.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1709
http://www.moonlightcrisis.de - http://www.basdjo.de - http://www.frankenbaend.de


Reply
#17
(01-04-2016, 02:21 PM)Zuberman Wrote: I'm not sure it's a good idea to use comma as a delimiter for anything. Users may want to put commas in other fields, and it increases the complexity if I have to add special delimiting for one field but not others.  If people would still prefer comma over |, then I will certainly consider it.

What do you suggest for separating multiple items? Maybe a semicolon for that and tabs and something else for field separators?
Reply
#18
Thanks for the update and all the hardwork you put into it!!
Samsung Note 10.1 GT-N8013ZW / AirTurn BT-105
Reply
#19
I'm still leaving the pipe symbol | as the separator for multiple values for a particular column. If people would prefer a different character, I'm open to changing it, but I think that character works fairly well in practice. The column delimiter is now automatically calculated in v1.3.2.
Reply
#20
I have my companion set for automatic updates. Update to 2.2.3 has not shown up?

I have clicked on 'Check for updates'

It is not showing that an update is available and is showing version 2.2.2.?

I have never had to do anything in the past to get an update, am I missing something?
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2018 MyBB Group.