Address Label From Csv
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,
-
Shotaro Ito
★ BarTender Hero ★
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
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
1 Kommentar