Reply to thread

Message

<blockquote data-quote="Dadeo" data-source="post: 823319" data-attributes="member: 27204">Actually .doc file is not so bad. Oddly I manage to use Word to convert lots of data, often using Word Tables.For example you can convert text to table in Word using the '(' as a separator if it is consistent. Or any consistent set of characters.&nbsp; Then clean up the extra crap (e.g. find/replace ')' with nothing). Then you can go to the Layout menu (once you have a table) and convert the table back to text using &quot;, as a separator, or whatever gets you closest to CSV format.&nbsp; You might have to clean up a bit, but it should get you close.&nbsp; Of course, save the file as text so AMC import can read it. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />The biggest problem you have is that each entry/film in the list does not have the same number of 'fields' or data items. In some cases you have (format) and before (runtime), so your third 'column' will end up a mixture of runtime and format with some runtimes in the last column. Guess it depends which is more common - films with format or not - which way is easiest to fix that. Too bad format wasn't last or it would be a lot easier. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" />Hope that helps give you some ideas though.</blockquote>

[QUOTE="Dadeo, post: 823319, member: 27204"] Actually .doc file is not so bad. Oddly I manage to use Word to convert lots of data, often using Word Tables. For example you can convert text to table in Word using the '(' as a separator if it is consistent. Or any consistent set of characters. Then clean up the extra crap (e.g. find/replace ')' with nothing). Then you can go to the Layout menu (once you have a table) and convert the table back to text using ", as a separator, or whatever gets you closest to CSV format. You might have to clean up a bit, but it should get you close. Of course, save the file as text so AMC import can read it. :) The biggest problem you have is that each entry/film in the list does not have the same number of 'fields' or data items. In some cases you have (format) and before (runtime), so your third 'column' will end up a mixture of runtime and format with some runtimes in the last column. Guess it depends which is more common - films with format or not - which way is easiest to fix that. Too bad format wasn't last or it would be a lot easier. ;) Hope that helps give you some ideas though. [/QUOTE]

Verification