i'm a new user for psm 7. Here's my data resource.

1 |2|3
YP||035020070292960600052503|
it is delimited with "|". after add,the 3rd field is recognized as numbers and it just displayed as 3.50200702929618e+022.

however,i just want to use this field as text to produce barcode. i've tried to change data type that displayed numbers. there's nothing to do for me.

I tried to take top 5 digit like 035020,it showed 35020.so maybe it's the length problem. but new question for me, why it deleted the 1st digit zero? and why it can not show such length numbers??

is there anyone to tell how to solve it,thx!

Try "035020070292960600052503" including the quotes. You don't have to do add quotes to every row, only the first one.

PSM uses the MS Jet Text ISAM driver to interpret CSV files. This driver assigns a data type to each field by analyzing the values in all rows. If a field contains only digits it gets the 'Number' type. In that case leading zeroes are discarded. Adding quotes around one of the values forces the driver to see the field as 'Text'.

thanks a lot.i've solved problem according your method.

by the way, do u know how to show its numbers below the barcode? i just found the express dialogue and wrote the express like CODE128([F3]). however,i can't find the way to setup details,such as style of barcode.

i am also a user of press, a software of printsoft. it provides the guide of barcode,include differnt kind of option to show barcode.

so what about the printshopmail? i'm very interested in main function and use of this software.

If you're using a function like CODE128 you would need to apply a font that shows numbers below the barcode. Problem is, none of the Code128 fonts we supply seem to include those numbers. So I'm not sure how you could manage that, sorry..

Instead of using CODE128 you might want to consider using the Barcode plugin (click on the barcode button on the Tools toolbar). It should show numbers by default, and there's different kind of options you can set in the Properties panel.

cool!i'm done by ur way..haha...thanks a lot!

there's another problem confuse me. i'd like to display something conditionally by using if expression. however ,i wrote different kind of expression according samples and help topics,nothing works.

1. IF([F18] <> 0,[F18],[F16]) this is programmed by online-help
2. IF(<<F18>> <> 0,<<F18>>,<<F16>>) this is programmed by samples download from websites
can you tell me how to display field 18 or field 16 by conditions?

[F18] is correct, but in an expression a field value is always a string. You'll need to convert it to a number before comparing it to a numeric value:

IF (VAL([F18]) <> 0, [F18], [F16])

When you're comparing a string to another string it's not necessary to convert. For example, to see if F18 is empty:

IF (TRIM([F18]) <> "", [F18], [F16])

nice! i am very appreciated for your help. by the way, do u know whether it provides off-line help like chm format to download? it's not quite convenient to refere by internet.

Sure, but I think we only have it as a pdf, not chm.

http://www.objectiflune.com/OL/en-CA/Dow...Cat=UserGuide#1

"PrintShop Mail 7.0 Help"

thanks a lot!

by the way, how can i write several expressions in one variable?
i mean,i created a varaible text like @F18@,and selected "edit expression". i'd like to write more than one if expression in varaible F18.but it showed end expression expected,i tried to use enter,but nothing worked.

what should i do in the condition of several expressions?

Each variable can have only one expression, but you can have multiple variables with different expressions in the same text box. For example, in a text box you could have @a@ on one line and @b@ on the next.