Search found 158 matches
- Wed Feb 25, 2015 8:07 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
High poster maybe, but not to be confused with high programmer. I don't even understand half the questions that are posted. Like everyone on this forum, Roger, I too have a reverence for you and your ability, and I am always amazed at the time you give for the simplest of our needs. And a personal i...
- Tue Feb 24, 2015 8:38 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
DC_Excel2Array()
Excel -> Array
"ABC-123" -> "ABC-123"
"ABCDEFG" -> "ABCDEFG"
"123456" -> "123456.0000"
"123456.0000" -> "123456.000"
Excel -> Array
"ABC-123" -> "ABC-123"
"ABCDEFG" -> "ABCDEFG"
"123456" -> "123456.0000"
"123456.0000" -> "123456.000"
- Tue Feb 24, 2015 8:09 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
I have tried to describe this problem on this forum since last month. Many others have offered suggestions and I have tried to explain why their suggestion is not the ultimate solution. You said that you demonstrated for yourself what is happening. I have not tried to describe a different problem. Y...
- Tue Feb 24, 2015 2:14 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
Your example will remove decimals, but the exposure for error exists for data that is all numeric character strings that include decimals and zeros. I have written a workaround that includes a user selection to allow decimals or not. But one dizzy clerk can ruin an inventory data file in a matter of...
- Mon Feb 23, 2015 7:57 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
I cannot upload 'xls' file.
I tried adding 'prg', 'txt', 'test' to the end, still won't take it.
I will send to your email.
I tried adding 'prg', 'txt', 'test' to the end, still won't take it.
I will send to your email.
- Mon Feb 23, 2015 7:42 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
I have written a workaround but it appears to me that Express is adding the zeros so it should be corrected.
Of course, I could be wrong. I was wrong twice last year.
I will send the test file to your email since I cannot upload a 'xls' file here.
Of course, I could be wrong. I was wrong twice last year.
I will send the test file to your email since I cannot upload a 'xls' file here.
- Sun Feb 22, 2015 5:12 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
Roger, I know you're busy, but when you get a chance could you look at this.
I have some users I promised a fix a month ago that are getting restless.
This is a problem in an Express function.
Thanks.
I have some users I promised a fix a month ago that are getting restless.
This is a problem in an Express function.
Thanks.
- Sun Feb 22, 2015 5:07 pm
- Forum: eXpress++ Support
- Topic: Inp_xls.xls=Inp_xls.dbf=>Out_xls.xls:Out_xls.xls=Inp_xls.xls
- Replies: 14
- Views: 23374
Re: Inp_xls.xls=Inp_xls.dbf=>Out_xls.xls:Out_xls.xls=Inp_xls
Look at 'User Contributions' topic 'Importing Excel to Dbf'.
You might get some ideas.
http://bb.donnay-software.com/donnay/vi ... ?f=7&t=238
You might get some ideas.
http://bb.donnay-software.com/donnay/vi ... ?f=7&t=238
- Fri Feb 13, 2015 5:44 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860
Re: Decimal and zeros added to text when using DC_Excel2Arra
[img]s2.jpg[/img]
- Sat Feb 07, 2015 4:12 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 60860