Address Label From Csv

Legacy Poster

• 2014年10月27日 17:42

Hi,

 

We are integrating a web based order system with 3rd party cilent customer who is using bar tender, our system is exporting CSV file with fields including address fields beaked down to Address Line 1, Address Line 2, State, Post Code, etc.I'm trying to figure out how to format the address right on the from CSV file, in general, the format should be

 

 

Send To:

Title First_Name Last_Name
Address_Line_1
Address_Line_2
City, State, Post_Code
Country

 

In some cases Title is empty so in this case rest of line should be justified to left, in some cases Address_Line 2 is blank, in this case City, State, Post Code and country should step up below title, first_name, last_name.

 

Any help would be appriciated.

 

Thanks,

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 2014年10月28日 02:03

  For Title First_Name Last_Name part, create a text with 5 data sources.

   

  1. Title

  2. _(a space) - Transform >  Suppress when next data source is empty

  3. First_name

  4. _(a space)

  5. Last_name

   

  For Address_Line_1 ... part, Create a multiline text, and add all data sources connected by <<CR>>.

  you can enter newline by <<CR>> from  little Ω icon at right then Control Characters tab.

  0

請登入寫評論。