4
[RecordID] >= [ID_Found]
Custom
keep only records starting at found record
[RecordID] >= [ID_Found]
Error
add ID of record to all records in dataset
add ID of record to all records in dataset
CONTAINS([Input], 'QQ 01********** Start of the Task*************')
Custom
find record containing string
CONTAINS([Input], 'QQ 01********** Start of the Task*************')
RecordID
1
Int32
6
0
add ID
AAAA********NNN***88 1122
BBB*****FFF**887586
CCCC*****8FDFDFR***ADWDE
VF
GB
HN
FV
GB
QQ 01********** Start of the Task*************
ASDSSDLK*************12323
FGKI*****09884
3
aaaaa
bbbbb
ccccc
ddddd
eeeee
fffff
ggggg
hhhhh
iiiii
jjjjj
kkkkk
lllll
mmmmm
Custom
Warning
All
ManualDelayed
2
1234
5678
1290
8789
7856
2308
1234
5678
1290
8789
7856
2308
0009
9999
1111
2222
3333
4444
5555
join on column 1
join on column 1
Custom
Warning
All
ManualDelayed
union "unmatched" results
union "unmatched" results
1
ZZ 01 *** QWERTY ********* AAAAA 1234
ZZ 01 ***ZXCCVBN ********* BBBBB 5678
ZZ 01** QWDFGHJ********* CCCCC 0987
DE01 * ASKDLJFIGO ********* DDDDD 1087
ZZ 01 ***LOIYGFBFUD********* EEEEE 0746
BB 01 **** DDDRRRRTTYYUUU ************************* 1456
split field
Col1 = Trim(Left([Column 1],STRCSPN([Column 1],'*')))
Col2_temp = Trim(SubString...
Horizontal
JoinProblems