|
View previous topic :: View next topic
|
| Author |
Message |
Vignesh Sid
New User
Joined: 04 Sep 2017
Posts: 43
Location: India
|
|
|
|
Hi all,
I have FB file with record length 3000 with records similar to below code:
| Code: |
----+----1----+----2----+----3----+----4----+----5----+----6
11111111 111 AAAAAAAAAA SUBJECT1
11111111 111 AAAAAAAAAA SUBJECT2
11111111 111 AAAAAAAAAA SUBJECT3
11111111 111 AAAAAAAAAA SUBJECT4
11111111 111 AAAAAAAAAA SUBJECT5
11111111 111 AAAAAAAAAA SUBJECT6
11111111 111 AAAAAAAAAA SUBJECT7
11111111 111 AAAAAAAAAA SUBJECT8
11111111 111 AAAAAAAAAA SUBJECT9
11111111 111 AAAAAAAAAA SUBJECT10
11111111 111 AAAAAAAAAA SUBJECT11
11111112 112 AAAAAAAAAB SUBJECT1
11111112 112 AAAAAAAAAB SUBJECT2
|
The output file can be VB and should be like:
| Code: |
----+----1----+----2----+----3----+----4----+----5----+----6
11111111 111 AAAAAAAAAA SUBJECT1,SUBJECT2,...,SUBJECT11
11111112 112 AAAAAAAAAB SUBJECT1,SUBJECT2
Could anyone suggest me a way to achieve this.
Thanks,
Viky. |
|
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| Sure.Search for RESIZE Or SPLICE in DFSORT. |
|
| Back to top |
|
|
darshansai
New User
Joined: 18 May 2019
Posts: 1
Location: INDIA
|
|
|
|
| could anyone provide solution please |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
Please do not revive old topics.
I would guess that the clues provided were enough for TS to come to a satisfactory solution, so it should also do for you. Read the relevant sections of the manual and experiment. |
|
| Back to top |
|
|
|
|
