Skip to main content
Topic: using TAB character in the Pattern field of Automatically Fill Values (Read 257 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

using TAB character in the Pattern field of Automatically Fill Values

I had been trying to use TAB separator in the Pattern field of Automatically Fill Values using clipboard as the source, but can never get it to work

the copied properly edited tags (track number, title, artist, composer, arranger...etc) info from Excel are separated by tabs, so I was hoping to be able to specify TAB character in the Pattern field to directly use the info I have put in a spreadsheet. However, I haven't been able to figure out how to specify TAB character in Pattern field after days of trying. tried chr() and a bunch other tricks people had mentioned for windows title formatting, but none worked. they either broke Pattern field which produced weird results or got ignored in the final tagging

would appreciate if anyone can help or if it's possible to make a feature request for this (what's the process?)

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #1
What if you copy a tab character itself from a text field and paste it into the pattern? On my system it shows as a box.

 

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #2
What if you copy a tab character itself from a text field and paste it into the pattern? On my system it shows as a box.

thanks, this seemed to work after I updated to the latest FB2K

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #3
What if you copy a tab character itself from a text field and paste it into the pattern? On my system it shows as a box.
sorry, I take it back. it doesn't work. only the first TAB character is properly used. subsequent one causes incorrect parsing. it looks as if TAB characters are being treated as spaces, so fb2k is not able to differentiate it

for example, with below content where fields are separated by a space and a TAB (when copying from table or spreadsheet), parsed result only takes the texts before first space for title and gave the rest to Artist such that first track's Artist becomes
Code: [Select]
 NEVER AGAIN 	Artist1


Pattern
Code: [Select]
%tracknumber% 	%title% 	%artist%

Source in clipboard
Code: [Select]
01 	THIS NEVER AGAIN 	Artist1
02 that day!? Artist2
03 misunderstood but ok Artist3
04 princess dial Artist4

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #4
What if you worked it via excel first so as to be able to use something which can be recognized in automatically fill values. Change the tab character in excel into a unique character that is usable, have that unique character be used as separator.

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #5
You are right. As a workaround, maybe insert a column between each field (in Excel) containing a unique string. And use that as the separator.

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #6
You are right. As a workaround, maybe insert a column between each field (in Excel) containing a unique string. And use that as the separator.
Why so complicated? Just save the file as CSV formatted file with the relevant character as separator.

Re: using TAB character in the Pattern field of Automatically Fill Values

Reply #7
I guess I find different processes complicated, such as looking through the settings for this unusual option or installing a new spreadsheet program that has it, accepting its reduced performance and learning to use it, navigating to the directory where the CSV file is and copying its contents to the clipboard from Notepad. If the separator is limited to one character, it may still occur in some indie name.

 
SimplePortal 1.0.0 RC1 © 2008-2020