View previous topic :: View next topic |
Author |
Message |
Aslan Valued Contributor
Joined: 31 May 2001 Posts: 589 Location: Memphis, TN USA
|
Posted: Fri Dec 23, 2011 5:28 pm Post subject: |
|
|
DoT_PiTcH,
Is your "data.dat" file that you are loading into list 29 tab delimited?
Can you provide me with a sample of the data.dat file?
VDS 5 or 6? |
|
Back to top |
|
|
DoT_PiTcH Contributor
Joined: 07 Aug 2002 Posts: 85
|
Posted: Fri Dec 23, 2011 6:04 pm Post subject: |
|
|
yes it is tab delimited
Clinton Keith Hunt 12/16/2011 0 1 0 0 WEATHERFORD 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 1 0 0 1 2) TRUCK 6) NEAR HIT WEATHERFORD TRK SEMI TRACKOR WAS BLOCKING ROAD TO WELL; I ASKED HIM TO MOVE, HE SAID YES & THEN GOT STUCK. HELPER WAS PUTTING TONAGE UNDER TIRE WHILE TRK WAS IN REVERSE. I GOT OUT & STOPPED HIM AND SAID I WOULD PULL HIM BACK 2 FEET. I DID, HE THAKED ME AND I HIM
Raudel Banuelos Sandoval 12/16/2011 0 0 0 0 1 0 1 0 1 0 1 1 1 1 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 1 0 0 0 1 1 FORKLIFT 2) UNLOADING
vds 5
[/code] |
|
Back to top |
|
|
Aslan Valued Contributor
Joined: 31 May 2001 Posts: 589 Location: Memphis, TN USA
|
Posted: Sat Dec 24, 2011 6:30 pm Post subject: |
|
|
Try this
Code: | :EMP_FILTER_COMBOCLICK
# Create Data List
LIST CREATE,29
# Create Temp List
LIST CREATE,30
LIST LOADFILE,29,\\192.168.1.3\STAR2K3_D\BBSM V2.0\data.DAT
%%EMP_FILTER = @DLGTEXT(EMP_FILTER_COMBO)
LIST SEEK,29,0
# Get current field separator
%%FSEP = @FSEP()
OPTION FIELDSEP,@TAB()
REPEAT
# Get Item from Data List and move pointer to next item
%%ITEM = @NEXT(29)
# %B = Name
# %C = Date
# If the name equals the filter then add entire item to the Temp List
IF %%ITEM
PARSE "%B;%C",%%ITEM
INFO %B@CR()%%EMP_FILTER
IF @EQUAL(%B,%%EMP_FILTER, EXACT)
LIST ADD,30,%%ITEM
END
END
UNTIL @NULL(%%ITEM)
# Return to origonal field separator
OPTION FIELDSEP,%%FSEP
# Put contents of the Temp List into the Display Table
LIST ASSIGN,DATA_TABLE,30
DIALOG SET,COUNT_LABEL,@COUNT(30)
DIALOG ENABLE,CLEAR_FILTER_BUTTON
LIST CLOSE,29
LIST CLOSE,30
GOTO EVLOOP |
|
|
Back to top |
|
|
DoT_PiTcH Contributor
Joined: 07 Aug 2002 Posts: 85
|
Posted: Tue Dec 27, 2011 3:07 pm Post subject: |
|
|
Thank You ! |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You can attach files in this forum You can download files in this forum
|
|