|
View previous topic :: View next topic
|
| Author |
Message |
Raghuraman_New
New User
Joined: 03 Oct 2008
Posts: 43
Location: Chennai,India.
|
|
|
|
Hi ,
Is there any way to find the number of alphabets in a field using SYNCSORT/DFSORT.
Input
| Code: |
abcd efgh ijklmn
00000000011111111112
12345678901234567890 |
I need to calculate the number of alphabets in between the column 7 to 14 .
So the
Output :-
4 (as 7th column is the alphabet 'e' and it is followed by 3 alphabets ) |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Which product do you actually use - SYNCSORT or DFSORT |
|
| Back to top |
|
|
Raghuraman_New
New User
Joined: 03 Oct 2008
Posts: 43
Location: Chennai,India.
|
|
|
|
We use SYNCSORT V1.2
and the spaces in the input has got removed while pasting in the previous post . Basically we need to know the number of alphabets in between a specified column and the count should not include the "spaces". |
|
| Back to top |
|
|
|
|
