Zum Hauptinhalt gehen

Suche

Suche

Splitting the Multi Line Cell into Multiple Named Data Source

Kommentare

6 Kommentare

  • Avatar
    Peter Thane

    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
  • Avatar
    Vishal B Shah

    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
  • Avatar
    Peter Thane

    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
  • Avatar
    Vishal B Shah

    Hi,

    waiting for your reply...

    0
  • Avatar
    Vishal B Shah

    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
  • Avatar
    Peter Thane

    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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.