Invoice value small set of problems-CodePudding

If I input amount 123456.00 I want to play in small amount, and how to split the 12345600, and finally at the front and a RMB yuan symbol! Online, etc., and master some guidance...

CodePudding user response:

1, small need to break up like this??
123456.00=& gt; 12345600?
2, the RMB=& gt; You can add a text, the data window, can also add expression, like this:
$#, # # 0.00; ($#, # # 0.00)

CodePudding user response:

$#, # # 0.00; ($#, # # 0.00)

CodePudding user response:

reference 1st floor u011428667 response:

1, a lower case need to break up like this??
123456.00=& gt; 12345600?
2, the RMB=& gt; You can add a text, the data window, can also add expression, like this:
$#, # # 0.00; ($#, # # 0.00)

I have RMB now + amount, the amount is a data don't know how many, if be RMB 123456, how should I will split them? Like RMB 1 2 3 4 5 6?

CodePudding user response:

refer to the second floor u011428667 response:

$#, # # 0.00. ($#, # # 0.00)

I have RMB now + amount, the amount is a data don't know how many, if be RMB 123456, how should I will split them? Like RMB 1 2 3 4 5 6?

CodePudding user response:

My way is to put a calculating every column (because some format of the grid is not wide, such as micrometer level line thick range interval between each digital)
Computed columns with the left (right (space (100) + '$' + string (digital), n), 1)
The calculation of each position column n is different

CodePudding user response:

reference 5 floor sun1976 reply:

my way is to put a calculated each column (because some format of the grid is not wide, such as micrometer a line of coarse range interval between each digital)
Computed columns with the left (right (space (100) + '$' + string (digital), n), 1)
The calculation of each location column n different

This study less than RMB for RMB is 2 bytes

CodePudding user response:

Don't know which version you use pb, the new pb is read to the lower version seems to have a leftw, rightw, is that you can pick up Chinese characters

Leftw (rightw (space (100) + '$' + string (digital), n), 1)

CodePudding user response:

refer to 7th floor sun1976 response:

don't know which version you use pb, is to read the new pb, lower version seems to have a leftw, rightw, is that you can pick up Chinese characters

Leftw (rightw (space (100) + '$' + string (digital), n), 1)

We are here to modify the program to print the invoice to set before, was developed by PB5 before, so must be PB5 to modify

You read that can detect to RMB automatic stop? I now is not automatically stop

CodePudding user response:

I this is to deal with that each of a grid, such as check, accounting vouchers printed, the total number of lattice is fixed, so there is no stop, put a computed columns, each lattice RMB is taken to the left of the Spaces,
If other conditions, you need to know how to stop, with lenw (stirng (digital)) can easily to a total want to take how much, write their own code control, meet special such as decimal skip, currency symbol out of the loop, not very hard

CodePudding user response:

Used pb5, do not know the version supplied with no w, take a judgment is not 0-9 and not decimal point after two, otherwise take 1, this yourself

CodePudding user response:

references to the tenth floor sun1976 response:

used pb5, don't know the version supplied with no w, take a judgment is not 0-9 and not decimal point after two, otherwise take 1, this diy

The idea I'll PB5 inside have no W... I am according to this way of thinking to do, but in expression always write the wrong grammar

CodePudding user response:

references 9 f sun1976 response:

I deal with that every one is the grid, such as check, accounting vouchers printed, the total number of lattice is fixed, so there is no stop, put a calculated each lattice column, RMB is taken to the left of the Spaces,
If other conditions, you need to know how to stop, with lenw (stirng (digital)) can easily to a total want to take how much, write their own code control, meet special such as decimal skip, currency symbol out of the loop, not very laborious

What I want is you the purpose of this effect should be with you is the same

CodePudding user response:

Spell list directly, without a currency symbol, to avoid double byte character problem, take after judge whether Spaces, if the current position is a space and a not Spaces replace currency symbol, otherwise normally take
If (left (rightw (space (100) + string (digital), n), 1)='and left (rightw (space (100) + string (digital), n - 1), 1) & gt; "', '$', left (rightw (space (100) + string (digital), n), 1))
So try

CodePudding user response:

Remove the w
If (left (right (space (100) + string (digital), n), 1)='and left (right (space (100) + string (digital), n - 1), 1) & gt; "', '$', left (right (space (100) + string (digital), n), 1))