|
View previous topic :: View next topic
|
| Author |
Message |
masoomraza
New User
Joined: 17 May 2022
Posts: 4
Location: India
|
|
|
|
Hi All,
Can anyone please help me with SORT logic to -
- Repeat a given string in a specified column in all subsequent rows until a non-blank text is found in the same column.
Below is my input extract -
| Code: |
2022/04/11 07:35:36 TSO747C
07:35:39 TSO747C
07:41:09 TSO747C
12:35:58 TSO264C
12:36:01 TSO264C
2022/04/12 00:03:14 BDEFAULT
00:03:45 BDEFAULT
00:05:22 BDEFAULT
|
I want it to be like -
| Code: |
2022/04/11 07:35:36 TSO747C
2022/04/11 07:35:39 TSO747C
2022/04/11 07:41:09 TSO747C
2022/04/11 12:35:58 TSO264C
2022/04/11 12:36:01 TSO264C
2022/04/12 00:03:14 BDEFAULT
2022/04/12 00:03:45 BDEFAULT
2022/04/12 00:05:22 BDEFAULT
|
Can anyone please help me with this? |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2141
Location: USA
|
|
|
|
This forum is supposed to provide with hints, no to provide with a ready-to-copy-and-paste solution code.
The hint: try to use SORT statements parameters -
| Code: |
... IFTHEN=(WHEN=GROUP,
BEGIN=(...),
PUSH=(...)) |
P.S.
In that case you MUST read something from any SORT manual/reference. |
|
| Back to top |
|
|
masoomraza
New User
Joined: 17 May 2022
Posts: 4
Location: India
|
|
|
|
Thank you Sir,
Below worked -
| Code: |
INREC IFTHEN=(WHEN=GROUP,BEGIN=(1,4,FS,EQ,NUM),PUSH=(1:1,10))
OPTION EQUALS
SORT FIELDS=COPY
|
|
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1337
Location: Bamberg, Germany
|
|
|
|
| Code: |
OPTION COPY,EQUALS
INREC IFTHEN=(WHEN=GROUP,BEGIN=(1,1,CH,NE,C' '),PUSH=(items)) |
|
|
| Back to top |
|
|
|
|
