|
View previous topic :: View next topic
|
| Author |
Message |
usharaniA
New User
Joined: 22 Jan 2008
Posts: 85
Location: India
|
|
|
|
Hi,
Is there any possibility to count the spaces(blanks) through rexx.
I have requirement to send the ps in excel format.
I used CSV method to get the values in columns but i want the excel sheet of same format of the ps.
For eg.
If the statement is "Good Morning . "
After Good i have 4 spaces so in the excel i want four blank columns after Good. |
|
| Back to top |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania
|
|
|
|
Yes, use a do loop to substr every character and test it for blank.
Now, was that too difficult to think of yourself? SIASD! |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
Why you want to count the SPACES?
Just parse the string. If you find charactor as SPACE then replace it by "," and one extra for delimiter of next field
| Code: |
Good Morning.
to
Good,,,,,Morning.
|
This will leave 4 blank columns between Good and Morning in Excel. |
|
| Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania
|
|
|
|
And what do you do with comma's that already exist?
The whole requirement is far to fuzzy to make any real sense!
The OP seems to want to put blank columns in Excel, but what is he/she going to do if two records look like
| Code: |
AA BB CC DD
XXX YYYY |
Or when the records already contain commas?
The resulting Excel file will look very interesting. |
|
| Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2358
Location: Israel
|
|
|
|
A quick method for counting spaces:
| Code: |
/* REXX */
STR = 'GOOD MORNING'
LEN = LENGTH(STR) - LENGTH(SPACE(STR,0))
EXIT |
O. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
Not an answer, but maybe a solution to the original problem.
In excel you can open CSV's with "Treat consecutive delimiters as one" unchecked. |
|
| Back to top |
|
|
|
|
