Splitting the Multi Line Cell into Multiple Named Data Source
Hi,
I have linked my template to an Excel database that has multi-line information of part numbers and quantities with special characters. I want to split this data into single lines, remove the special characters, and insert them into multiple object values. These values are linked to an object table in the template.
looking forward for best support.
Thank you
-
Does this mean that the data for record 1 for example is split over multiple lines in your Excel spreadsheet and not all on the same line or that the data in a field itself is split, when looked at in Excel, and displays in multiple lines (wrapped) but is actually only contained in a single field on the table?
0 -
Hi,
Yes i want to connect the excel database centralized and my data is wrapped in one cell and it varies from 1 line to 18 lines it consist of part numbers and qty in [1]
and this has to split in columns removing [ ],
i wish this function works within bartender only instead of creating new excel spreadsheet as this contains multiple line items from M to V columns
as shown in the above image because i have created my bartender template as shown below and there are 9 different type of contracts and
we will have to create 9 templates and i one of the template we will require if condition as the number of part number is above 8 then it has to continue in second label.
and i have created the form to select the records and print the labels.
i hope your are able to understand how i want to connect the excel database and customize the printing.
Thank you,
0 -
That is not going to be easy.
You will need to use a VB InStr command for each line to look for each ] in turn only show those stripping off characters as you go. You would have use a similar command for the quantity field and if that is variable length that would be even more difficult.
I would suggest adding a separate field off the side of your label that gets it data from the database and looks for the eighth ] and only holds data to the right of that. If you name that field you can then set Template2 to print only if that field is not empty
-1 -
Hi,
waiting for your reply...
0 -
Yes this where i need your help to know how, as i was though some website i came across that we can use split function as the data will be in variable length but i don't know how to assign for each line and use the similar command for the quantity field. i request you to help me in solving this problem.
0 -
Sorry you will need to speak to someone who can write VB routines to help or perhaps if you contact Seagull's Professional Services team they could possibly help with this
0
请先登录再写评论。
评论
6 条评论